MySQL Forums
Forum List  »  MyISAM

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
8827
March 21, 2009 01:43AM
3551
March 21, 2009 11:35PM
3071
March 27, 2009 08:24PM
2898
March 29, 2009 11:58PM
3142
March 30, 2009 12:08AM
3014
April 02, 2009 05:15AM
3059
April 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.