MySQL 8.4 Release Notes
Issue a SHOW ENGINES statement to
view the available MySQL storage engines. Look for
DEFAULT in the SUPPORT
column.
mysql> SHOW ENGINES;
Alternatively, query the Information Schema
ENGINES table.
mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;