Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Olexandr Melnyk (omelnykgmail.com)
Date: Wed Oct 15 2008 - 13:46:09 CDT
1) OPTIMIZE TABLE is the same as mysqlcheck with "--optimize" flag.
2) Both take care of large chunks of deleted data.
3) As mysqlcheck is just a frontend for OPTIMIZE TABLE command, it should be
replicated in either case.
2008/10/15, Olaf Stein <olaf.steinnationwidechildrens.org>:
> Hi All,
> Just some simple questions I am somehow not able to find an answer to.
> - Does "optimize table tablename" do the same thing as mysqlcheck [options]
> db_name [tables] ?
> - Do they take care of large chunks of deleted data?
> - and I am assuming optimize table would replicate, mysqlcheck I would have
> to run on all slaves, correct?
> ----------------------------------------- Confidentiality Notice:
> The following mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain confidential
> and privileged information. The recipient is responsible to
> maintain the confidentiality of this information and to use the
> information only for authorized purposes. If you are not the
> intended recipient (or authorized to receive information for the
> intended recipient), you are hereby notified that any review, use,
> disclosure, distribution, copying, printing, or action taken in
> reliance on the contents of this e-mail is strictly prohibited. If
> you have received this communication in error, please notify us
> immediately by reply e-mail and destroy all copies of the original
> message. Thank you.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=omelnykgmail.com