How do I increase the MySQL connections for my server?

TheCompWiz

Well-known member
Joined
Apr 20, 2016
Messages
116
Best answers
0
Ratings
6
Points
18
#1
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
744
Best answers
0
Ratings
279 1
Points
63
#2
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!
 
Latest Threads
  • Deleted
  • Deleted by fwh
Replies
0
Views
4
Replies
0
Views
32
Similar Threads

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

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