=== mysql/MariaDB connections ===
^ 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>
\\
==== Configuring Maximum Connections ====
== Run time ==

<sxh bash>
SET GLOBAL max_connections = 200;
</sxh>
\\
\\
==== /etc/my.cnf ====
[mysqld]
<sxh bash>
set-variable=max_connections=200
</sxh>