How to increase simultaneous connections to mySql

Post Reply
User avatar
Saman
Lieutenant Colonel
Lieutenant Colonel
Posts: 828
Joined: Fri Jul 31, 2009 10:32 pm
Location: Mount Lavinia

How to increase simultaneous connections to mySql

Post by Saman » Tue Jan 09, 2018 1:47 pm

Edit mySql config file

Code: Select all

vi /etc/my.cnf
Right after [mysqld] add following line,

Code: Select all

max_connections = 5000
Note that 5000 is for example purpose. Default is 150 (or 100) which suits most of the servers. Edit with care.
Post Reply

Return to “PHP & MySQL”