Skip navigation links

MySQL Forums :: Optimizer & Parser :: Optimizer for innodb does not reduce "data_free"


Advanced Search

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" 1999 Sebastian Schött 12/06/2012 03:39AM
Re: Optimizer for innodb does not reduce "data_free" 858 Rick James 12/08/2012 01:33PM


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.