DB Governor and mysql advice

Forum

Sign In Here

Sign in to your account

If you are new here please register for an account

Username:

Password:

Remember Me

Forgot Password?

Resolved DB Governor and mysql advice

Hostking
Wednesday, 04 November 2015
Subscribe via email

Hi

We use Mariadb and dbgovernor with cloudlinux.

Now we want to limit each db to 30 connections but also ensure their select queries etc do not overload shared servers.
What is the best way or advice anyone can give us.

Should one enter the username and password of root mysql user into:

Also does this control IO?

Here is one of our configurations:

Any advice for shared hosting server config would be appreciated.

Rate this post:

Responses (0)

04.11.2015 14:11:16
# 1

Bogdan Accepted Answer

Posts: 709
Joined: 26.06.2013

Votes

Undo

Hi,

Limiting number of connection by each user is set to 30 in your configuration, this is done with user_max_connections:

<restrict level1=\"60s\" level2=\"15m\" level3=\"1h\" level4=\"1d\" timeout=\"1h\" log=\"/var/log/dbgovernor-restrict.log\" user_max_connections=\"30\"/>

Yes, you should enter root password for proper governor functionality.

And, yes, limit read/write is what helps controlling IO. Overall default settings are best to start using on shared hosting server. However it could be different as depends from every single moment, server power etc.etc. It is always a balance game, how to provide enough resources for your customer and keep server stable.