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
> 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"
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc