How to get the size of a table?

[mister_v]

Hello,

how do I get the size of a table in MB?

Is there a query you can use?

[chris]

You can get size of any table with the following query:

Code: Select all

SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES 
WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";

just replace $DB_NAME with the name of the database and $TABLE_NAME with the name of the table.