On 9/15/11 10:29 AM, Mike Copeland wrote: > This happens about every 2 weeks, usually in the middle of the day. When > it happens, the entire database is locked up.
Sounds like it could possibly be a deadlock on a commonly-used table, such as one that generates invoice numbers or such. > Would appreciate any pointers to where I can learn-up on troubleshooting > MySQL problems. Google "mysql locking" to start. Next time it happens you should determine what locks (if any) are open, to eliminate table or row locking contention from the possible problems. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
