The command FLUSH TABLES WITH READ LOCK has an
equivalent, supposedly, from mysqladmin.
But whatever it is, it's not documented!
I've unsuccessfully tried
mysqladmin flush-tables --with-read-lock
mysqladmin flush-tables --read-lock
What works? Anyone?
--
Steve Rapaport
World Citizen
In the last episode (Dec 27), Steve Rapaport said:
The command FLUSH TABLES WITH READ LOCK has an equivalent,
supposedly, from mysqladmin.
I doubt it. If the manual says there is it should probably be fixed.
Table locks are only held for as long as the connection that created
them is
Thanks, Dan, that sounds eminently sensible.
In that case, the doc bug becomes:
http://www.mysql.com/doc/F/L/FLUSH.html
which says:
[[[You can also access each of the commands shown above with the
mysqladmin utility, using the flush-hosts, flush-logs, reload, or
flush-tables commands.]]]