How can I check MySQL engine type for a specific table? September 16, 2022 by Tarik SHOW TABLE STATUS WHERE Name="xxx" This will give you (among other things) an Engine column, which is what you want.