[Fixed] [ERROR] /usr/sbin/mysqld: unknown variable 'log_slow_verbosity=query_plan'

2015-01-16

Comments

Error during installing MySQL server 5.5 on Ubuntu 14.04

I got following error when try to install mysql-server-5.5 on ubuntu 14.04:

[ERROR] /usr/sbin/mysqld: unknown variable 'log_slow_verbosity=query_plan'

After that I got

start: Job failed to start

To fix that:

open /etc/mysql/my.cnf for edit and comment following string

log_slow_verbosity=query_plan

Then start installation from scratch:

sudo apt-get install mysql-server

mysql启动很慢的解决办法 | ycz's Blog

2016-09-21 03:09:18

[…] 2、What Could be Causing MySQLD to be very very slow to start but give no errors? 3、[Fixed] [ERROR] /usr/sbin/mysqld: unknown variable ‘log_slow_verbosity=query_plan’ 4、MySQL 日志之–慢查询日志（slow-query-log） 5、unknown variable […]

David

2015-11-13 19:58:47

Im getting the same error, installing sql on ubuntu, hangs when I get the above error.
I comment line from /etc/mysql/my.cnf file and installation completes
try doing a reinstll and it tells me mysql installed
try mysql --version and i get the following:

The program 'mysql' can be found in the following packages:
* mysql-client-core-5.5
* mariadb-client-core-5.5
* mysql-client-core-5.6
* percona-xtradb-cluster-client-5.5
Try: sudo apt-get install

Ready to pull my hair out at this stage ha
Any help would be appreciated

David

2015-11-13 20:05:14

Better Fix, I uninstalled mysql and installed mariaDB instead..no issues, exactly what it says on the tin