MySQLTunerインストール
1 2 3 4 5 |
# wget -O /usr/local/src/MySQLTuner.zip https://github.com/rackerhacker/MySQLTuner-perl/archive/master.zip # unzip /usr/local/src/MySQLTuner.zip -d /usr/local/src/ # rm -f /usr/local/src/MySQLTuner.zip |
実行
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
# /usr/local/src/MySQLTuner-perl-master/mysqltuner.pl -user root >> MySQLTuner 1.7.9 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script [!!] Attempted to use login credentials, but they were invalid [root@localhost MySQLTuner-perl-master]# /usr/local/src/MySQLTuner-perl-master/mysqltuner.pl >> MySQLTuner 1.7.9 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script Please enter your MySQL administrative login: root Please enter your MySQL administrative password:※パスワード入力 [OK] Currently running supported MySQL version 5.7.22-log [OK] Operating on 64-bit architecture (略) |
設定例 LAMP環境 CentOS7 MySQL5.7 メモリ32GB ストレージエンジン:InnoDB [crayon-6001 …