"_mario.lat" <_mario.lat@libero.it> wrote:

> 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?

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/