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/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel. In a multi-source replication topology, a replica creates a replication channel for each source that it should receive ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
MySQL does not support merging multiple ranges for the range access method for spatial indexes. The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
This example shows the GTID set stored in the gtid_executed system variable (@@GLOBAL.gtid_executed) of a replica that has applied transactions from more than one source: 2174B383-5441-11E8-B90A-C80AA9429562:1-3, ... A global transaction identifier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-flush.html
In addition, if you use FLUSH TABLES when renaming a MyISAM table that is part of a MERGE table, you must issue FLUSH TABLES manually on the replicas. Some forms of the FLUSH statement are not logged because they could cause problems if replicated ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
sort_merge_passes The total number of sort merge passes by occurrences of the statement. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Sort_merge_passes The number of merge passes that the sort algorithm has had to do. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This variable affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). row *************************** @@optimizer_switch: index_merge=on,index_merge_union=on, ... The MySQL server maintains many system ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
The InnoDB, MyISAM, MERGE, MEMORY, and CSV engines are mandatory (always compiled into the server) and need not be installed explicitly. The CMake program provides a great deal of control over how you configure a MySQL source distribution.
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
Merge: Enables a MySQL DBA or developer to logically group a series of identical MyISAM tables and reference them as one object. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default ...