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/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. The GROUP BY and ORDER BY clauses can generate temporary ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...