amount of concurrent connections mysql

show the current value of current connections on mysql

SHOW VARIABLES LIKE 'max_connections';

to change the value of concurrent mysql connections

SET GLOBAL max_connections=500;

to change permanently the value of concurrent mysql connections, under the [mysqld] section add the following line:

vi /etc/my.cnf.d/server.cnf

[mysqld]
max_connections = 500
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s