A database is an organized collection of information used by your website to perform various tasks and store essential data. It is an indispensable part of your website, and keeping it neat and clean from unnecessary clutter is vital to ensure your site's smooth operation and hasty loading speed. Many people, especially those who are not familiar with coding, are not aware that the size of their website’s database ramps up, consequently making their application slower and needlessly increase their hosting account's resource consumption.
Each hosting solution we offer includes an unlimited number of MySQL databases. You can create as many as you need; however, the disk usage per MySQL database varies based on your plan.
Here are each hosting account's capabilities per database:
The most accurate way of checking each database's size is to check its physical size on the server. This method may seem a bit complex for most users, so cPanel has trivialized it by implementing the MySQL® Databases functionality and made clients' lives easier. To access it, you need to access the cPanel service of your Web hosting account with us.
If you are not sure how to do so, please visit our How to access the cPanel tutorial.
Here are the steps you must undertake:
Step 1. Upon entering the cPanel service, please locate the MySQL® Databases feature icon and click on it.
Step 2. After doing so, you will land on the screen, which will reveal the size of your databases. You will find this information under the "Current Databases" section.
This method of confirming the database size is the most objective one, as it will give you the TOTAL size of the entire database, including the InnoDB indexes (.ibd files). This fact is significant as if you are to check the database size inside phpMyAdmin, you may see a different value, as phpMyAdmin does not reflect these .ibd files.
Now that we touched upon the fact that phpMyAdmin can also allow you to check your database size, let's explore how to do so. We have a great tutorial that can teach you how to access the phpMyAdmin service. The good thing about phpMyAdmin is that it will let you check each database table's size individually.
Here are the steps you must undertake:
Step 1. After entering the database management tool, please select one of the MySQL databases listed in the left vertical navigation panel.
Step 2. Doing so will populate the main section of the screen with all the database tables. Each table's size will show on the second to last column labeled as "Size".
Step 3. To see the total size allocated by this database table, please scroll down to the bottom of the screen. Under the "Size" column, you will see the whole of the database.
Step 4. phpMyAdmin usually limits the tables; it can show to 250. If this is the case, it will ONLY show their size. To get a more precise reading, please copy, remember or write the value down somewhere. Afterward, go to the next page by selecting it from the drop-down menu on the page's bottom-left side.
When you select the next page, the screen will refresh. Please scroll down to the bottom to see the next batch of the tables' total size. You can continue doing this until you have gone through all the pages. Finally, add up all numbers together to get the full size!
Well, that covers our tutorial on how to check an individual MySQL database's total size. We hope that you found this information useful and you can adequately check your database size. Of course, our technical team is 24/7 available at your disposal, so if you cannot do so yourself, feel free to open a support ticket and ask them for assistance. They will be more than happy to assist you.
Daniel, our Content Manager, joined HostArmada with over five years of experience under his belt in the web hosting sector in various roles, including customer care, sales, and technical support. His passion for writing and communications and his experience makes him the ideal person for the job. He is devoted to spreading wisdom and knowledge about the web hosting sector so that both clients and colleagues can benefit greatly. In his words, serving and educating others is the way to mutual prosperity.