PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/mysql-server-side-help.html
mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. The proper operation of this command requires that the help ...
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/binary-installation.html
For other platform-specific binary package formats, see the other platform-specific sections in this manual. This section covers the installation of MySQL from a compressed tar file binary distribution on Unix/Linux platforms. Data directory ...
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/keyring-key-migration.html
In this case, it may be necessary to connect to the running server and enable keyring_operations manually using this statement: SET GLOBAL keyring_operations = ON; Online key migration provides for pausing keyring operations on a single running ...A ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/5.7/en/preface.html
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.7 and ...