How can I check the size of my website's database?

Introduction

A database is an organized collection of information used by your website to perform various tasks and store important data. It is an indispensable part of your website and it is important to keep it neat and free from unnecessary clutter to ensure smooth operation and fast loading speed of your website. Many people, especially those who are not familiar with programming, are not aware that the size of the database of their Website increases, which slows down the application and unnecessarily consumes the resources of your hosting account.

How can I check the load of my MySQL database in cPanel?

The most accurate way to check the size of a database is to check its physical size on the server. This method may seem a bit complicated to most users, so cPanel has replaced it with the implementation of the MySQL® database functionality trivialized and made customers' lives easier. To access it, you need to go to the cPanel of your web hosting account with us.

If you are not sure how to do this, please visit our tutorial To access the cPanel to.

Here are the steps you need to take:

Step 1. After launching the cPanel service, locate and click the MySQL® Databases function icon.

Step 2. After that you will get to the screen where the size of your databases is displayed. You can find this information under the "Current databases" section.

This method of determining the database size is the most objective, as it shows the total size of the entire database, including the InnoDB indexes (.ibd files). This is important because if you check the database size in phpMyAdmin, you may see a different value since phpMyAdmin does not take these .ibd files into account.

Now that we've established that you can check the database size with phpMyAdmin, let's take a look at how to do that. We have a great tutorial that shows, how to access the phpMyAdmin service. The beauty of phpMyAdmin is that it allows you to check the size of each database table.

How can I check the disk usage of MySQL in phpMyAdmin?

Here are the steps you need to follow:

Step 1: After launching the Database Management Tool, please select one of the MySQL databases listed in the left vertical navigation bar.

Step 2: All database tables are listed in the main area. The size of each table is displayed in the penultimate column "Size".

Step 3: To see the total size of this database table, please scroll to the bottom of the screen. In the column "Size" you can see the total size of the database.

Step 4: phpMyAdmin normally limits the number of tables; up to 250 can be displayed. In this case ONLY the size is displayed. To get a more accurate display, please copy the value, remember it or write it down somewhere. Then go to the next page by selecting it from the drop-down menu at the bottom left of the page.

When you select the next page, the screen will refresh. Please scroll down to see the next page of tables. You can do this until you have scrolled through all the pages. Add up all the numbers at the end to get the total size!

So, that was our guide to checking the Total size of a single MySQL database. We hope that this information has helped you and you are now able to check the size of your database. Of course, our support team is available to you around the clock. If you are not able to do this yourself, you are welcome to call a Support ticket open and ask for help. We will be happy to help you.