var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
MySQL timeout on active connections ??
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.
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 ?
You could limit per user connection.
or you could set the connection time out in the following manner
wait_timeout = 1800
connect_timeout = 10
- Expertise in Windows/Linux server support, IaaS and PaaS Management
- Custom Software Development
Email: exec @ activelobby.net | Skype: unni_active
By Hostiz.com in forum Hosting Security and Technology
Last Post: 04-29-2007, 09:36 PM
By Teckinno in forum Hosting Security and Technology
Last Post: 08-06-2006, 04:32 PM
By Flash Speed in forum Hosting Security and Technology
Last Post: 01-19-2006, 01:24 PM
By ZYE in forum Hosting Security and Technology
Last Post: 11-02-2001, 09:29 PM
By ZYE in forum Dedicated Server
Last Post: 11-02-2001, 12:57 PM