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 dnel...@allantgroup.com 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

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

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' for