What does optimize mean?
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]
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]
Re: What does optimize mean?
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]