MySQL biggest tables and databases
http://www.mysqlperformanceblog.com/2008/02/04/finding-out-largest-tables-on-mysql-server/
http://forums.mysql.com/read.php?108,201578,201578
Copy this code and paste it in your HTML
SELECT table_schema
"Data Base Name", sum( data_length
+ index_length
) / 1024 / 1024 "Data Base Size in MB",
sum( data_free
)/ 1024 / 1024 "Free Space in MB"
CONCAT(ROUND(index_length
/ ( 1024 * 1024 * 1024 ), 2), 'G') idx
, CONCAT(ROUND(( data_length
+ index_length
) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size
, ROUND(index_length
/ data_length
, 2) idxfrac
ORDER BY data_length
+ index_length
DESC
Report this snippet
Comments
Subscribe to comments