OPTIMIZE TABLE and Replication

[Mark Arnold]

Hi,

does optimize table, repair table, etc influence the replication - meaning is it possible that it irrepairably throws the slave out of sync with the master?
I had executed "repair table" on the master but killed it while it was still waiting to get a lock on the table. Due the cancellation of the query on the master, the slave aborted synchronization and complained about a possible synchronization failure.

It also suggested setting the replication-skip variable to 1 and calling "start slave", which I did.

Do repair table or optimize table statements disrupt the replication synchonization when they get executed on the master and not the slave, or the other way around?

Also, if the master table needs to be repaired due to some problem, does the slave usually have the same problem? I would assume not, but that's just a guess...

Thanks,

MARK