MySQL Forums
Forum List  »  InnoDB

Re: how to troubleshooting mysql session hang with __lll_lock_wait
Posted by: shenglin du
Date: December 20, 2013 01:43AM

Thanks for your reply, Rick. I am not familar with Linux. How did you get "A search for __lll_lock_wait implies that the problem is with Linux, not with MySQL".
However, I did search in bug.mysql.com and found some related bugs with __lll_lock_wait. Based on stack trace, some waited for ha_commit_trans. some waited for get_schema_tables_result and other waited for "MYSQL_BIN_LOG::find_log_pos".
I got the MySQL binary 5.5.12 tar file from Percona. It worked well in Redhat. For this machine is CentOS. I am not sure if it is related. Shall I install the new binary for CentOS?
That would be great if you can share with me how to analyze this issue.

Thanks
Shenglin

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to troubleshooting mysql session hang with __lll_lock_wait
1342
December 20, 2013 01:43AM


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.