• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Jaranguda

Belajar Mengajar

  • Home
  • Sponsor/Jasa
  • Tentang

Mengatasi Error MySQL Unknown/unsupported storage engine: InnoDB

Last Updated on 26 February 2020 By tommy Leave a Comment

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

$ sudo -u mysql mysqld

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.

Last Updated on 26 February 2020 by tommy

Tulisan menarik lainnya

  • MySQL Error Access denied for user Debian

    Error yang muncul ● mysql.service - LSB: Start and stop the mysql database server daemon…

  • Mengatasi Error mysql.service has failed

    Log errornya dilihat dari journal -xn -- Unit mysql.service has begun starting up. Feb 12…

  • Mengatasi Error MySQL logger: command not found Debian

    Error yang muncul sewaktu menginstall mysql di Debian 7 Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ... debconf:…

  • Mengatasi Error MySQL The server quit without updating PID file

    Error yang muncul setelah upgrade cPanel [email protected] [~]# service mysql restart ERROR! MySQL server PID…

Filed Under: Linux Tagged With: debian, mysql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Pencarian

Tanya Jawab tentang DevOps SRE CPE, gabung di https://t.me/devopsindonesia

Terbaru

  • Cara Mengganti Port Screen Sharing macOS
  • Cara Menonaktifkan Pager di macOS
  • Cara Mengupdate Nama Apple silicon-as-a-Service Scaleway
  • Cara Force Delete Namespace di Kubernetes
  • Install PHP MariaDB di Mac Monterey

Komentar

  • mazda on Tutorial Lengkap Install Mail Server Postfix Dovecot MariaDB di CentOS 7
  • adi on Menggunakan Mikrotik Sebagai SSH Client
  • aris u on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Bowo on Cara Mematikan SSID Molecool Balifiber
  • aris on Solusi Simple Queue Mikrotik Tidak Berjalan

Tulisan Populer

  • Password Router Huawei HG8245H5 Indihome 1.2m views
  • Password Terbaru ZTE F609 Indihome 784.5k views
  • Password Superadmin Huawei HG8245A 318.8k views
  • Cara Setting Manual Modem GPON ZTE F609 Indihome 273.1k views
  • Cara Setting Wireless ZTE F609 Indihome 257.3k views
  • Mengaktifkan Port LAN di Huawei HG8245 Indihome 170k views
  • Akses UseeTV Indihome via Wireless ZTE F609 156.9k views
  • Kemana Menghilangnya Saldo BCA 50 ribu 153.5k views
  • Cara Reset Password ZTE F609 Indihome 147.6k views
  • Cara Setting DHCP Server Modem/Router ZTE F609 113.6k views

Kategori

  • Delphi
  • dll
  • Gambas
  • Internet
  • Java
  • Lazarus
  • Linux
  • PHP
  • Review
  • Teknologi

Sponsor

kadal.id
carakami.com
kuotabisa.com
Untuk jadi sponsor, hubungi kita lewat halaman sponsor
© 2021. Jaranguda
  • Linux
  • PHP
  • Internet
  • Teknologi
  • Delphi
  • Gambas
  • Java