PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
This section describes the AUTO_INCREMENT lock modes, usage implications of different AUTO_INCREMENT lock mode settings, and how InnoDB initializes the AUTO_INCREMENT counter. InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY clause. The name of a user variable used for this purpose must match the name of a field from the XML file, ...
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/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
(The example shown earlier illustrates how this can occur.) The query specifies a search value that is within the hour of entry into DST in the session time zone. (This is the same type of conversion performed by the CONVERT_TZ() function. This ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
This is the same as the process ID shown as the Id value in the output from SHOW PROCESSLIST. This is because the number of rows actually matched by the corresponding WHERE clause, and the number of rows changed can differ. This returns the number ... MySQL supports the following static probes, organized into groups of ...
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/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 ...