PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
Timeout values are nonnegative integers representing the time in seconds to wait to acquire locks before timing out with an error. The second SELECT fails because, although tok1 is present in the server token list, it has a different value than ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html
Examples of valid expr PRECEDING and expr FOLLOWING indicators: 10 PRECEDING INTERVAL 5 DAY PRECEDING 5 FOLLOWING INTERVAL '2:30' MINUTE_SECOND FOLLOWING expr FOLLOWING: For ROWS, the bound is expr rows after the current row. The definition of a ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
The second OVER clause partitions rows by country, producing a sum per partition (per country). In the second case, window_name is the name for a window specification defined by a WINDOW clause elsewhere in the query. However, whereas an aggregate ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
When XA COMMIT or XA ROLLBACK is issued, a second part of the transaction containing only the XA COMMIT or XA ROLLBACK statement is written using a second GTID. XA transaction support is limited to the InnoDB storage engine. For “external XA,” ...
https://dev.mysql.com/doc/refman/8.0/en/xa.html
The branches indicate whether they are able to do this, and these results are used for the second phase. In the second phase, the TM tells the RMs whether to commit or roll back. Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is not present, InnoDB processes SELECT COUNT(*) ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
The second statement updates the histograms for c1 and c3, leaving the c2 histogram unaffected. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] ...