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/tuning-trace-purging.html
This is done by setting the optimizer_trace_offset and optimizer_trace_limit system variables, like this: SET optimizer_trace_offset=offset, optimizer_trace_limit=limit; offset is a signed integer (default -1); limit is a positive integer (default ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/9.7/en/user-resources.html
The value for each per-hour limit should be an integer representing a count per hour. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. One means of restricting client use ...
https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
The value of N must be an integer in the range from 1 to 1024. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. A leading 0b is case-sensitive and cannot be written as 0B. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/9.7/en/change-replication-source-to.html
interval must be a nonnegative integer in the range from 0 to 231−1. ] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the source. It also updates the contents of ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-sets.html
NOTE 11: The Unicode scalar value of a character is its code point treated as an unsigned integer.” If the character set is ucs2, comparison is byte-by-byte, but ucs2 strings should not contain surrogates, anyway. This section describes the ...
https://dev.mysql.com/doc/refman/9.7/en/compressed-format.html
If values in an integer column have a small range, the column is stored using the smallest possible type. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-using-uri-or-key-value-pairs.html
connect-timeout: An integer value used to configure the number of seconds that clients, such as MySQL Shell, wait until they stop trying to connect to an unresponsive MySQL server. This section describes use of URI-like connection strings or ...
https://dev.mysql.com/doc/refman/9.7/en/connection-compression-control.html
Configuration parameters that enable specifying the zstd compression level take an integer value from 1 to 22, with larger values indicating increasing levels of compression. Connections to the server can use compression on the traffic between ...