MySQL Forums
Forum List  »  Quality Assurance

What would cause a table to temporarily locked?
Posted by: Wen Hao Chuang
Date: September 07, 2007 12:29PM

Hi there:

Just curious, we are using MySQL for a while now but recently our web site traffic has increased quite a bit. We are running moodle (moodle.org) which is an open-source LMS. We noticed that sometimes (especially when many concurrent student users are taking the online quiz at the same time), the system would generate wrong score, and we were able to reproduce the problem by manually lock the mdl_quiz_attempts table. So my guess is that when MySQL was really busy (hitted by a lot of users taking the quiz), somehow the mdl_quiz_attempts table got temporarily locked and thus generated the wrong score. Here are my questions:

1. Does the MySQL Enterprise version allow you to monitor this type of "table got locked out" problems?

2. Is this "table got locked up during peak concurrent sessions" a known issue in MySQL? Any way to resolve it?

3. Other online resources that can help us tune MySQL performance?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
What would cause a table to temporarily locked?
3519
September 07, 2007 12:29PM


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.