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/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/sys-statement-performance-analyzer.html
Otherwise, it must be the name of an existing view that queries the Performance Schema events_statements_summary_by_digest table. Example To create a report with the queries in the 95th percentile since the last truncation of ... Creates a report of ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
Qcache_lowmem_prunes: Number of queries which were deleted from query cache due to lack of free memory in cache. Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to query_cache_type setting). Options and Variables ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE ...