How do I increase the MySQL connections for my server?

TheCompWiz

Well-known member
Registered
Joined
Apr 20, 2016
Messages
130
Points
18
I want to increase MySQL connections for my hosting, what do I need to edit?

I was recommended to copy of one of most suitable for your server file from

Code:
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-small.cnf
to

Code:
/etc/my.cnf
But I am not sure how they will work? and should I do this?
 

fwh

Administrator
Staff Member
Joined
Dec 8, 2012
Messages
773
Points
63
If you are using DA on CentOS then I suggested you update content of my.cnf with content of my-large.cnf in /usr/share/mysql/

cp -f /usr/share/mysql/my-large.cnf /etc/my.cnf
This will make your Mysql server run a bit quicker with the condition is you have to at least 2+ GB of RAM.

Hope it helps!
 
Recommended Threads
Replies
11
Views
6,158
Replies
52
Views
10,321
Replies
1
Views
4,627

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top