MySQL 8.3 Release Notes
Issue the 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;