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/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. In this case, InnoDB uses next-key locks for searches and index scans, which prevents phantom rows ...
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/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/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/option-files.html
For example, to include the /home/mydir/myopt.cnf file, use the following directive: !include /home/mydir/myopt.cnf To search the /home/mydir directory and read option files found there, use this directive: !includedir /home/mydir MySQL makes no ...
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/mysql-cluster-start-phases.html
This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. This occurs either when the cluster started for the very first time, or when all data nodes are restarted using the --initial option. This ...