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

User · Answer

In query browser right click on database and select processlist

User · Answer

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

User · Answer

SQL  show full processlist   This is what the MySQL Workbench does

User · Answer

You can invoke MySQL show status command     show status like  Conn      For more info read Show open database connections

User · Answer

As well you can use   mysql gt  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

User · Answer

That should do the trick for the newest MySQL versions    SELECT   FROM INFORMATION SCHEMA PROCESSLIST WHERE DB    elstream development

User · Answer

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

User · Answer

In MySql the following query shall show the total number of open connections   show status like  Threads connected

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

Examples related to mysql

Examples related to database