Thanks for the answers! When i do a SHOW PROCESSLIST; i get this: ##### mysql> show processlist; +----+------+----------------+------+---------+------+-------+------------------ + | Id | User | Host | db | Command | Time | State | Info | +----+------+----------------+------+---------+------+-------+------------------ + | 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show processlist | | 2 | root | localhost:1117 | NULL | Sleep | 162 | | NULL | | 5 | root | localhost:1132 | aa | Sleep | 89 | | NULL | | 6 | root | localhost:1133 | aa | Sleep | 89 | | NULL | | 7 | root | localhost:1134 | aa | Sleep | 0 | | NULL | | 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL | +----+------+----------------+------+---------+------+-------+------------------ + 6 rows in set (0.00 sec)
mysql> show processlist; +----+------+----------------+------+---------+------+-------+------------------ + | Id | User | Host | db | Command | Time | State | Info | +----+------+----------------+------+---------+------+-------+------------------ + | 1 | root | localhost:1116 | NULL | Query | 0 | NULL | show processlist | | 2 | root | localhost:1117 | NULL | Sleep | 21 | | NULL | | 5 | root | localhost:1132 | aa | Sleep | 124 | | NULL | | 6 | root | localhost:1133 | aa | Sleep | 124 | | NULL | | 7 | root | localhost:1134 | aa | Sleep | 1 | | NULL | | 8 | root | localhost:1135 | aa | Sleep | 0 | | NULL | | 9 | root | localhost:1145 | NULL | Sleep | 1 | | NULL | +----+------+----------------+------+---------+------+-------+------------------ + 7 rows in set (0.00 sec) ##### Does it shows anything abnormal? How do i change that "set global max_connections=900;"? Just execute it from the MySql comand line? >From Mysql Administrator 1.1, i'm seeing the user root, the one i'm using, as having 0 max connections, 0 max updates and 0 queries. Suposedly it will allow for infinite, right? Or will global variables overcome those settings of the user? Thanks for the help! Citando sheeri kritzer <[EMAIL PROTECTED]>: 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 > __________________________________________________________ Sabe quanto gasta com a sua ligação à Internet? Verifique aqui: http://acesso.portugalmail.pt/contas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
