MySQL tuning advice needed

[JanKrohn]

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]

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.