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.]]] right after the table listing FLUSH TABLES WITH READ LOCK. It also means that my plan to write a shell script to reset master & slave databases after a failover will need to be modified, since I can't use a read lock to stabilize the files. Dan Nelson wrote: > 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 active, and mysqladmin closes its connection when it exits. > That means that the lock is valid only for the rest of the commands on > the mysqladmin command line, and I can't really see where any of the > other commands would benefit from having locked tables. > > -- Steve Rapaport World Citizen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php