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/partitioning-pruning.html
When a table is partitioned by HASH or [LINEAR] KEY, pruning can be used only on integer columns. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there ...
https://dev.mysql.com/doc/refman/9.7/en/password-management.html
If the value of default_password_lifetime is a positive integer N, it indicates the permitted password lifetime, such that passwords must be changed every N days. MySQL supports these password-management capabilities: Password expiration, to ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-timing.html
Therefore, the time unit is an integer multiple of the highest possible TIMER_FREQUENCY value, using a multiplier large enough to ensure that there is no major precision loss. Events are collected by means of instrumentation added to the server ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...
https://dev.mysql.com/doc/refman/9.7/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-concepts.html
For example, the twenty-third transaction to be committed originally on the server with the UUID 3E11FA47-71CA-11E1-9E33-C80AA9429562 has this GTID: 3E11FA47-71CA-11E1-9E33-C80AA9429562:23 The upper limit for sequence numbers for GTIDs on a server ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-masterbaseconfig.html
This server ID is used to identify individual servers within the replication topology, and must be a positive integer between 1 and (232)−1. To configure a source to use binary log file position based replication, you must ensure that binary ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. The following sections contain ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-reference.html
rewriter_verbose System Variable rewriter_verbose Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer For internal use. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates ...