Home / ubuntu / Questions / 787233
Accepted
Eaten by a Grue
Asked: 2016-06-16 00:49:50 +0800 CST

Wrongly named variables in mysqld.cnf (Ubuntu 16.04)

  • 772

Recently installed Ubuntu 16.04 and found that the default configuration file for MySQL has a few wrongly named variables, i.e. system variables whose name has changed over versions.

In the file /etc/mysql/mysql.conf.d/mysqld.cnf there are the following lines:

table_cache            = 64
log_slow_queries = /var/log/mysql/mysql-slow.log
log-queries-not-using-indexes

The current version of MySQL in use requires these to be named:

table_open_cache
slow_query_log_file
log_queries_not_using_indexes

Respectively. Is this a bug in the Ubuntu release or a problem somewhere else? My question is:

Who is to be blamed for this and should a bug report be filed?

At the very least, perhaps some frustrated individual will find this question and get answers.

16.04

1 Answers

  1. Best Answer

    I downloaded the mysql-server-5.7 package to test:

    $ apt-get download 'mysql-server*'
Get:1 http://mirror.cse.iitk.ac.in/ubuntu xenial-security/main amd64 mysql-server all 5.7.12-0ubuntu1 [10.1 kB]
Get:2 http://mirror.cse.iitk.ac.in/ubuntu xenial-security/main amd64 mysql-server-5.7 amd64 5.7.12-0ubuntu1 [2,584 kB]
Get:3 http://mirror.cse.iitk.ac.in/ubuntu xenial-security/main amd64 mysql-server-core-5.7 amd64 5.7.12-0ubuntu1 [7,503 kB]
Fetched 10.1 MB in 0s (63.8 MB/s)
$ dpkg-deb --fsys-tarfile mysql-server-5.7_5.7.12-0ubuntu1_amd64.deb| tar x ./etc/mysql
$ grep -e table_cache -e log_slow_queries -e log-queries-not-using-indexes ./etc/mysql/mysql.conf.d/mysqld.cnf
#table_cache            = 64
#log_slow_queries       = /var/log/mysql/mysql-slow.log
#log-queries-not-using-indexes

    All three lines were commented out. I'm not sure a commented-out line is a big deal. The package maintainer probably ignores them.

    • 2