mysqlinnodbmyisam

How can I check MySQL engine type for a specific table?


My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?


Solution

  • SHOW TABLE STATUS WHERE Name = 'xxx'
    

    This will give you (among other things) an Engine column, which is what you want.