Skip to content

Instantly share code, notes, and snippets.

@lemenkov

lemenkov/update_mysql_max_conn.sql

Last active May 1, 2017 18:19
Show Gist options
  • Save lemenkov/11286285 to your computer and use it in GitHub Desktop.
Save lemenkov/11286285 to your computer and use it in GitHub Desktop.
Download ZIP
Increase max_connections in MySQL/MariaDB without restarting mysqld service
Raw
update_mysql_max_conn.sql
# http://www.linux4beginners.info/node/increase-max-connections-mysql-without-restart
select @@max_connections;
set global max_connections = 200;
select @@max_connections;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment