-------- Original Message -------- Subject: Re: [NF] MySQL seems to be locking up... From: Paul McNett <[email protected]> To: [email protected] Date: 9/15/2011 12:48 PM
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 I was using a TABLELOCK until a few weeks ago, then I rewrote the procedure...now, I'm lock free except for the locks that MySQL decides to use internally. (assuming it does so.) Thanks, I have Googled till my eyes are crossing, but most links are for using MySQL with PHP or other web-server centric situations where you have little if any control over the number of simultaneous connections. Mike _______________________________________________ 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.
