MySQL Forums :: MyISAM :: SELECT queries Locking Problems

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