Home / server / Questions / 379714
In Process
Garrett
Asked: 2012-04-16 15:24:55 +0800 CST

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

  • 772

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it:

╰$ sudo service mysql restart
stop: Unknown instance:
start: Job failed to start

And this shows in "/var/log/mysql/error.log":

120415 23:01:09 [Note] Plugin 'InnoDB' is disabled.
120415 23:01:09 [Note] Plugin 'FEDERATED' is disabled.
120415 23:01:09 [ERROR] Unknown/unsupported storage engine: InnoDB
120415 23:01:09 [ERROR] Aborting

120415 23:01:09 [Note] /usr/sbin/mysqld: Shutdown complete

I've checked permissions on all the mysql directories to make sure it had ownership and I also renamed the previou ib_logs so that it could remake them. I'm just getting no where with this issue right now, after looking at google results for 2 hours.

ubuntu mysql innodb

6 Answers

  1. After checking the logs I found the following error:

    [ERROR] Unknown/unsupported storage engine: InnoDB

    I removed these files:

    rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1

    at /var/lib/mysql

    This resolved my problem after restart.

    • 62

  2. If you really need skip-innodb (use case: low memory footprint), then of course you don't have to comment it out. However, if InnoDB is the default storage engine, the server will fail to start until you tell it which storage engine to use instead, e.g. default-storage-engine=myisam for MyISAM.

    So, try this:

    $ sudo -u mysql mysqld --skip-innodb --default-storage-engine=myisam
    • 24

  3. If you're using MySQL 5.6+ and want to disable InnoDB, don't forget "--default-tmp-storage" or it won't work:

    To disable InnoDB, use --innodb=OFF or --skip-innodb. In this case, because the default storage engine is InnoDB, the server will not start unless you also use --default-storage-engine and --default-tmp-storage-engine to set the default to some other engine for both permanent and TEMPORARY tables.

    http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb

    You can add this to your my.cnf:

    [mysqld] 
innodb=OFF 
ignore-builtin-innodb 
skip-innodb
default-storage-engine=myisam 
default-tmp-storage-engine=myisam

    just to make sure it'll work.

    • 12

  4. Check your mysql error log.

    tail -100 /var/log/mysql/error.log

    If your log says (like mine did):

    InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
[ERROR] InnoDB: Cannot allocate memory for the buffer pool

    You don't have enough memory to use the default buffer size of 128M

    Edit the config file /etc/mysql/my.cnf adding a line to specify a smaller innodb_buffer_pool_size.

    # make the buffer pool smaller than 128M since we only have 1 GB of total RAM
innodb_buffer_pool_size = 16M

    Save the config file, and start mysql

    sudo service mysql start
    • 9

  5. Try 2 more things. 1. Lower the innodb buffer pool size. 2. Edit mysql initial script and add --innodb option.

    I wonder also if your package is buggy. Could you try a different minor version?

    Also, I assume your mysql server got upgraded as well? Maybe that version is broken? Precise is not final yet.

    • 0

  6. I got this error when I deleted the location I use for tmpdir. If you've recently changed your tmpdir, you might want to check that it's a valid, writable location.

    • 0