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

by 
SHOW TABLE STATUS WHERE Name="xxx"

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

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. Is there a REAL performance difference between INT and VARCHAR primary keys?
  3. What’s the difference between MyISAM and InnoDB? [duplicate]
  4. MySql: MyISAM vs. Inno DB! [closed]
  5. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  6. Should I always prefer MySQL InnoDB over MyISAM?
  7. MySQL foreign key constraints, cascade delete
  8. How do I see all foreign keys to a table or column?
  9. How to debug Lock wait timeout exceeded on MySQL?
  10. How to properly create composite primary keys – MYSQL
  11. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  12. Howto: Clean a mysql InnoDB storage engine?
  13. How to shrink/purge ibdata1 file in MySQL
  14. MySQL InnoDB not releasing disk space after deleting data rows from table
  15. How to convert all tables from MyISAM into InnoDB?
  16. MyIsam engine transaction support
  17. MySQL InnoDB foreign key between different databases
  18. Force InnoDB to recheck foreign keys on a table/tables?
  19. Bogus foreign key constraint fail
  20. What is MySQL’s default ON DELETE behavior?
  21. How to optimize COUNT(*) performance on InnoDB by using index
  22. How do I repair an InnoDB table?
  23. How to lock a single row
  24. How to enable INNODB in mysql
  25. How to disable index in innodb
  26. MySQL InnoDB: autoincrement non-primary key
  27. How do I rename a MySQL database (change schema name)?
  28. How to regex in a MySQL query
  29. MySQL Integer vs DateTime index
  30. Database corruption with MariaDB : Table doesn’t exist in engine

Leave a Comment