MySQL Forums
Forum List  »  InnoDB

Re: Data file size
Posted by: Aftab Khan
Date: June 04, 2010 05:37AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
5929
June 02, 2010 07:24AM
1836
June 03, 2010 09:54AM
Re: Data file size
1468
June 04, 2010 05:37AM
1875
June 07, 2010 04:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.