MySQL Forums
Forum List  »  Optimizer & Parser

Optimizer for innodb does not reduce "data_free"
Posted by: Sebastian Schött
Date: December 06, 2012 03:39AM

System-specs:
-- MySQL Version 9.10 Distrib 5.5.28
-- Fresh installation on SLES 11 SP 2 (64bit) rpm
-- innodb_file_per_table

Problem:
table status of innodb tables shows "data_free=4194304" for several tables of a freshly importet database on a freshly installed database-server! (which means fragmentation?!)

optimize table [tablename] wont change anything - tables are being recreated but data_free value is the same as before.


Since i've set "innodb_file_per_table", i thought data would be stored in the specific tables directory instead of the shared datafile?!

Why can have multiple tables have exactly the same value in data_free?
Why is optimize table not working in that case?

Any clarification would be much appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Optimizer for innodb does not reduce "data_free"
4964
December 06, 2012 03:39AM


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.