Example of modifying MySQL default maximum connections

View MySQL Maximum connection data

The code is as follows	Copy Code
Show variables like '%max_connections% '

To modify the method:

Into the MySQL terminal,

The code is as follows	Copy Code
MySQL > Set GLOBAL max_connections=1000; MYSQ > Show variables like '%max_connections% ';

Of course, you can also directly modify the MySQL configuration file. Enter the MySQL installation directory to open the MySQL profile My.ini or my.cnf find max_connections=100 modify the max_connections=1000 service to restart MySQL.
Note: The maximum number of connections allowed by the MySQL server is 16384

another way to do it in a Linux system

The manual compilation version of the MySQL 5.0.33 below CentOS 4.4 illustrates:

The code is as follows	Copy Code
Vi/usr/local/mysql/bin/mysqld_safe

Find Safe_mysqld edit it, find the two lines where the mysqld starts, and then add the arguments back:

The code is as follows	Copy Code
-O max_connections=1500

The specific point is the following location:

The code is as follows

Copy Code

Then $NOHUP _niceness $ledir/$MYSQLD $defaults--basedir= $MY _basedir_version --datadir= $DATADIR $USER _option --pid-file= $pid _file --skip-external-locking -O max_connections=1500 >> $err _log 2>&1 Else Eval "$NOHUP _niceness $ledir/$MYSQLD $defaults--basedir= $MY _basedir_version --datadir= $DATADIR $USER _option --pid-file= $pid _file --skip-external-locking $args -O max_connections=1500 >> $err _log 2>&1 "

Save.

The code is as follows	Copy Code
# Service Mysqld Restart #/usr/local/mysql/bin/mysqladmin-uroot-p variables

Enter the password for the root database account to see

Max_connections 1500 that the new changes have taken effect.