MySQL muestra la advertencia "Using unique option is deprecated and will be removed in a future release"

Created:

2016-11-16 13:12:16 UTC

Modified:

2017-08-16 17:29:34 UTC

14

Was this article helpful?


Have more questions?

Enviar una solicitud

MySQL muestra la advertencia "Using unique option is deprecated and will be removed in a future release"

Applicable to:

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

Síntomas

Se utiliza MySQL 5.5. El registro de MySQL muestra las siguientes advertencias:

    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.

Causa

key_buffer y myisam-recover están en desuso en MySQL 5.5. A partir de MySQL 5.5.3, la opción myisam-recover se denomina myisam-recover-options .

Resolución

Corrija my.cnf de la siguiente forma:

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

    key_buffer_size = 16M
    myisam-recover-options = BACKUP
¿Tiene más preguntas? Enviar una solicitud
Inicie sesión para dejar un comentario.