User Rating: 0 / 5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

When you need to start doing tuning on your database, the first thing you need to modify is the configuration file. So far, it is easy to do this; the ugly part of this is, you may need to restart database daemon if you change a variable. Good news! Some of those variables do not need a server restart.

First, check if the variable you need to modify is dynamic. If it is, do the following:

To verify the current value: SELECT @@max_connections;

To change the value: SET GLOBAL max_connections = 1024;

Enjoy!

blog comments powered by Disqus

About

Read about IT, Migration, Business, Money, Marketing and other subjects.

Some subjects: FusionPBX, FreeSWITCH, Linux, Security, Canada, Cryptocurrency, Trading.