Skip to content

Instantly share code, notes, and snippets.

@c3ph3us

c3ph3us/update_mysql_max_conn.sql

Forked from lemenkov/update_mysql_max_conn.sql
Created May 1, 2017 18:19
Show Gist options
  • Save c3ph3us/54635bcb2430b63e48b9d9fb5cc95b07 to your computer and use it in GitHub Desktop.
Save c3ph3us/54635bcb2430b63e48b9d9fb5cc95b07 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