Re: Data file size

[Aftab Khan]

You can use this command to get actual data/index length

SELECT TABLE_SCHEMA, CONCAT(ROUND(SUM(DATA_LENGTH)/1024/1024/1024),'GB') DATA_SIZE, CONCAT(ROUND(SUM(INDEX_LENGTH)/1024/1024/1024),'GB') INDEX_SIZE
FROM information_schema.tables
WHERE ENGINE='INNODB'
GROUP BY TABLE_SCHEMA;



Regards,
Aftab
Sun Certified MySQL 5.0 DBA



Edited 2 time(s). Last edit at 06/04/2010 05:39AM by Aftab Khan.