If you ever have the need to find the answer to the following:
- What are the number of tables in a MySQL database?
- What are the number of rows in a MySQL database?
- How much space is the MySQL database using up on the server?
- How many tables there are in a MySQL server?
- How many rows there are in a MySQL server?
One of the quickest ways to find out MySQL reporting stats is using PHPMyAdmin. The software is usually installed on a number of servers by default, so its just a matter of locating where in the program to find this info.
This is an example of what the stats look like in my test environment server.
- Download and install PHPMyAdmin (I prefer installing it manually since you’ll get the latest version) Debian is really out of date for this package.
- Login to PHPMyAdmin (default location on many installs is mysite.com/phpmyadmin.) I highly recommend moving it to a different folder.
- Click on the “Databases” Tab on the top of the page.
- On the bottom of the page, you should see an “Enable Statistics” link. There is a disclaimer that states “Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.” Its best to run this during times with low traffic in a production environment.
- You should see a table with the list of databases on your server, the number of tables in the database, the number of rows, and data size of the database.
- The last row in the table has the total number of databases, tables, rows, and data in your MySQL server.
- This information is helpful for such things as reports or checking the database overhead.