MySQL tuning advice needed

JanKrohn

• May 03, 2016 21:06

Hi, I need to do some SQL tuning, and followed the instructions here: Enable the slow query log However, restarting MySQL produces an error message: Log Messages 2016-05-03 22:00:27 20097 [Note] /usr/sbin/mysqld: ready for connections. 160503 22:00:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160503 22:00:11 mysqld_safe mysqld from pid file /var/lib/mysql/server.heidoc.net.pid ended 2016-05-03 22:00:11 19800 [Note] /usr/sbin/mysqld: Shutdown complete 2016-05-03 22:00:09 19800 [ERROR] /usr/sbin/mysqld: unknown variable 'log-slow-queries=/var/lib/mysql/slow.log' 160503 22:00:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160503 22:00:08 mysqld_safe mysqld from pid file /var/lib/mysql/server.heidoc.net.pid ended 2016-05-03 22:00:08 31475 [Note] /usr/sbin/mysqld: Shutdown complete
Any advice? Thanks! Jan

• 

  cPanelMichael

  • May 10, 2016 20:25

  Hello, The change to this variable in MySQL 5.6 and newer is discussed on the following third-party URL: MySQL Slow Query Log Changes Its Game (& Syntax) | KnowledgeBase | Peaceful MEDIA Thank you.

  0

Please sign in to leave a comment.