ORC Webhosting Logo

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.

MySQL databases in cPanel
MySQL databases in cPanel

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.

Current databases in cPanel
Current databases in cPanel

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.

select a database in phpMyAdmin
select a database in phpMyAdmin

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

Size of the database tables
Size of the database tables

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.

Select MySQL DB
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.

View MySQL size
Database tables limited to 250 tables per 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.

Hat Ihnen diese Anleitung geholfen?

Fast Wordpress hosting

Your WordPress deserves a home that is as unique as your content. Discover hosting that is tailored to the needs of WordPress!