How to modify the maximum number of mysql concurrent connections _ MySQL

How to modify the maximum number of mysql concurrent connections (connections) bitsCN.com

How to modify the maximum number of mysql concurrent connections

The maximum number of MySQL connections does not matter with MySQL. it mainly depends on the system and business logic.

Method 1: Go to the MYSQL installation directory and open the MYSQL configuration file my. ini or my. cnf to find max_connections = 100 and change it to max_connections = 1000 to restart MYSQL.

Method 2: The maximum number of connections of MySQL is 100 by default. client logon: mysql-uusername-ppassword

Set the new maximum number of connections to 200: mysql> set GLOBAL max_connections = 200

Display the currently running Query: mysql> show processlist

Display Current status: mysql> show status

Exit the client: mysql> exit

View the current maximum number of connections: mysqladmin-uusername-ppassword variables

Method 3: Take mysql 5.0.33 in centos 4.4 as an example:

Vi/usr/local/mysql/bin/mysqld_safe

Find safe_mysqld and edit it. find the two lines started by mysqld and add the following parameters:

-O max_connections = 1500

The specific point is the following position:

Special instructions in red letters: www.bitsCN.com

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.

# Service mysqld restart

#/Usr/local/mysql/bin/mysqladmin-uroot-p variables

Enter the password of the root database account and you will see www.bitsCN.com.

Max_connections 1500 indicates that the new change has taken effect.

There is another method,

Modify the original code:

Unlock the original MySQL code and go to the SQL directory to modify mysqld. cc. find the following line:

{"Max_connections", OPT_MAX_CONNECTIONS,

"The number of simultaneous clients allowed.", (gptr *) & max_connections,

(Gptr *) & max_connections, 0, GET_ULONG, REQUIRED_ARG, 100, 1, 16384, 0, 1,

0 },

Change it to www.bitsCN.com.

{"Max_connections", OPT_MAX_CONNECTIONS,

"The number of simultaneous clients allowed.", (gptr *) & max_connections,

(Gptr *) & max_connections, 0, GET_ULONG, REQUIRED_ARG, 1500, 1, 16384, 0, 1,

0 },

Save the disk and exit./configure; make install to achieve the same effect.

BitsCN.com