Enable the slow query log Print

  • 1

log-slow-queries=/var/lib/mysql/slow.log

touch /var/lib/mysql/slow.log
chmod 660 /var/lib/mysql/slow.log
chown mysql:mysql /var/lib/mysql/slow.log

mysqlcheck --auto-repair --check --optimize --all-databases

Kas see vastus oli kasulik?
Back