Hello.
Use OPTIMIZE NO_WRITE_TO_BINLOG syntax. See:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
"Mike Debnam" <[EMAIL PROTECTED]> wrote:
> I issued a optimize table statement on my master which failed with a "lock
> wait timeout" message due to some competing queries runnin
I issued a optimize table statement on my master which failed with a "lock
wait timeout" message due to some competing queries running at the same
time.
Now the statement has been replicated to my slaves, and it completes
successfully. However it's killing the slave input thread with the
following
