Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 26.9Mb
PDF (A4) - 26.9Mb
PDF (RPM) - 25.3Mb
HTML Download (TGZ) - 6.3Mb
HTML Download (Zip) - 6.3Mb
HTML Download (RPM) - 5.4Mb
Man Pages (TGZ) - 158.0Kb
Man Pages (Zip) - 261.3Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

MySQL 5.5 Reference Manual  /  ...  /  Checking InnoDB Availability

14.1.3 Checking InnoDB Availability

To determine whether your server supports InnoDB:

  • Issue the SHOW ENGINES statement to view the available MySQL storage engines. Look for DEFAULT in the InnoDB line.

    mysql> SHOW ENGINES;

    Alternatively, query the INFORMATION_SCHEMA.ENGINES table.

    mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;

    (Now that InnoDB is the default MySQL storage engine, only very specialized environments might not support it.)

  • Issue a SHOW VARIABLES statement to confirm that InnoDB is available.

    mysql> SHOW VARIABLES LIKE 'have_innodb';
  • If InnoDB is not present, you have a mysqld binary that was compiled without InnoDB support and you need to get a different one.

  • If InnoDB is present but disabled, go back through your startup options and configuration file and get rid of any --skip-innodb option.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.