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]
