Hi all, I manage a web server having a lot of http connections, using Apache/PHP/MySQL. When there are too many simultaneous connections (so, many MySQL requests), MySQL stops working efficiently and makes my load average increase a LOT (already seen it at 100 !). The only way to make it decrease is to stop MySQL (I am forced to "killall -9 mysqld", since it's the faster way and I hardly can do much on the shell while the load is so high).
I am using MySQL server 3.53.52 (last stable), and it's working perfectly when there is not too many SQL requests... but since it's a large website, the problem happens each day at 9pm and we just cannot go on like this. As the dedicated server (Linux Red Hat 7.2) is provided by a webhosting company, MySQL was already installed when I got root access (although it was 3.53.51), and I didn't change the my.cnf file (well, I tried but it wasn't working anymore...). Here is my my.cnf file : [magnet@ns3286 dev]$ cat /etc/my.cnf [mysqld] set-variable = connect_timeout=20 set-variable = max_connections=100 [magnet@ns3286 dev]$ (yes I know it's short, tried to put a "basic" one but my tables weren't read anymore...). Well, I guess my problem is quite common, even if I didn't find any way to fix it on the MySQL website! I'm sure there are some MySQL experts around there able to help me without telling me to RTFM, since I did so (or tried, since IMHO this manual is far from ergonomic). If someone is willing to help me, and needs some information not listed there, just ask me, I will answer asap... Thank you for your help, it is greatly appreciated! -- Magnet --------------------------------------------------------------------- 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