MySQL Bugs: #34521: deprecated options in sample configuration .cnf files

Bug #34521	deprecated options in sample configuration .cnf files
Submitted:	13 Feb 2008 13:37	Modified:	25 Apr 2009 23:47
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	5.0.54, 5.1.23-rc2, 5.1.30, 6.0	OS:	Any
Assigned to:	Daniel Fischer	CPU Architecture:	Any

Description:
some of the problem apply to 5.0, and some to 5.1.

In the sample config files, my-huge.cnf, my-innodb-heavy-4G.cnf, my-large.cnf, my-medium.cnf, my-small.cnf there are some options which can probably be changed.

My list of problems include (but are not limited to) the following :

o) the entire [isamchk] section is deprecated
o) myisam_max_extra_sort_file_size is deprecated
o) log_long_format is deprecated
o) key_buffer should be replaced with key_buffer_size
o) table_cache should be replaced with table_open_cache in 5.1
o) skip-bdb can be removed in newest 5.0, since bdb is removed

How to repeat:
read 5.0 and 5.1 sample config files and look at deprecated options used.

Thank you for the bug report.

o) default-table-type can be replaced with default-storage-engine

See also Bug#38100.

Another option that should be removed is "innodb_log_arch_dir"

Bug #43934 was marked as a duplicate of this one.

I reported http://bugs.mysql.com/?id=43934 what was jsut marked as a duplicate of this one.  Please add version 6.0.10 the the list of versions affected.

It is a *very mild* description that things 'can be changed'.  They *MUST* be changed and *ASAP* - at least for 6.0 - because:

1) Files are not valid at all.  Server refuses to start with those files! So this is per definition not a S3 but a S1 or S2 now! So please also change this!
2) Files do not at all have configuration settings for Falcon and Maria engines.

Shane reported this 6 weeks ago.  New versions were released since then and nothing was fixed. It is *NOT* impressive how the MySQL developer team do not care at all if people are able to use their product. Well - if people do not use it, they do not report bugs of course!

OK .. thanks.  Let us see what happens!

Changed severity to S2 because the duplicate was S2.

Bug#43931 was marked as a duplicate of this bug.

Not patch pending yet, needs extra work for 5.1 and 6.0.

Same story.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70929

2752 Daniel Fischer	2009-03-31 [merge]
      Bug#34521, removed a bunch of deprecated options from template my.cnf files.
      Imported from 5.1 version of this patch:
      - Removed entire isamchk section. Support for ISAM tables was removed in 5.0.
      - Replaced key_buffer with key_buffer_size (correct spelling).
      - Removed skip-bdb, as BDB is no longer included in 5.0 and above.
      - Removed commented-out bdb_cache_size and bdb_max_lock for the same reason.
      - Removed commented-out innodb_log_arch_dir, deprecated in 5.0.24.
      - Removed myisam_max_extra_sort_file_size, deprecated in 5.0.6. 
      - Removed log_long_format, deprecated in 4.1.
      - Replaced default_table_type with default-storage-engine.
      - Replaced table_cache with table_open_cache.
      - Removed skip-federated, should have been in 5.0 only.
      - Replaced log_slow_queries with slow_query_log, deprecated in 5.1.29.

Queued for 5.1 and 6.0 in *-build.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/72665

2693 Alexander Nozdrin	2009-04-22
      Bug#34521, removed a bunch of deprecated options from template my.cnf files.
      Imported from 5.1 version of this patch:
      - Removed entire isamchk section. Support for ISAM tables was removed in 5.0.
      - Replaced key_buffer with key_buffer_size (correct spelling).
      - Removed skip-bdb, as BDB is no longer included in 5.0 and above.
      - Removed commented-out bdb_cache_size and bdb_max_lock for the same reason.
      - Removed commented-out innodb_log_arch_dir, deprecated in 5.0.24.
      - Removed myisam_max_extra_sort_file_size, deprecated in 5.0.6. 
      - Removed log_long_format, deprecated in 4.1.
      - Replaced default_table_type with default-storage-engine.
      - Replaced table_cache with table_open_cache.
      - Removed skip-federated, should have been in 5.0 only.
      - Replaced log_slow_queries with slow_query_log, deprecated in 5.1.29.

Pushed into 6.0.11-alpha (revid:alik@sun.com-20090423070920-e5lq3vrrqi016z2c) (version source revid:alik@sun.com-20090422171936-27qcbxh2k09lxj2f) (merge vers: 6.0.11-alpha) (pib:6)

Noted in 6.0.11 changelog.

Several deprecated or obsolete settings were removed from the sample
option files.

Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)

Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:timothy.smith@sun.com-20090402052930-78npdzhwd7hg7dav) (merge vers: 6.0.11-alpha) (pib:6)

Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)

Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)

Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)