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" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List" <mysql@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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]