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.html
Event collection provides access to information about synchronization calls (such as for mutexes) file and table I/O, table locks, and so forth for the server and for several storage engines. The MySQL Performance Schema is a feature for monitoring ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
This logging order is in contrast with that of the binary log, for which statements are written after they are executed but before any locks are released. The general query log is a general record of what mysqld is doing. The server writes ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
Execution of any statement requiring a write lock on either or both of the slave_master_info and slave_relay_log_info tables is disallowed while replication is ongoing (although statements that perform only reads are permitted at any time). A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
The GET_LOCK(), RELEASE_LOCK(), IS_FREE_LOCK(), and IS_USED_LOCK() functions that handle user-level locks are replicated without the replica knowing the concurrency context on the source. For example, do not issue a statement such as INSERT INTO ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL versions. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
To benefit from this effect, the replica servers must have replica_parallel_type=LOGICAL_CLOCK (from MySQL 8.0.26) or slave_parallel_type=LOGICAL_CLOCK set, and the effect is more significant when binlog_transaction_dependency_tracking=COMMIT_ORDER ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. MySQL then checks each transaction against the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), MASTER_POS_WAIT(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SOURCE_POS_WAIT(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts ...