PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
The server requires that month and day values be valid, and not merely in the range 1 to 12 and 1 to 31, respectively. MySQL does not accept TIMESTAMP values that include a zero in the day or month column or values that are not a valid date. This ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
If both the default settings are used, the replica waits 60 seconds between reconnection attempts (MASTER_CONNECT_RETRY=60), and keeps attempting to reconnect at this rate for 60 days (MASTER_RETRY_COUNT=86400). If both the default settings are ...] ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
A value of N greater than zero means that the password must be changed every N days. The attribute value is a hash with failed_login_attempts and password_lock_time_days keys indicating the value of such options as have been specified for the ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
If both the default settings are used, the replica waits 60 seconds between reconnection attempts (SOURCE_CONNECT_RETRY=60), and keeps attempting to reconnect at this rate for 60 days (SOURCE_RETRY_COUNT=86400). If both the default settings are ...] ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
A recurrent event repeats its action at a regular interval, and the schedule for a recurring event can be assigned a specific start day and time, end day and time, both, or neither. MySQL Events are tasks that run according to a schedule. When you ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
Prior to MySQL 8.0.27, the default component timeout is 31536000 seconds, or 365 days. This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). As soon as you issue STOP GROUP_REPLICATION the member is set ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
The TIME is interpreted as elapsed time (not time of day) and added to the date. To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
(Perhaps batch jobs assigned to the group should run at lower priority during the day and at higher priority during the night.) The DBA can also adjust the set of CPUs available to the group. MySQL supports creation and management of resource ...