Magnet, Monday, August 19, 2002, 11:11:38 PM, you wrote: M> I manage a web server having a lot of http connections, using M> Apache/PHP/MySQL. When there are too many simultaneous connections (so, many M> MySQL requests), MySQL stops working efficiently and makes my load average M> increase a LOT (already seen it at 100 !). The only way to make it decrease M> is to stop MySQL (I am forced to "killall -9 mysqld", since it's the faster M> way and I hardly can do much on the shell while the load is so high).
M> I am using MySQL server 3.53.52 (last stable), and it's working perfectly M> when there is not too many SQL requests... but since it's a large website, M> the problem happens each day at 9pm and we just cannot go on like this. M> As the dedicated server (Linux Red Hat 7.2) is provided by a webhosting M> company, MySQL was already installed when I got root access (although it was M> 3.53.51), and I didn't change the my.cnf file (well, I tried but it wasn't M> working anymore...). Here is my my.cnf file : M> [magnet@ns3286 dev]$ cat /etc/my.cnf M> [mysqld] M> set-variable = connect_timeout=20 M> set-variable = max_connections=100 M> [magnet@ns3286 dev]$ M> (yes I know it's short, tried to put a "basic" one but my tables weren't M> read anymore...). M> Well, I guess my problem is quite common, even if I didn't find any way to M> fix it on the MySQL website! I'm sure there are some MySQL experts around M> there able to help me without telling me to RTFM, since I did so (or tried, M> since IMHO this manual is far from ergonomic). If someone is willing to help M> me, and needs some information not listed there, just ask me, I will answer M> asap... Can you send a list of processes? (mysqladmin processlist) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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