How to modify the default connections of MySQL5.0 in Linux _ MySQL

How to modify the default connections of MySQL5.0 in Linux bitsCN.com during this time, the server crashed twice and no reason was found. today, I saw an error message email from the forum, I think of the problem that may be caused by the default number of connections in mysql. check it out. my god, the default number of connections is only 100. how can this problem be solved? I found some information on the Internet for a long time and said I had to modify my. for cnf, it is said to modify safe_mysqld and try again. The former is useless,
The latter file cannot be found: the original version is different from the current version.
To put it bluntly, I will 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:
Note in red:
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.
Max_connections 1500 indicates that the new change has taken effect.
Another method is as follows:
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:
{"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