Relation between Database Size and Hardware Resources
As we explained in the Introductory section, in order for a typical MySQL database to exist, it should be stored on the file system of the Web Hosting Server. This means that a portion of the allocated space for each Web Hosting Package will be used by the MySQL databases maintained by the Shared Web Hosting users.Furthermore, whenever a database gets queried by a web application, it uses a different amount of hardware resources like CPU, RAM, and I/O operations. These are required so the MySQL database management service can execute the query against the database and provide the result to the web application that sends it.
If the query targets large collection of rows (for example it selects all the rows in a table), then the MySQL service will require more resources to find and prepare the rows for the web application.
How to check your database size ?
- To check the sizes of your databases, you will need to access the cPanel service for the Web Hosting package you have purchased with us.
- The cPanel service offers a vast amount of features, and you will need to locate the MySQL databases feature specifically. This can be done pretty easily by typing MySQL in the search bar of cPanel.
- The MySQL Databases feature will offer few options separated in different sections. The section you are looking for here is called Current Databases where you will find a table populated with all the databases you currently have and more importantly their sizes.
- Unfortunately, cPanel does not offer the option to order the databases by their actual size so please bear in mind that the databases in the table are by default sorted by name and not by size. Ideally you would want to show all the databases on a single page considering the pagination at the bottom of the Current Databases section.
