Search Results
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
For the rewritten query, it additionally considers the access order T3,T1,T2. Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
For rows that match a given OBJECT_TYPE, the Performance Schema checks rows in this order: Rows with OBJECT_SCHEMA='literal' and OBJECT_NAME='literal'. The order in which matching occurs matters because different matching setup_objects rows can have ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
If a query result must have specific row ordering characteristics, include an ORDER BY clause. Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
If this attempt does not work, the replica tries with all the listed sources in descending order of weight, then starts again from the highest weighted source. If multiple sources have the same weight, the replica orders them randomly. This table ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
Options are processed in order, so if an option is specified multiple times, the last occurrence takes precedence. Because later options take precedence over earlier ones, the processing order means that environment variables have the lowest ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
SELECT statements depend on the ordering of rows from the SELECT and this order cannot always be guaranteed, it is possible when logging these statements for the source and the replica to diverge. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
If the highest weighted source is not available, the replica tries with all the listed sources in descending order of weight, then starts again from the highest weighted source. If multiple sources have the same weight, the replica orders them ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transactions.html
In situations where transactions mix updates to transactional and nontransactional tables, the order of statements in the binary log is correct, and all needed statements are written to the binary log even in case of a ROLLBACK. However, when a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
If this attempt does not work, the replica tries with all the listed sources in descending order of priority, then starts again from the highest priority source. If multiple sources have the same priority, the replica orders them randomly. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
On a multi-threaded replica, this means the order of the GTIDs does not necessarily match the order of the transactions, even if replica_preserve_commit_order = 1. You can set up replication channels to assign a GTID to replicated transactions that ...