Web Development Blog

24K Design Studio :: Blog :: Increase number of mysql max connections
Author:
Password:
Increase number of mysql max connections
14:18, 11 Aug, 2014
by James

By default MySQL set the max connections to 151.

 

This will increase the max connections:

nano /etc/my.cnf

 

In the my.cnf put in the belw 2 lines:

 

[mysqld]

open_files_limit = 8000

max_connections = 1000

 

Save the file and restart mysql.

service mysqld restart

Tags: MySQL CentOS
Reply:
Your name:
Only visible to the author.

Tell us you are not a robot. What is captcha1captchaOcaptcha2 =

Reply
#1
pxcpxgbc
05:03, 25 Nov, 2015
 
1
Reply
Your name:
Only visible to the author.

Tell us you are not a robot. What is captcha1captchaOcaptcha2 =

Reply
View the latest 5 entries.