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 (to await any thread that is waiting for all instances of a table to be closed)." -Sheeri On 5/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
