When configuring cacti today, we found that as long as the number of spine processes is increased, an error will occur, as shown in the log:
Spine: poller [0] fatal: Connection Failed, error: '000000', message: 'Too worker connections' (spine thread)
After checking, the default connection is too small. I searched the internet and changed it like this:
After the MySQL database is installed, the default maximum number of connections is 100. Generally, the number of connections to forums or websites with a higher traffic is far from enough. There are two ways to increase the default number of connections to MySQL.
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:
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.
There is another method,
Modify originalCode:
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; make install to achieve the same effect.