Hallo,
Some times my Db crash or say to many connections.
I'd like to see who cause that.
How can I see who is connected to mysql?
Thank you in advance for the time you'll spend for answering me.
Mario.

P.S. Any other suggestion is welcame!

"_mario.lat" <_mario.lat (AT) libero (DOT) it> wrote:

As long as MySQL is up and you can log into it [1] you can use the
SHOW [FULL] PROCESSLIST command to see all open connections.

http://dev.mysql.com/doc/refman/5.0/...ocesslist.html


[1] MySQL reserves one connection for the superuser. So make sure
your application connects as non-superuser. Then you can connect
even if the database emits "too many connection" errors.

XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/