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/derived-table-optimization.html
Consider the following query: SELECT * FROM t1 JOIN (SELECT DISTINCT f1 FROM t2) AS derived_t2 ON t1.f1=derived_t2.f1; The optimizer constructs an index over column f1 from derived_t2 if doing so would enable use of ref access for the lowest cost ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. The server generates a ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. $> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
--stop-never is commonly used with --raw to make a live binary log backup, but also can be used without --raw to maintain a continuous text display of log events as the server generates them. If this option is given twice (by passing in either "-vv" ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
(That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it evaluates to FALSE or UNKNOWN for any NULL-complemented row generated for the operation. Table expressions in the FROM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_stages_history_long table contains the N most recent stage events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_statements_history_long table contains the N most recent statement events that have ended globally, across ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_transactions_history_long table contains the N most recent transaction events that have ended globally, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-long-table.html
When the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. The events_waits_history_long table contains N the most recent wait events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, ...