Re: MySQL 'locking up'
Perhaps the tmp directory used by MySQL was full. Dawn H wrote: Occasionally, MySQL seems to lock up on the Linux box and just sit there. It did it today for three hours before we realized it. When this happens, the only thing we know of to do is restart it, and this time it wouldn't shut down so we had to reboot the Linux box. Does anyone have any idea what causes this and what we can do to keep it from happening in the future? It's not a good thing when our customers who use MySQL databases suddenly can't access them. Thanks, Dawn H http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 'locking up'
Occasionally, MySQL seems to lock up on the Linux box and just sit there. It did it today for three hours before we realized it. When this happens, the only thing we know of to do is restart it, and this time it wouldn't shut down so we had to reboot the Linux box. Does anyone have any idea what causes this and what we can do to keep it from happening in the future? It's not a good thing when our customers who use MySQL databases suddenly can't access them. Thanks, Dawn H http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 'locking up'
It's sad that your MySQL crashes. But still, it's even more sad that there exist human beings that rely on system administrators not being able to kill a process under linux ;) (don't take that too hard, just kidding) ps aux | grep mysqld get the PID of the process kill -9 PID Make sure you have the rights to do it. Daniel Åkerud Occasionally, MySQL seems to lock up on the Linux box and just sit there. It did it today for three hours before we realized it. When this happens, the only thing we know of to do is restart it, and this time it wouldn't shut down so we had to reboot the Linux box. Does anyone have any idea what causes this and what we can do to keep it from happening in the future? It's not a good thing when our customers who use MySQL databases suddenly can't access them. Thanks, Dawn H http://www.rdcss.com/ - RD Computer Solutions http://wow.cooncheese.com/ - WOW.CoonCheese.com http://dpenguin.rdcss.com/ - Cornucopia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php