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-data-locks-table.html
For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits Table”. Example data lock information: mysql> SELECT * FROM performance_schema.data_locks\G *************************** 1.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
For more information about the relationship between the three transaction event tables, see Section 29.9, “Performance Schema Tables for Current and Historical Events”. For information about configuring whether to collect transaction events, see ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
The source of information for point-in-time recovery is the set of binary log files generated subsequent to the full backup operation. For example: $> mysqlbinlog --read-from-remote-server --host=host_name --port=3306 --user=root --password ... This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Data in use that is held in the binary log transaction and statement caches during a transaction is in unencrypted format in the memory buffer that stores the cache. Note If you use LOAD DATA when binlog_format=STATEMENT is set, which is not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
The output of mysqlbinlog displays these timestamps in two formats, microseconds from epoch and also TIMESTAMP format, which is based on the user defined time zone for better readability. The addition of immediate_commit_timestamp and ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For more information on setting up a server and client for encrypted connections, see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”. The connection attempt succeeds only if a valid matching Certificate Authority (CA) ... To use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. With the statement based logging format, all statements affecting BLACKHOLE tables are logged, but their effects ignored. For this ... The BLACKHOLE storage engine accepts data but discards it and does not store ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-checksum-table.html
CHECKSUM TABLE returns a checksum that is calculated row by row, using a method that depends on the table row storage format. The storage format is not guaranteed to remain the same between MySQL versions, so the checksum value might change ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. For more information, see Section 15.1.1, “Atomic Data Definition Statement Support”. SELECT always performs an implicit commit (Section ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
Beginning with MySQL 8.0.31, replication filter rules are applied first, prior to making any privilege or row format checks, making it possible to filter out any transactions that fail validation; no checks are performed and thus no errors are ...