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

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