3 messages in com.mysql.lists.mysqlRe: What does "optimize" mean?
FromSent OnAttachments
Jesse28 Jul 2006 04:51 
Martin Jespersen28 Jul 2006 04:58 
Jesse28 Jul 2006 11:07 
Subject:Re: What does "optimize" mean?
From:Jesse (jl@msdlg.com)
Date:07/28/2006 11:07:23 AM
List:com.mysql.lists.mysql

OK, I missed it this time because I partially typed in something when searching for this in the manual. I searched for "optimiz", and stopped there and ran across "optimization" But missed the OPTIMIZE TABLE entry. Sorry about that. I'll read through that.

Thanks, Jesse

----- Original Message ----- From: "Martin Jespersen" <mb@mbj.dk> To: "Jesse" <jl@msdlg.com> Cc: "MySQL List" <mys@lists.mysql.com> Sent: Friday, July 28, 2006 7:59 AM Subject: Re: What does "optimize" mean?

read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html

Jesse wrote:

Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the "optimize" command mean? What does it do? The help file says that the -o option optimizes, but what does that mean?? I ran it on one of my databases, and most of them said "OK", and some of them said "table is already up to date." But I still have no idea what it did, if anything.

Thanks, Jesse