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