Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster Replication”). To provide replication backup capability, you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 25.7.2, “General ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
Communications between NDB cluster nodes are normally handled using TCP/IP. The shared memory (SHM) transporter is distinguished by the fact that signals are transmitted by writing in memory rather than on a socket. The shared-memory transporter ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tcp-definition.html
TCP/IP is the default transport mechanism for all connections between nodes in an NDB Cluster. Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe executable. Note MySQL Configurator CLI functionality was added in MySQL Configurator 9.2.0. Executing MySQL Configurator requires a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation process. Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as my.ini.
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. This updates a value for each index part that indicates ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...