PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/upgrade-binary-package.html
It also brings the Performance Schema, INFORMATION_SCHEMA, and sys databases up to date for MySQL 8.0, and examines all user databases for incompatibilities with the current version of MySQL. It also brings the Performance Schema, ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-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/doc/refman/8.0/en/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. Options and Variables ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. ALTER USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, ... ALTER USER [IF ...
https://dev.mysql.com/doc/refman/8.0/en/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 Chapter 3, Upgrading MySQL). If you prefer to run the update ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Example: mysql> SELECT audit_log_encryption_password_set(password); +---------------------------------------------+ | audit_log_encryption_password_set(password) | +---------------------------------------------+ | 1 | ...Unless those objects are ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
If that state is not sufficiently current, a full recovery can be followed by recovery of incremental backups made since the full backup, to bring the server to a more up-to-date state. This section describes the characteristics of different types ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
We try to keep the manual up to date by updating it frequently with solutions to newly found problems. Normally mysqld should never corrupt a table if nothing killed it in the middle of an update. Before posting a bug report about a problem, please ...