天天看點

一台安裝5.5與5.6報unknown variable 'log-slow-queries=/home/mysql/localhost-slow.log' 錯解決方案

一台中有兩個MYSQL,基本一個5.5(rpm包)配置檔案/etc/my.cnf,别外一個5.6 配置檔案/home/app/mysql5.6/my.cnf

5.6上報錯

2016-01-27 00:09:03 16056 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.27-rel75.0 started; log sequence number 1763792

2016-01-27 00:09:03 16056 [ERROR] /home/app/mysql5.6/bin/mysqld: unknown variable 'log-slow-queries=/home/mysql/localhost-slow.log'

2016-01-27 00:09:03 16056 [ERROR] Aborting

2016-01-27 00:09:03 16056 [Note] Binlog end

最終原因是因為MYSQL是合并配置檔案的,是以也找到了5.5中的檔案,因為5.6中 log-slow-queries已經不是那參數了是以報錯

解決把/etc/my.cnf  的log-slow-queries = /home/mysql/localhost-slow.log注釋掉 #log-slow-queries = /home/mysql/localhost-slow.log

5.6版本就可以啟動了。

繼續閱讀