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/performance-schema-keyring-component-status-table.html
The keyring_component_status table (available as of MySQL 8.0.24) provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. As of MySQL 8.0.16, the keyring_keys table exposes metadata for keys in the keyring. Key metadata ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-tables.html
The following sections describe the Performance Schema tables associated with the MySQL keyring (see Section 8.4.4, “The MySQL Keyring”). They provide information about keyring operation: keyring_component_status: Information about the keyring ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. As of MySQL 8.0.22, RENAME USER fails with an error if any account to be renamed is named as the DEFINER attribute for any ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
SHOW REPLICA STATUS (or before MySQL 8.0.22, SHOW SLAVE STATUS) is useful for this. Then fix the problem and run START REPLICA (or before MySQL 8.0.22, START SLAVE). Beginning with MySQL 8.0.31, replication filter rules are applied first, prior to ... If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. Replication of invoked features such ...