You might want to change those. I'm guessing your wait_timeout is set to the default of a day. Is the application letting go of connections? If you do a SHOW PROCESSLIST on the server, is there really only one connection, or are there many?
-Sheeri On 4/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > mysql> SHOW VARIABLES LIKE "max%connect%"; > +----------------------+-------+ > | Variable_name | Value | > +----------------------+-------+ > | max_connect_errors | 10 | > | max_connections | 100 | > | max_user_connections | 0 | > +----------------------+-------+ > 3 rows in set (0.06 sec) > > mysql> > > > Citando sheeri kritzer <[EMAIL PROTECTED]>: > > It's possible that you have max_connections set to something very low, > and/or the application is not letting go of MySQL connections. > > What does the following show you? > > mysql> SHOW VARIABLES LIKE "max%connect%"; > > -Sheeri > > On 4/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I have a program that uses MySql. > > > > When using a MySql 5.0 server, the MySql Administrator shows in the > "health" > > section that the server never passes a perfectly stable limit of 9.1~9.2 > KB/s of > > trafic and never shows more that 1 query (per second). > > Looks like some kind of configuration limitation!? > > > > This makes my application absurdly slow. My mysql 5.0 server was installed > on > > windows with all default settings. > > Any hints at what could be wrong and how to change it? > > __________________________________________________________ > > O email preferido dos portugueses agora com > > 2 000 MB de espaço e acesso gratuito à Internet > > http://www.portugalmail.pt/2000mb > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > __________________________________________________________ > Email gratuito com 2 000 MB > Espaço para guardar 1 milhão de mensagens > http://www.portugalmail.pt/2000mb > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
