Mysql shows warning: Using unique option is deprecated and will be removed in a future release

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:12:16 UTC

Modified:

2017-02-27 10:05:12 UTC

2

Was this article helpful?


Have more questions?

Submit a request

Mysql shows warning: Using unique option is deprecated and will be removed in a future release

Symptoms

Mysql 5.5 is used. Mysql log shows the following warnings:

    Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.

Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

Cause

key_buffer and myisam-recover are deprecated in Mysql 5.5. myisam-recover option is renamed as of MySQL 5.5.3 to myisam-recover-options .

Resolution

Correct my.cnf as below:

    # egrep "buffer|recover" /etc/mysql/my.cnf

key_buffer_size = 16M
myisam-recover-options = BACKUP
Have more questions? Submit a request
Please sign in to leave a comment.