MySQL Waits
TODO. This is an unordered dump of information at this point...
Useful Tables/Views
Useful Tables/Views
events_waits_current - The current wait event for each thread.
events_waits_history - The most recent wait events that have ended per thread.
events_waits_history_long - The most recent wait events that have ended globally (across all threads).
performance_schema.setup_timers
performance_schema.setup_consumers
performance_schema.setup_instruments
SELECT *
FROM performance_schema.setup_timers
WHERE name = 'wait';
Bibliography
Bibliography
https://dev.mysql.com/doc/mysql-perfschema-excerpt/5.6/en/performance-schema-wait-tables.htmlhttps://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-tables.htmlhttps://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.htmlhttps://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-history-table.htmlhttps://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-history-long-table.html