Error sewaktu menjalankan MySQL
$ service mysql start[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
|
tidak ada pesan lain selain
failed. Untuk melihat log error MySQL di Debian, jalankan perintah
output perintah diatas
140416 16:59:47 [Warning] 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.
140416 16:59:47 [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.
140416 16:59:47 [Note] Plugin 'FEDERATED' is disabled.
140416 16:59:47 InnoDB: The InnoDB memory heap is disabled
140416 16:59:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140416 16:59:47 InnoDB: Compressed tables use zlib 1.2.7
140416 16:59:47 InnoDB: Using Linux native AIO
140416 16:59:47 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140416 16:59:47 InnoDB: Completed initialization of buffer pool
140416 16:59:47 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140416 16:59:47 [ERROR] Plugin 'InnoDB' init function returned error.
140416 16:59:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140416 16:59:47 [ERROR] Unknown/unsupported storage engine: InnoDB
140416 16:59:47 [ERROR] Aborting
140416 16:59:47 [Note] mysqld: Shutdown complete
|
InnoDB, yang mengakibatkan error. Karena saya tidak menggunakan
InnoDB, maka di file konfigurasi MySQL (/etc/mysql/my.cnf tambahkan
skip-innodb
default-storage-engine=MyISAM
|
dibawah
[mysqld]. Contoh file my.cnf saya setelah di ubah
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-innodb
default-storage-engine=MyISAM
|
setelah selesai, restart MySQL
$ service mysql restart[ ok ] Stopping MySQL database server: mysqld.
[ ok ] Starting MySQL database server: mysqld.
[info] Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..
|
Proses berhasil dijalankan.
sumber :
http://jaranguda.com/mengatasi-error-mysql-unknownunsupported-storage-engine-innodb/
