Differences

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

--- mysql_connections [2016/02/01 08:24] – 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';