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/
Thanks for the answers!
When i do a SHOW PROCESSLIST; i get this:
#
mysql> show processlist;
++--++--+-+--+---+--
+
| Id | User | Host | db | Command | Time | State | Info
|
++--++--+-+-
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 PROTECTE
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!?