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-statement-summary-tables.html
Example statement event summary information: mysql> SELECT * FROM performance_schema.events_statements_summary_global_by_event_name\G *************************** 1. The Performance Schema maintains tables for collecting current and recent statement ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination), based on the ENABLED and HISTORY column values: When the best match is a row with ENABLED=YES, the INSTRUMENTED ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
For display when events are retrieved from Performance Schema tables, times are shown in picoseconds (trillionths of a second) to normalize them to a standard unit, regardless of which timer is selected. Events are collected by means of ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
The privilege SENSITIVE_VARIABLES_OBSERVER allows a holder to view the values of sensitive system variables in the Performance Schema tables global_variables, session_variables, variables_by_thread, and persisted_variables, to issue SELECT ... The ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
Each set of the pluggable storage engine infrastructure components are designed to offer a selective set of benefits for a particular application. It stands to reason that understanding a particular application's set of requirements and selecting ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
mysqlbinlog has options for selecting sections of the binary log based on event times or position of events within the log. Viewing log contents can be useful when you need to determine event times or positions to select partial log contents prior ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
The new primary uses the source list for the channel to select the source with the highest priority (weight) setting, which might not be the same as the original source. In MySQL 8.0.27 and later, asynchronous connection failover for replicas is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
SELECT statement is issued when row-based replication is in use (binlog_format=ROW). Before issuing RESET MASTER, ensure that you have backups of the server's binary log files and binary log index file, if any, and obtain and save the GTID set held ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions.