mysql_connections
This is an old revision of the document!
mysql/MariaDB connections
Log into mysql and vie the current connections with:
SHOW STATUS WHERE `variable_name` = 'Threads_connected';
Note: The following command does NOT show current connections, it shows the history of attempted connections (successful or not).
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Connections
show status like 'Con%'
Configuring Maximum Connections
Run time
SET GLOBAL max_connections = 200;
/etc/my.cnf
[mysqld]
set-variable=max_connections=200
mysql_connections.1454315040.txt.gz · Last modified: 2024/05/23 07:26 (external edit)