MySQL Forums :: General :: Optimize table and fragmentation


Advanced Search

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

Hi,

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.

Thanks,
Kaarthiik

Options: ReplyQuote


Subject Written By Posted
Optimize table and fragmentation thota kaarthiik 05/22/2013 12:09AM
Re: Optimize table and fragmentation Rick James 05/22/2013 08:42PM
Re: Optimize table and fragmentation thota kaarthiik 05/22/2013 09:56PM
Re: Optimize table and fragmentation Rick James 05/23/2013 08:30PM


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.