Differences

This shows you the differences between two versions of the page.

--- mysql_connections [2016/02/01 07:52] – luke7858
+++ mysql_connections [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-==== mysql/MariaDB connections ====
+=== mysql/MariaDB connections ===
-Viewing current connections
+^ Variable Name ^ Definition ^
-To view connections, log into mysql and run:
+| Threads_connected | The number of currently open connections. |
+| Connections | The number of connection attempts (successful or not) to the MySQL server |
+\\
+Viewing configured connections:
+<sxh bash>
+show variables like "max_connections";
+</sxh>
+From command line:
+<sxh bash>
+mysql -e 'show variables;' | grep max_connections
+</sxh>
+\\
+\\
+View the current connections with:
 <sxh bash>
 SHOW STATUS WHERE `variable_name` = 'Threads_connected';
 </sxh>
 \\
+\\
+**Note**:
+The following command does NOT show current connections, it shows the history of attempted connections (successful or not).
+\\
+http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Connections
+<sxh bash>
+show status like 'Con%'
+</sxh>
 \\
 ==== Configuring Maximum Connections ====
@@ Line 11: / Line 33: @@
 <sxh bash>
+SET GLOBAL max_connections = 200;
 </sxh>
 \\
 \\
 ==== /etc/my.cnf ====
+[mysqld]
 <sxh bash>
+set-variable=max_connections=200
 </sxh>