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/optimizer-hints.html
Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to change optimizer_switch before each one. For more information about these optimizations, see Section 8.2.2, ... One ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
Note There may be inconsistencies between queries shown in the INFORMATION_SCHEMA PROCESSLIST and INNODB_TRX tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables that contain ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
Assuming that there is an index on (key_part1, key_part2), the following queries may use the index to resolve the ORDER BY part. queries as if you also included ORDER BY col1, col2, ... Some types of queries are particularly suited to completely ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
} export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] SELECT is used to retrieve rows selected from one or more tables, and can ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH QUERY CACHE does not remove any queries from the cache, unlike FLUSH TABLES or RESET QUERY CACHE. | table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ... FOR EXPORT } table_synonym: { TABLE | TABLES } The FLUSH statement has ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. This condition does not apply if the WITHOUT VALIDATION ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
Queries with nested outer joins are executed in the same pipeline manner as queries with inner joins. Thus, the optimization of pushing conditions out of the inner nested loops cannot be applied directly to queries with outer joins. The following ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Even for queries that ...The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...