MySQL Forums
Forum List  »  Performance

Re: Query Cache and simultaneous execution
Posted by: Jay Pipes
Date: November 17, 2005 05:19PM

Like I said, if an explicit LOCK TABLES is issued, then the second thread should wait until a cached version is available. Other options would be to pre-populate the cache upon startup (using LOCK TABLES, then running SQL statements which would throw results into cache), using MEMORY tables which get pre-populated on startup and ensuring you issue a SQL_NO_CACHE keyword on those queries you know have extremely volatile result sets.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
1542
November 17, 2005 10:40AM
Re: Query Cache and simultaneous execution
1579
November 17, 2005 05:19PM


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.