Difference between revisions of "MariaDB: max connections"
Jump to navigation
Jump to search
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ||
| + | cat [[/etc/mysql/mariadb.conf.d/50-server.cnf]] | grep max_connections | ||
[[Ubuntu 18.04.5 LTS]] | [[Ubuntu 18.04.5 LTS]] | ||
[[/etc/mysql/mariadb.conf.d/50-server.cnf]]:#max_connections = 100 | [[/etc/mysql/mariadb.conf.d/50-server.cnf]]:#max_connections = 100 | ||
| + | |||
| + | [[SHOW STATUS]] LIKE '%connect%'; | ||
<pre> | <pre> | ||
| − | |||
+-----------------------------------------------+----------+ | +-----------------------------------------------+----------+ | ||
| Variable_name | Value | | | Variable_name | Value | | ||
| Line 30: | Line 32: | ||
18 rows in set (0.005 sec) | 18 rows in set (0.005 sec) | ||
</pre> | </pre> | ||
| + | |||
| + | == Related == | ||
| + | * [[FLUSH STATUS;]] | ||
| + | [[SHOW GLOBAL VARIABLES]] LIKE 'max_connections'; | ||
| + | [[show max connections;]] | ||
== See also == | == See also == | ||
Latest revision as of 16:27, 10 December 2023
cat /etc/mysql/mariadb.conf.d/50-server.cnf | grep max_connections
/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[edit]
SHOW GLOBAL VARIABLES LIKE 'max_connections'; show max connections;
See also[edit]
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.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,/etc/mysql/
Advertising:
