Get MySQL database and table size

You can get size of the MySQL databases as following.

SELECT table_schema AS "Database Name",

Round(Sum(data_length + index_length) / 1024 / 1024, 1) AS "Size in MB"

FROM information_schema.tables

GROUP BY table_schema;

SELECT table_schema AS "Database Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) AS "Size in MB" FROM information_schema.tables GROUP BY table_schema;

SELECT table_schema AS "Database Name", 
   Round(Sum(data_length + index_length) / 1024 / 1024, 1) AS "Size in MB"
FROM   information_schema.tables 
GROUP  BY table_schema;

And get size of tables.

SELECT TABLE_NAME AS "Table Name",

table_rows AS "Quant of Rows",

ROUND( (data_length + index_length) /1024, 2 ) AS "Size Kb"

FROM information_schema.TABLES

WHERE information_schema.TABLES.table_schema = 'DATABASE NAME HERE'

SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows", ROUND( (data_length + index_length) /1024, 2 ) AS "Size Kb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'DATABASE NAME HERE'

SELECT TABLE_NAME AS "Table Name", 
   table_rows AS "Quant of Rows", 
   ROUND( (data_length + index_length) /1024, 2 ) AS "Size Kb"
FROM   information_schema.TABLES
WHERE   information_schema.TABLES.table_schema = 'DATABASE NAME HERE'

Published by Man Friday