"_mario.lat" <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/en/show-processlist.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/
Bookmarks