Differences

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

--- mysql_connections [2016/02/01 08:09] – luke7858
+++ mysql_connections [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 === mysql/MariaDB connections ===
-Log into mysql and vie the current connections with:
+^ Variable Name ^ Definition ^
+| 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>
 \\
@@ Line 14: / Line 38: @@
 \\
 ==== /etc/my.cnf ====
+[mysqld]
 <sxh bash>
 set-variable=max_connections=200
 </sxh>