https://dev.mysql.com/sys-host-summary.html
statement_latency The total wait time of timed statements for the host. statement_avg_latency The average wait time per timed statement for the host. file_io_latency The total wait time of timed file I/O events for the host. These views summarize ...
https://dev.mysql.com/sys-innodb-lock-waits.html
The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, as a TIME value. waiting_trx_age How long the waiting transaction has been ... These views summarize the InnoDB locks that transactions are waiting ...
https://dev.mysql.com/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/sys-user-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the user. max_latency The maximum single wait time of timed statements for the user. lock_latency The total time waiting for locks by timed statements for the user. The ...
https://dev.mysql.com/sys-user-summary-by-statement-type.html
total_latency The total wait time of timed occurrences of the statement event for the user. max_latency The maximum single wait time of timed occurrences of the statement event for the user. lock_latency The total time waiting for locks by timed ...
https://dev.mysql.com/sys-user-summary.html
statement_latency The total wait time of timed statements for the user. statement_avg_latency The average wait time per timed statement for the user. file_io_latency The total wait time of timed file I/O events for the user. These views summarize ...
https://dev.mysql.com/sys-waits-by-host-by-latency.html
total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the host. max_latency The maximum single wait time of timed occurrences of the event for the ...
https://dev.mysql.com/sys-waits-by-user-by-latency.html
total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the user. max_latency The maximum single wait time of timed occurrences of the event for the ...
https://dev.mysql.com/sys-waits-global-by-latency.html
total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event. max_latency The maximum single wait time of timed occurrences of the event. The waits_global_by_latency and ...
https://dev.mysql.com/system-schema.html
Data Dictionary Tables Grant System Tables Object Information System Tables Log System Tables Server-Side Help System Tables Time Zone System Tables Replication System Tables Optimizer System Tables Miscellaneous System Tables The remainder of this ...It contains tables that store information required by the MySQL server as it ...
