I don't see anything abnormal in your show processlist, yes you can change the max_connections global setting from the mysql CLI, but for it to survive restarts/reboots it has to be defined in the my.cnf file ( I guess its my.ini for windows) .....
Kishore Jalleda http://kjalleda.googlepages.com/ On 4/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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] > >
