MariaDB: max connections

cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep max_connections

Ubuntu 18.04.5 LTS

/etc/mysql/mariadb.conf.d/50-server.cnf:#max_connections        = 100

SHOW STATUS LIKE '%connect%';

+-----------------------------------------------+----------+
| Variable_name                                 | Value    |
+-----------------------------------------------+----------+
| Aborted_connects                              | 0        |
| Aborted_connects_preauth                      | 0        |
| Connection_errors_accept                      | 0        |
| Connection_errors_internal                    | 0        |
| Connection_errors_max_connections             | 0        |
| Connection_errors_peer_address                | 0        |
| Connection_errors_select                      | 0        |
| Connection_errors_tcpwrap                     | 0        |
| Connections                                   | 26748314 |
| Max_used_connections                          | 17       |
| Performance_schema_session_connect_attrs_lost | 0        |
| Slave_connections                             | 0        |
| Slaves_connected                              | 0        |
| Ssl_client_connects                           | 0        |
| Ssl_connect_renegotiates                      | 0        |
| Ssl_finished_connects                         | 0        |
| Threads_connected                             | 1        |
| wsrep_connected                               | OFF      |
+-----------------------------------------------+----------+
18 rows in set (0.005 sec)

Related

• FLUSH STATUS;

SHOW GLOBAL VARIABLES LIKE 'max_connections';
show max connections;

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306