Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/replication-asynchronous-connection-failover.html
The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share data. If the new servers are provisioned using MySQL’s clone functionality, this all happens ...
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
If the destination table exists and IF NOT EXISTS is given, MySQL 8.4 ignores the statement completely; nothing is inserted or logged. SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit Commit”). If the ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
Source lists are stored in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables, and can be viewed in the Performance Schema replication_asynchronous_connection_failover table.