Modify MySQL 5.0.xx default connection number under Linux

This time the server crashes 2 times, has not found the reason, today to see the forum sent the wrong message, think of may be the default number of MySQL connection problems, a check sure enough, God, the default connection number is only 100, how enough ah, on the internet for half a day of information, There are said to modify the MY.CNF, there is said to modify the Safe_mysqld, tried, the former useless, the latter file can not find: The original version is different from the current version.

Anyway I use the MySQL 5.0.33 manually compiled version below CentOS 4.4 for an example to illustrate:

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:

-O max_connections=1500

The specific point is the following location:

In the Red Word special Description:

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 for the root database account to see

Max_connections 1500 that the new changes have taken effect.

There is another way,

To modify the original code:

Unlock the original MySQL code, into the inside of the SQL directory modification mysqld.cc found 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:

{"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 to exit, and then./configure Make;make Install can achieve the same effect