mysql_connections
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mysql_connections [2016/02/01 08:59] – luke7858 | mysql_connections [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| === mysql/ | === mysql/ | ||
| - | Log into mysql | + | ^ 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: | Viewing configured connections: | ||
| Line 6: | Line 8: | ||
| show variables like " | show variables like " | ||
| </ | </ | ||
| + | From command line: | ||
| + | <sxh bash> | ||
| + | mysql -e 'show variables;' | ||
| + | </ | ||
| + | |||
| + | \\ | ||
| \\ | \\ | ||
| View the current connections with: | View the current connections with: | ||
| Line 20: | Line 28: | ||
| show status like ' | show status like ' | ||
| </ | </ | ||
| - | \\ | ||
| - | ^ Variable Name ^ Definition ^ | ||
| - | | Threads_connected | The number of currently open connections. | | ||
| - | | Connections | The number of connection attempts (successful or not) to the MySQL server | | ||
| \\ | \\ | ||
| ==== Configuring Maximum Connections ==== | ==== Configuring Maximum Connections ==== | ||
mysql_connections.1454317197.txt.gz · Last modified: 2024/05/23 07:26 (external edit)