Difference between revisions of "MariaDB: max connections"

From wikieduonline
Jump to navigation Jump to search
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{lc}}
+
 
 +
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>
SHOW STATUS LIKE '%connect%';
 
 
+-----------------------------------------------+----------+
 
+-----------------------------------------------+----------+
 
| 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

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[edit]

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

See also[edit]

Advertising: