DATABASE MYSQL Goes down.

[eluser]Shahgeb[/eluser]
Hy to all,
I am working on site which going live well; since last few days i am facing problem when traffic goes at pick of the days. MY Webserver query connection time not able to kill query connection and due to traffic server goes down.

Is there any situation i can set connection in my index file for connection time to kill the query via command if server is not able to kill it.

thanks for help in advance

[eluser]rogierb[/eluser]
Do a search on wait_timeout and connection_timeout.

The first one kills an idle thread. The other one is used when establishing a connection.

If your network is not that stable, check net_read_timeout and net_write_timeout.

[eluser]Shahgeb[/eluser]
Can you please send me reference of example where i have to use it.
thanks