Knowledgebase

Portal Home > Knowledgebase > Articles Database > MySQL timeout on active connections ??

MySQL timeout on active connections ??

Posted by glace, 10-21-2009, 02:56 PM

Hi, unfortunately my server crashes a lot recently. What happens is that some application creates a MySQL connection which hangs and then MySQL gets overloaded and takes the whole server down. My question: 1. How do I configure MySQL to time out even on active connections ? I.e. after 30 seconds kill the process no matter if it is still active or not. Is that possible ? 2. How do I exclude the root user from that ? Thanks !

---

Posted by activelobby4u, 10-21-2009, 04:39 PM

You could limit per user connection. or you could set the connection time out in the following manner [mysqld] wait_timeout = 1800 connect_timeout = 10

---

Add to Favourites    Print this Article

Passwords and WHM (Views: 602)

UltraHoster.co.uk down / cant be found (Views: 701)

Sell hosting/domains simular to WWD and Dotster? (Views: 643)

OpenVZ based Arch Linux VPS's offline at Virpus,ZoomVPS,BoostVPS and others? (Views: 1069)

Problems determining which reseller would be best (Views: 882)