PAUL MENARD [EMAIL PROTECTED] wrote:
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on
the load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I need to upgrade. Soon).
Machine:
Windows 2000 Advanced Server
2G memory
36G disk space.
I have a Web page that allows my operators to monitor various process tasks on this
server. Sometimes they receive an error that PHP cannot connect to MySQL. If this
happens during the day they call me. I log into the server and bring up the
WinMySQLadmin 3.1 client and click on the 'Process' tab. There are a few (maybe 250
attached processes). I know there are many machines connecting to this database to
feed updates from enterprise applications. So I bumped up the 'max_connections'
limit to 1000. This just seems to delay the limit and the phone call.
My question is in looking at the output form the 'Process' tab I see the columns
'Command' and 'Time'. In all of the rows for 'Command' the value is 90% 'Sleep'.
This would tell me I have some processes out there that are not dis-connecting
(right?). In the 'Time' column is see numbers ranging from 150 to 1000+. I'm
guessing this is the time the connection is idle (correct?). What I would like to do
is define my parameters so that these dead processes will be disconnected by MySQL
after a shorter time but not sure which variable to change. Advice?
You can decrease value of wait_timout variable:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]