https://dev.mysql.com/server-system-variables.html
avoid_temporal_upgrade Property Value 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 ... The ...
https://dev.mysql.com/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 24.4, “Using the Event ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/statement-caching.html
When the server uses a cached internal statement structure, it must take care that the structure does not go out of date. Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. If the set of ...
https://dev.mysql.com/upgrade-binary-package.html
It also brings the Performance Schema, INFORMATION_SCHEMA, and sys schema up to date for MySQL 8.0, and examines all user schemas for incompatibilities with the current version of MySQL. It also brings the Performance Schema, INFORMATION_SCHEMA, and ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/x-plugin-monitoring-status-variables.html
Mysqlx_ssl_server_not_after The last date for which the SSL certificate is valid. Mysqlx_ssl_server_not_before The first date for which the SSL certificate is valid. Mysqlx_aborted_clients The number of clients that were disconnected because of an ...
https://dev.mysql.com/added-deprecated-removed.html
binlog_row_value_options: Enables binary logging of partial JSON updates for row-based replication.. binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row.. This section lists ...
https://dev.mysql.com/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. ALTER USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, ... ALTER USER [IF ...
https://dev.mysql.com/audit-log-installation.html
To ensure that your tables are up to date for upgrades from earlier versions of MySQL 8.0, perform the MySQL upgrade procedure, making sure to use the option that forces an update (see Section 2.11, “Upgrading MySQL”). If you prefer to run the ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related components described in Section 6.4.5.1, “Audit Log ...
