https://dev.mysql.com/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/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/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/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/problems-with-null.html
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 often think that ...
https://dev.mysql.com/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/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 master to use binary log file position based replication, you must ensure that binary ...
https://dev.mysql.com/replication-options-gtids.html
gtid_executed_compression_period Property Value Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1000 Minimum Value ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/replication-options.html
Property Value Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value (>= 8.0.3) 1 Default Value (<= 8.0.2) 0 Minimum Value 0 Maximum Value 4294967295 This variable ...
https://dev.mysql.com/rewriter-query-rewrite-plugin-reference.html
rewriter_verbose Property Value 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 ...
