Home » Mix » How can I get database table sizes?

How can I get database table sizes?

If you want to get database tables sizes using MySQL you can do it as follows.
MySQL system database called information_schema. It has right information for those who want to get DB table real size.
First of all you must go to the MySQL “information_schema” and get “schema name” of the database from the “SCHEMATA” table.
mysql-databases-schema-names

Following MYSQL Query run in your database.

Then you can view the table sizes like this.
mysql-get-table-size

 

 

How can we get size of the mysql databases?

Just copy and paste,run this query in the phpmyadmin.

Result as following.
mysql-database-sizes

Tags

Similar posts