Difference between revisions of "MariaDB: max connections"
Jump to navigation
Jump to search
| (One intermediate revision by the same user 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]] | ||
| Line 35: | Line 36: | ||
* [[FLUSH STATUS;]] | * [[FLUSH STATUS;]] | ||
[[SHOW GLOBAL VARIABLES]] LIKE 'max_connections'; | [[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:
