Skip to content

Instantly share code, notes, and snippets.

@kolunar

kolunar/Ref

Created April 24, 2017 15:23
Show Gist options
  • Save kolunar/9ac4c4ff8cd36118a079b892196dda8b to your computer and use it in GitHub Desktop.
Save kolunar/9ac4c4ff8cd36118a079b892196dda8b to your computer and use it in GitHub Desktop.
Download ZIP
MySQLTuner
Raw
Ref
How To Limit MySQL Max Connections Per User
Ref: https://www.rackaid.com/blog/mysql-connection-limits/
Understanding max_user_connections
http://dev.mysql.com/doc/refman/5.7/en/user-resources.html
Raw
snippet
MySQLTuner-perl
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability.
The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
Compatibility:
MySQL 3.23, 4.0, 4.1, 5.0, 5.1, 5.5, 5.6 (full support)
MariaDB 10.1, 11.0 (full support)
Perl 5.6 or later (with perl-doc package)
Unix/Linux based operating system (tested on Linux, BSD variants, and Solaris variants)
Windows is not supported at this time
Unrestricted read access to the MySQL server (OS root access recommended for MySQL < 5.0)
Ref: http://mysqltuner.com/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment