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

先看一下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

!去下營經續永站本助幫能就下一點輕輕,話的您到助幫有章文的我果如 如果我的文章有幫助到您的話,輕輕點一下就能幫助本站永續經營下去!

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *