PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
This information is stored in the form of “events” that describe the modifications. This can result in different data on source and replica, or cause restored data to differ from the original data. This section describes how MySQL handles binary ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 12.9.6, ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted constructs in filter definitions. The preceding definition can be written like this: { "filter": ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
slave_rows_search_algorithms Command-Line Format --slave-rows-search-algorithms=value System Variable slave_rows_search_algorithms Scope Global Dynamic Yes Type Set Default Value TABLE_SCAN,INDEX_SCAN Valid Values ... This section explains the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into ...The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. This GTID set contains a representation of the set of all committed GTID transactions, and it ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-advantages.html
This makes MERGE indexes much slower on eq_ref searches, but not much slower on ref searches. A MERGE table structured this way could be much faster than using a single large table. If you know exactly what you are looking for, you can search in ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. This means ...The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 13.1.18, “CREATE TABLE Statement”), and can also be ...