Hello Olaf, 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 <[EMAIL PROTECTED]>: > > 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? > > Thanks > Olaf > > ----------------------------------------- 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/[EMAIL PROTECTED] > > -- -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/