Management Connect from shell mysql -u root -h giipdb.mysql.com -p -P 3306 -u : user -p : ask password -h : host -P : Port show running SQL show processlist; show full processlist \G Cursor https://codeday.me/jp/qa/20190213/271235.html - jp Binlog(Binary Log) https://www.ritolab.com/entry/98 managing binary log https://www.percona.com/blog/2015/07/30/why-base64-outputdecode-rows-does-not-print-row-events-in-mysql-binary-logs/ Decode binary log Start option Official : https://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html stop mysqladmin -u root -p shutdown Run from sql file Official : https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html Tuning Innodb Check tuning point using mysqltuner You can tune easy by suggestion on mysqltuner $ wget https://github.com/major/MySQLTuner-perl/zipball/master $ unzip master $ cd master $ ./mysqltuner.pl https://corporate.inter-edu.com/developper/1373 innodb storage engine https://enterprisezine.jp/dbonline/detail/3829