Skip navigation links

MySQL Forums :: MyISAM :: SELECT queries Locking Problems


Advanced Search

SELECT queries Locking Problems
Posted by: Irfan Ali ()
Date: March 21, 2009 01:43AM

Hi,

I am facing strange issue redarding mysql locking technique. As per manual mysql didn't use locking mechanism for read queries. but i saw that SELECT queries are locked in the current processess. Might be it is something else & i am getting wrong. To understand more of it look into this:

mysql version 4.1.22-standard log (community version)

*************************** 8. row ***************************
Id: 1793163
User: user
Host: ip address:43483
db: dbname
Command: Query
Time: 39
State: Locked
Info: Select count(id) from tablename where id=1
*************************** 9. row ***************************
Id: 1793164
User: user
Host: ip address:43681
db: dbname
Command: Query
Time: 32
State: Locked
Info: Select count(id) from tablename where id=2
*************************** 10. row ***************************
Id: 1793166
User: dbname
Host: ip address:43752
db: dbname
Command: Query
Time: 30
State: Locked
Info: Select count(id) from tablename where id=3
*************************** 11. row ***************************


where State-->Locked means query is locked by another query & Command-->query what mysql is doing right now as per mysql manual. Now what i am getting this that all queries are locked by one another & they stuck in the queue. Can anyone please investigate this issue and let me know what exactly is going on.

Regards,
Muhammad Irfan

Options: ReplyQuote


Subject Views Written By Posted
SELECT queries Locking Problems 5893 Irfan Ali 03/21/2009 01:43AM
Re: SELECT queries Locking Problems 2834 Rick James 03/21/2009 11:35PM
Re: SELECT queries Locking Problems 2586 Shane Corgatelli 03/27/2009 10:45AM
Re: SELECT queries Locking Problems 2392 Rick James 03/27/2009 08:24PM
Re: SELECT queries Locking Problems 2326 Irfan Ali 03/29/2009 11:58PM
Re: SELECT queries Locking Problems 2329 Rick James 03/30/2009 12:08AM
Re: SELECT queries Locking Problems 2304 Shane Corgatelli 03/30/2009 06:52PM
Re: SELECT queries Locking Problems 2312 Shane Corgatelli 04/01/2009 10:37AM
Re: SELECT queries Locking Problems 2284 Irfan Ali 04/02/2009 05:15AM
Re: SELECT queries Locking Problems 2367 Rick James 04/02/2009 08:28PM


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.