Am 28.01.2011 17:04, schrieb Robinson, Eric: > Just refreshing this topic a bit. Can anyone confirm that FLUSH TABLES > WITH READ LOCK is sufficient to quiesce the InnoBD background threads > per Shawn's message above?
Damned start your brain, read documentations and hear what peopole say http://dev.mysql.com/doc/refman/5.1/en/alter-table-problems.html > If you use ALTER TABLE on a transactional table or if you are using Windows or > OS/2, ALTER TABLE unlocks the table if you had done a LOCK TABLE on it. This > is done because InnoDB and these operating systems cannot drop a table that is > in use. And you will build your business on a hotcopy with external tools beause you do not trust replication? laughable! Do what you want, but dont come back and cry if all goes down You were told in which way you can use rsync with minimum downtime or that replication can be used to stop only salves for a short time and you are acting like a child "mama i will do what i said the whole time"
signature.asc
Description: OpenPGP digital signature