Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. If no computer or host name is provided, any host can use this SQL or API ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from https://dev.mysql.com/downloads/. If you build MySQL from source, you must invoke CMake with the ...
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/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
In a typical scenario where you could lower the option value, you might see a combination like this in the output from SHOW ENGINE INNODB STATUS: History list length low, below a few thousand. If you follow best practices for database design and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. The replication_applier_configuration table has ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions.html
Replication can be used in many different environments for a range of purposes. This section provides general notes and advice on using replication for specific solution types. For information on using replication in a backup environment, including ...