PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent The total number of rows returned by statements for the host. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html
By default, rows are sorted by host and descending total latency. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent ... These views summarize information about statements executed, grouped by host and statement ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. 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, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. rows_examined The total number of rows read from the storage engine for the table. rows_examined_avg The average number of rows read from ... These views display normalized statements that have done full table ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
rows_sent The total number of rows returned by occurrences of the statement. rows_sent_avg The average number of rows returned per occurrence of the statement. rows_examined The total number of rows read from storage engines by occurrences of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. set_time The timestamp of the most recent modification to the row. set_by The account that made the most recent modification to the row. The value is NULL if the row has not ...Configuration changes made by updating this table persist across client sessions and server ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent The total number of rows returned by statements for the user. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
By default, rows are sorted by user and descending total latency. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. rows_sent ... These views summarize information about statements executed, grouped by user and statement ...