Jeremy, > You use "CHECK TABLE" to see if a "REPAIR" is needed. If you end up needing > to run the repair on your master, you may or may not want to run it on your > slaves (and have that control). But I can't see a need to every blindly > fire off "CHECK TABLE" commands at slaves. > > Can anyone else?
Since you asked - I can think of a reason, but not a good one. If you blindly fire off CHECK TABLE statements to myisam tables they may discover they are corrupt and refuse to let you modify them without repairing first. In which case hopefully your application would break and you would soon notice. By allowing this statement to replicate you now have a very bad way to check all servers down the chain. I think this problem is better solved with replication admin tools. - Morgan _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
