PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Reads from such tables are relatively unaffected; pending INSERT and UPDATE operations are performed as soon as the partitioning operation has completed. This section discusses current restrictions and limitations on MySQL partitioning support. The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
The following sections describe these capabilities, except password strength assessment, which is implemented using the validate_password component and is described in Section 8.4.3, “The Password Validation Component”. If you upgrade MySQL from ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. The PURGE BINARY LOGS statement deletes all the binary log files ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 a.m. To recover, first we restore the last full backup we have (the one from Sunday 1 p.m.). The full backup file is just a set of SQL statements, so restoring it is very ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
An unexpected exit of the source server and failover to the replica is lossless because the replica is up to date. An unexpected exit of the source server and failover to the replica is lossless because the replica is up to date. This section ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For example, Com_delete and Com_update count DELETE and UPDATE statements, respectively. Com_delete_multi and Com_update_multi are similar but apply to DELETE and UPDATE statements that use multiple-table syntax. This context value may differ from ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
avoid_temporal_upgrade Command-Line Format --avoid-temporal-upgrade[={OFF|ON}] Deprecated Yes System Variable avoid_temporal_upgrade Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF This variable controls whether ALTER ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This is displayed as a DATETIME value, and ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...