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/replication-rules-table-options.html
One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
stage/innodb/alter table (end): Includes any remaining work that appeared after the flush phase, such as reapplying DML that was executed on the table while ALTER TABLE was running. You can monitor ALTER TABLE progress for InnoDB tables using ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as applicable. Note 4294967039 often appears as a maximum value in these tables. Each of the node parameter tables lists the ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
Rules that specify differences at secondary or higher sort levels are recognized (and thus can be included in collation definitions) but are treated as equality at the primary level. Either of the following rules resets subsequent shift rules to be ...This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Configuration Options ps_thread_trx_info() operation ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
The optimizer choices are limited because only such plans enable outer joins to be executed using the nested-loop algorithm. This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
For example, the first of the following lines is legal at program invocation time, but the second is not: $> mysql --max_allowed_packet=16M $> mysql --max_allowed_packet=16*1024*1024 Conversely, the second of the following lines is legal at runtime, ... Many MySQL programs have internal variables that can be set at runtime using the SET ...See Section ...