Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. A successful migration operation has this result: The destination keystore contains the keys it had prior to the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared memory. For TCP/IP connections, you may ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tde.html
The following sections provide information about NDB data node file system encryption. Start the management server with either --initial or --reload to cause it to read the updated configuration file. Perform a rolling initial start (or restart) of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-upgrade-downgrade.html
Versions Supported for Upgrade to NDB 8.4 Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster releases with regard to performing ...