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-transaction-tables.html
events_transactions_history: The most recent transaction events that have ended per thread. events_transactions_history_long: The most recent transaction events that have ended globally (across all threads). Statements that work with ...Within the ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
The --plugin-load and --plugin-load-add options load plugins after built-in plugins and storage engines have initialized during the server startup sequence. These can be identified as those that have a library name of NULL in the output from the ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
When finished, note the binary log position up to which you have restored the server for later use, and restart the server. The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
To access query attributes within SQL statements for which attributes have been defined, install the query_attributes component as described in Prerequisites for Using Query Attributes. If multiple attributes are defined with the same name, attempts ... The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data from a MyISAM table. In the worst case, you might have a new clean index file without information about the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
To test how the system behaves when there is a lag. Before MySQL 8.0.26, these transactions have their original_commit_timestamp set to zero, and they appear this way in viewable output. MySQL supports delayed replication such that a replica server ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
However, be careful that the replica does not have temporary tables open; see Section 19.5.1.31, “Replication and Temporary Tables”. The fault tolerance of your system for these types of problems is greatly increased if you have a good ... It is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
From MySQL 8.0.23, the connection is also changed if the currently connected source does not have the highest weighted priority in the group. If multiple sources have the same priority, the replica orders them randomly. The following functions, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
If you have enabled GTID assignment on a replication channel using the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS option of the CHANGE REPLICATION SOURCE TO statement, sql_replica_skip_counter or sql_slave_skip_counter is available. The ... Because ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
You now have the information you need to enable the replica to start reading from the source's binary log in the correct place to start replication. The next step depends on whether you have existing data on the source. Choose one of the following ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...