[mysql] mysql: see all open connections to a given database?

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

That should do the trick for the newest MySQL versions:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE DB = "elstream_development";

As well you can use:

mysql> show status like '%onn%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_connects         | 0     |
| Connections              | 303   |
| Max_used_connections     | 127   |
| Ssl_client_connects      | 0     |
| Ssl_connect_renegotiates | 0     |
| Ssl_finished_connects    | 0     |
| Threads_connected        | 127   |
+--------------------------+-------+
7 rows in set (0.01 sec)

Feel free to use Mysql-server-status-variables or Too-many-connections-problem

You can invoke MySQL show status command

show status like 'Conn%';

For more info read Show open database connections

In query browser right click on database and select processlist

SQL: show full processlist;

This is what the MySQL Workbench does.

If you're running a *nix system, also consider mytop.

To limit the results to one database, press "d" when it's running then type in the database name.

In MySql,the following query shall show the total number of open connections:

show status like 'Threads_connected';