Set default max_connections of my.cnf Mysql config per RAM.

Saeed Rehman

Live

Alot of people use tools like Ploi/Forge/Runcloud etc. to get stuff ready for them quickly. Many newbie people doesn't have info about max_connections and they don't know that it has to be adjusted according to your server specs. So one of my newbie friend told me that servers created through Ploi doesn't handle traffic as good as runcloud or forge. He said Ploi is bad. I knew that Ploi CANNOT be paid. I always bet on it against others.

I investigated the issue and found out that during server creation, Ploi doesn't tweak the max_connection setting for Mysql no matter what's the spec and size of server. hence when a normal newbie customer sends huge traffic, he gets mysql errors. On the other hand, Forge and Runcloud etc tweak the max_connections setting according do the RAM of server. e.g. 50 to 75 connections per 1 GB of RAM.

I would suggest if Ploi applies this accordingly. Or give buttons in server management page for quick tweaking. same like insights.

Green17

· 1 year ago · Edited

Is this something that could be added as part of the "Insights" tab? like PHP max_children reached etc?

https://ploi.io/documentation/server/how-does-server-insights-work

1 total vote

Green17

· 1 year ago · Edited

Something that would be good on this is that it looks at the current ram and makes a suggestion not just on what ram the server is setup with as we scale this up after development.

1 total vote

Dennis

· 1 year ago

It has been indeed added to the insights! When your server hits the max_connections limit, Ploi will automatically suggest to raise that value now.

no votes yet

Green17

· 1 year ago

Fantastic Dennis. :-)

no votes yet