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/show-slave-hosts.html
Statement output includes this column only if the source server is started with the --show-slave-auth-info option. Statement output includes this column only if the source server is started with the --show-slave-auth-info option. A zero in this ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. Assume that where_condition involves columns only from t2 and not t1 so that the subquery is noncorrelated. The optimizer uses ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Table-condition generator: If the subquery is a join of several tables, the triggered condition is checked as soon as possible. In EXPLAIN output, the fallback shows up as Full scan on NULL key in the Extra column: mysql> EXPLAIN SELECT t1.col1, ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
The index may also be used even if the ORDER BY does not match the index exactly, as long as all unused portions of the index and all extra ORDER BY columns are constants in the WHERE clause. If the index does not contain all columns accessed by the ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Each statement summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has ... The ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The table has these columns: USER The user name part of an account. The field value is an integer that represents the UNIX timestamp value indicating the date and time when the audit event was generated. Unless those objects are installed, the ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If you have a problem with Connector/ODBC (MyODBC), please try to generate a trace file and send it with your report. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE, the destination table preserves generated column information from the original table. LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
When the date argument is a TIMESTAMP column, UNIX_TIMESTAMP() returns the internal timestamp value directly, with no implicit “string-to-Unix-timestamp” conversion. If you want to subtract UNIX_TIMESTAMP() columns, you might want to cast them ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with ...