performance_schema tables

There are five main types of table in performance_schema. They are current events tables, event history tables, event summary tables, object instances tables, and setup (configuration) tables:

mysql> SHOW TABLES LIKE '%current%';+------------------------------------------+| Tables_in_performance_schema (%current%) |+------------------------------------------+| events_stages_current                    || events_statements_current                || events_transactions_current              || events_waits_current                     |+------------------------------------------+4 rows in set (0.00 sec)mysql> SHOW TABLES LIKE '%history%';+------------------------------------------+| Tables_in_performance_schema (%history%) |+------------------------------------------+| events_stages_history ...

Get MySQL 8 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.