MySQL 8 默认的数据库表中的引擎都是InnoDB

mysql> select distinct(ENGINE) from information_schema.tables;
+--------------------+
| ENGINE             |
+--------------------+
| NULL               |
| InnoDB             |
| CSV                |
| PERFORMANCE_SCHEMA |
+--------------------+
4 rows in set (0.02 sec)

mysql> select distinct(ENGINE) from information_schema.tables;
+--------------------+
| ENGINE             |
+--------------------+
| MEMORY             |
| InnoDB             |
| MyISAM             |
| CSV                |
| PERFORMANCE_SCHEMA |
| NULL               |
+--------------------+
6 rows in set (0.03 sec)
mysql>

mysql> select table_schema,table_name from information_schema.tables where ENGINE='CSV';
+--------------+-------------+
| TABLE_SCHEMA | TABLE_NAME  |
+--------------+-------------+
| mysql        | general_log |
| mysql        | slow_log    |
+--------------+-------------+
2 rows in set (0.00 sec)
mysql> select table_schema,table_name from information_schema.tables where ENGINE='PERFORMANCE_SCHEMA' and table_schema<>'performance_schema';
Empty set (0.01 sec)
mysql> select table_schema,table_name from information_schema.tables where ENGINE='PERFORMANCE_SCHEMA' and table_schema!='performance_schema';
Empty set (0.00 sec)