How to get the sizes of the tables of a MySQL database
Below query can be used to get the size of tables in a database in MySQL. We will use information_schema.table system table to get the name for tables and size.
SELECT
table_name AS `Table`,
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE table_schema = "YourDatabaseName";
table_name AS `Table`,
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE table_schema = "YourDatabaseName";
Update the above query according to your database name and you will get the list of tables in specific databases with size in MB.
Determine size of tables in MySQL database - MySQL Tutorial for developers
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.