mysql: see all open connections to a given database?

Question

With administrative permissions im mysql, how can I see all the open connections to a specific db in my server?

Answer 1

Take a look at http://www.devdaily.com/blog/post/mysql/how-show-open-database-connections-mysql

Answer 2

The command is

SHOW PROCESSLIST

Unfortunately, it has no narrowing parameters. If you need them you can do it from the command line:

mysqladmin processlist | grep database-name