Optimizer for innodb does not reduce "data_free"
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.
Subject
Views
Written By
Posted
Optimizer for innodb does not reduce "data_free"
4964
December 06, 2012 03:39AM
1887
December 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.