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 increasing 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 has 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 is quite significant as if you go and 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 total size of the next batch of tables. 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 the total size of an individual MySQL database. We hope that you found this information useful and that you can adequately check your database size. Of course, our technical team is available 24/7, 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 help.
Nikola is an accomplished tech-savvy extraordinaire with over six years of experience in the web hosting field. He started as a customer care representative and quickly rose the ranks to become a support supervisor and, eventually - the head of the technical department in HostArmada. His deep understanding of the client's needs, combined with his technical knowledge, makes him the perfect man to create the ideal harmony between client satisfaction and professional problem-solving. You will often find him creating helpful tutorials, articles, and blog posts that help existing customers get around.