PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/9.7/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...
https://dev.mysql.com/doc/refman/9.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...
https://dev.mysql.com/doc/refman/9.7/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...
https://dev.mysql.com/doc/refman/9.7/en/xa-restrictions.html
XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as ...
https://dev.mysql.com/doc/refman/9.7/en/xa.html
Support for XA transactions is available for the InnoDB storage engine. The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA Specification. This document is published by The Open Group and ...