Re: Ineffective OPTIMIZE TABLES

2010-10-04 Thread George Larson
Aha! You are precisely correct. Thank you! On 3 October 2010 21:16, Dan Nelson wrote: > In the last episode (Oct 03), George Larson said: >> I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free' >> of '3896508416'.  If I'm correctly understanding what I've been >> reading, those

Re: Ineffective OPTIMIZE TABLES

2010-10-03 Thread Dan Nelson
In the last episode (Oct 03), George Larson said: > I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free' > of '3896508416'. If I'm correctly understanding what I've been > reading, those are good conditions to optimize the table. I > understand the part where it maps to 'ALTER' f

Ineffective OPTIMIZE TABLES

2010-10-03 Thread George Larson
Hello all. I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free' of '3896508416'. If I'm correctly understanding what I've been reading, those are good conditions to optimize the table. I understand the part where it maps to 'ALTER' for InnoDB. However, nothing I do seems to aff