PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. Note REPLACE makes sense only if a table has a ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM and MEMORY tables. This is also done for any NOT NULL expression when used with only one table. For each table in a join, a simpler WHERE is ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which can select from one or many tables. The target table of the INSERT statement may appear in the FROM clause of the SELECT part of the query. However, ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
For the reasons for this, see Section 13.2.5.3, “INSERT DELAYED Statement”, Inserting into a table requires the INSERT privilege for the table. When inserting into a partitioned table, you can control which partitions and subpartitions accept ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the MD5 hash value computed from the original normalized statement. Statement Digests in the Performance Schema In the Performance Schema, ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. Plugins ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed table. With binary logging enabled (as required for the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
As noted in Section 16.4.1.29, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based format. When using mixed format logging, “safe” statements involving temporary tables are logged using ... MySQL uses ...