Re: Are queries queued?
Hello,
What type of store engine are you using for your tables? This information is needed as the type of locking depends on if your using InnoDB or MyISAM. The query selection is also important since a lock would not be needed if all the queries were simply selecting data from a table. If there was a mix then the read would have to wait for the write to commit since if it didn't you would not get the proper results. More information regarding the MySQL internal locking can be found in the manual itself. It goes into further details about how locks work and the "lock queue" which determines when a query will run based on its priority.
http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html
Hope this helps.
Matt Pellegrino
Support Engineer
mpellegrino @ hosting.com
www.Hosting.com
Subject
Written By
Posted
Re: Are queries queued?
May 15, 2009 02:13PM
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.