MySQL Forums
Forum List  »  General

Optimize table and fragmentation
Posted by: thota kaarthiik
Date: May 22, 2013 12:09AM


I am trying to optimize a database of around 60GB. I ran mysqlcheck with optimize options and individual optimize table statements in mysql prompt. But I still see the tables as fragmented. I am checking the fragmentation by using the below query.

SELECT TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA NOT IN ('mysql' , 'information_schema') and Data_free > 0

Data_Free for all tables returned by above query is 65.56 MB .

Request you to help me to find out what I am missing.


Options: ReplyQuote

Written By
Optimize table and fragmentation
May 22, 2013 12:09AM

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.