MySQL Forums
Forum List  »  General

Re: Why is my entire database getting locked for a slow select query?
Posted by: DBA Lead
Date: September 07, 2010 08:34PM

I guess you did not read the tutorial properly, the status variables you mentioned were only added in versions 5.1+ and the version of MySQL mentioned in the tutorial is 5.0.67.

Also, when you do FLUSH TABLES WITH READ LOCK; it flushes tables globally and the status variable of interest was Open_files which happens to be a GLOBAL status variable, so there was no need for SHOW GLOBAL STATUS VARIABLES in the particular case even if it weren't a GLOBAL status, since the only point to prove was the significant increase in open files count.

You said, "The recently added hashing to make the lookup civilized (that is, much faster). ", please provide a reference (version no. possibly with a link).

Thanks.

--------------------------------------------------------------------
Geeks Worldwide -- http://www.geeksww.com/keywords/tutorials/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: Why is my entire database getting locked for a slow select query?
September 07, 2010 08:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.