Well, it's documented here:
http://dev.mysql.com/doc/internals/en/flush-tables.html
"Every time a thread releases a table, it checks if the refresh
version of the table (updated at open) is the same as the current
refresh_version. If not, it will close it and broadcast a signal on
COND_refresh (
Hi,
If you "open" a table using,
HANDLER tablename OPEN;
and then (in another MySQL command windows), execute,
flush tables with read lock;
The flush tables "hangs" until you execute a
HANDLER tablename CLOSE;
command.
Is this a bug? Can anyone explain this?
Many Regards,
Ian Collins.
-
