Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production version. (This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data ...Then ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-component-information.html
The mysql.component system table contains information about currently loaded components and shows which components have been registered using INSTALL COMPONENT. For example: mysql> SELECT * FROM mysql.component; ...The component_urn is the URN used ...
https://dev.mysql.com/doc/refman/8.4/en/operator-precedence.html
Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 11.4, “User-Defined Variables”, explain how MySQL determines which interpretation of = should apply. For example: mysql> SELECT 1+2*3; -> 7 mysql> SELECT (1+2)*3; -> 9 .
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-group-allowlist-table.html
The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_group_allowlist system table that provides persistent storage of firewall data; see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-groups-table.html
The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_groups system table that provides persistent storage of firewall data; see MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-membership-table.html
The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. MySQL does not perform matching of Host column values in the mysql.user system table ...The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...