mariaDB: max connections
Jump to navigation
Jump to search
]]/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)
See also
- 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: