User Tools

Site Tools


mysql_maxconnections

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
mysql_maxconnections [2015/04/07 08:56] luke7858mysql_maxconnections [2024/05/23 07:26] (current) – external edit 127.0.0.1
Line 5: Line 5:
 OR if you log into mysql you can use the following command: OR if you log into mysql you can use the following command:
 <sxh bash> <sxh bash>
-show variables like 'max_connections'+show variables like 'max_connections';
 </sxh> </sxh>
 You should have a similar output: You should have a similar output:
Line 29: Line 29:
 [mysqld] [mysqld]
 max_connections = 1000 max_connections = 1000
 +</sxh>
 +\\
 +---------------------------------------------------------------
 +\\
 +=== Setting max user connections ===
 +<sxh bash>
 +mysql -e 'show variables;' | grep -i max_user_connections
 +</sxh>
 +\\
 +<sxh bash>
 +show variables like 'max_user_connections';
 </sxh> </sxh>
mysql_maxconnections.1428396982.txt.gz · Last modified: 2024/05/23 07:26 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki