[ MYSQL ] Error Messge：Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release

評等結果

點擊便能為這篇文章進行評等！

[評等總次數: 0，平均評等: 0]

先看一下mysql log
vi /var/log/mysql/error.log
看到下面這一段 mysql被關掉了><
151025 15:26:21 [Warning] 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.
151025 15:26:21 [Note] Plugin ‘FEDERATED’ is disabled.
151025 15:26:21 InnoDB: The InnoDB memory heap is disabled
151025 15:26:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151025 15:26:21 InnoDB: Compressed tables use zlib 1.2.8
151025 15:26:21 InnoDB: Using Linux native AIO
151025 15:26:21 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap
(137363456 bytes) failed; errno 12
151025 15:26:21 InnoDB: Completed initialization of buffer pool
151025 15:26:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool
151025 15:26:21 [ERROR] Plugin ‘InnoDB’ init function returned error.
151025 15:26:21 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
151025 15:26:21 [ERROR] Unknown/unsupported storage engine: InnoDB
151025 15:26:21 [ERROR] Aborting
151025 15:26:21 [Note] /usr/sbin/mysqld: Shutdown complete
上網爬解法：
vi /etc/mysql/my.cnf
將原 51行註解掉 key_buffer = 16M
新增這一行 key_buffer_size =16M
將原 57行註解掉 myisam-recover = BACKUP
新增這一行 myisam-recover-options = BACKUP
存檔離開重新啟動 mysql
指令 service mysql restart