MySQL show status - active or total connections?
MysqlConnectionMysql Problem Overview
When I run show status like 'Con%'
it shows the number of connections, which is 9972 and constantly growing. Is this an active number of connections or connections made in total?
Mysql Solutions
Solution 1 - Mysql
According to the docs, it means the total number throughout history:
> Connections
>
> The number of connection attempts (successful or not) to the MySQL server.
You can see the number of active connections either through the Threads_connected
status variable:
> Threads_connected
>
> The number of currently open connections.
mysql> show status where `variable_name` = 'Threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 4 |
+-------------------+-------+
1 row in set (0.00 sec)
... or through the show processlist
command:
mysql> show processlist;
+----+------+-----------------+--------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------------+--------+---------+------+-------+------------------+
| 3 | root | localhost | webapp | Query | 0 | NULL | show processlist |
| 5 | root | localhost:61704 | webapp | Sleep | 208 | | NULL |
| 6 | root | localhost:61705 | webapp | Sleep | 208 | | NULL |
| 7 | root | localhost:61706 | webapp | Sleep | 208 | | NULL |
+----+------+-----------------+--------+---------+------+-------+------------------+
4 rows in set (0.00 sec)
Solution 2 - Mysql
SHOW STATUS WHERE `variable_name` = 'Threads_connected';
This will show you all the open connections.
Solution 3 - Mysql
You can also do
SHOW STATUS WHERE `variable_name` = 'Max_used_connections';
Solution 4 - Mysql
This is the total number of connections to the server till now. To find current conection status you can use
> mysqladmin -u
This will show you:
Threads_connected 12
Threads_running 1
Threads_connected: Number of connections
Threads_running: connections currently running some sql
Solution 5 - Mysql
To see a more complete list you can run:
show session status;
or
show global status;
See this link to better understand the usage.
If you want to know details about the database you can run:
status;
Solution 6 - Mysql
In order to check the maximum allowed connections, you can run the following query:
SHOW VARIABLES LIKE "max_connections";
To check the number of active connections, you can run the following query:
SHOW VARIABLES LIKE "max_used_connections";
Hope it helps.
Solution 7 - Mysql
As per doc http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Connections
Connections
The number of connection attempts (successful or not) to the MySQL server.
Solution 8 - Mysql
It should be the current number of active connections. Run the command processlist
to make sure.
URL for reference: http://www.devdaily.com/blog/post/mysql/how-show-open-database-connections-mysql
EDIT: https://stackoverflow.com/questions/824428/number-of-db-connections-opened Please take a look here, the actual number of threads (connections) are described here!