MySQL / MariaDB 튜닝

• https://github.com/major/MySQLTuner-perl

위의 스크립트를 사용하여 기본적인 튜닝 포인트를 분석할 수 있다.

• MySQL 8 (partial support, password checks don't work)
• MySQL 5.7 (full support)
• MySQL 5.6 (full support)
• MariaDB 10.3 (full support)
• MariaDB 10.2 (full support)
• MariaDB 10.1 (full support)
• MariaDB 10.0 (full support, 6 last month support)
• Percona Server 5.7 (full support)
• Percona Server 5.6 (full support)
• Percona XtraDB cluster (full support)
• MySQL 3.23, 4.0, 4.1, 5.0, 5.1, 5.5 (partial support - deprecated version)
• 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 (Help wanted !!!!!)
• Unrestricted read access to the MySQL server (OS root access recommended for MySQL < 5.1)
• CVE vulnerabilities detection support from https://cve.mitre.org

• http://mcchae.egloos.com/m/11063919