How to re-simulate a long query stuck in mysql queue?
Can you please share more on what queries are you running? I think, you can make use of InnoDB engine which will do row level locking instead of table level lock. Also you can make you of slow query log which will log all the queries taking more than n seconds (as specified in config)