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-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). Parameters in_timeout INT: How many seconds to wait to obtain ...This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-statement-digest.html
in_interval DECIMAL(2,2): The analysis interval in seconds (which can be fractional) at which to try to take snapshots. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the ...
https://dev.mysql.com/doc/refman/9.7/en/system-schema.html
Time Zone System Tables These system tables contain time zone information: time_zone: Time zone IDs and whether they use leap seconds. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that ...
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
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/9.7/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/9.7/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,” ...