mariaDB: max connections

From wikieduonline
Revision as of 18:52, 4 June 2022 by Welcome (talk | contribs)
Jump to navigation Jump to search

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

See also

Advertising: