26.1.1 查看MySQL是否支持performance_schema

26.1.1　查看MySQL是否支持performance_schema

要想使用performance_schema数据库分析MySQL，就需要先确定当前数据库是否支持performance_schema数据库。查看当前数据库的版本信息：

---

mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.18    |
+-----------+
1 row in set (0.00 sec)

---

performance_schema在MySQL中实际上会被当作存储引擎。可以在MySQL的information数据库的engines数据表中查看是否支持performance_schema。

---

mysql> SELECT engine,support FROM information_schema.engines
    -> WHERE engine='PERFORMANCE_SCHEMA';
+--------------------+---------+
| engine             | support |
+--------------------+---------+
| PERFORMAN