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/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-pool-tables.html
In the case of tp_thread_state, all rows for a thread group comprise a snapshot in time. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
update_latency The total wait time of timed updates in the index. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency views have these columns: event_class The event class. total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait ... These views summarize wait class average latencies, grouped by event ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
The wait_classes_global_by_latency and x$wait_classes_global_by_latency views have these columns: event_class The event class. total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of ... These views summarize wait class total latencies, grouped by event ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
By default, rows are sorted by descending error and warning counts. The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. last_seen The time at which the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cpudata-1sec.html
The cpudata_1sec table provides data about CPU usage per second over the last 20 seconds.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cpudata-20sec.html
The cpudata_20sec table provides data about CPU usage per 20-second interval over the last 400 seconds.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cpudata-50ms.html
The cpudata_50ms table provides data about CPU usage per 50-millisecond interval over the last second.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. There is no default setting for the timeout, so if you do ...The current primary becomes a read-only secondary, and the specified group member becomes the read-write ... The ...