PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-format.html
The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/9.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.27, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.13, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.40, ...
https://dev.mysql.com/doc/refman/9.7/en/with.html
This constraint rules out mutually-recursive CTEs, where cte1 references cte2 and cte2 references cte1. These constraints come from the SQL standard, other than the MySQL-specific exclusions mentioned previously. The optimizer cannot predict the ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
They are often used with a GROUP BY clause to group values into subsets. The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). For ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/9.7/en/alter-database.html
In ALTER DATABASE statements, the READ ONLY option interacts with other instances of itself and with other options as follows: An error occurs if multiple instances of READ ONLY conflict (for example, READ ONLY = 1 READ ONLY = 0). For a MERGE table ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/9.7/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/9.7/en/cache-index.html
After the indexes have been assigned, they can be preloaded into the cache if desired with LOAD INDEX INTO CACHE. For more information, see Section 15.7.8.5, “LOAD INDEX INTO CACHE Statement”. | tbl_name PARTITION (partition_list) } IN ...
https://dev.mysql.com/doc/refman/9.7/en/call.html
C programs can use the prepared-statement interface to execute CALL statements and access OUT and INOUT parameters. Languages that provide a MySQL interface can use prepared CALL statements to directly retrieve OUT and INOUT procedure parameters.