Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
To configure a new 8.4.6 server to have different operating parameters, use a CMake command something like this: $> cmake . Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If you can be certain that no one can access the tables using mysqld while you run myisamchk, you only have to execute mysqladmin flush-tables before you start checking the tables. Normally the use of two --quick options is useful only if you have ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-check-options.html
--check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since the last check. If you are using --extend-check and have plenty of memory, setting the key_buffer_size variable to a large value helps the ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-memory.html
For example, if you have more than 512MB RAM available, you could use options such as these (in addition to any other options you might specify): myisamchk --myisam_sort_buffer_size=256M \ --key_buffer_size=512M \ --read_buffer_size=64M \ ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
(In the unlikely case that --recover fails, the data file remains intact.) If you have lots of memory, you should increase the value of myisam_sort_buffer_size. If you have lots of memory, you should increase the value of key_buffer_size.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
(NDB 8.4.0) In an NDB Cluster with many unstarted data nodes, the value of this parameter can be raised to circumvent connection attempts to data nodes which have not yet begun to function in the cluster, as well as moderate high traffic to ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
One fragment replica is sufficient for data storage, but provides no redundancy; therefore, it is recommended to have two (or more) fragment replicas to provide redundancy, and thus high availability. NDBCLUSTER (also known as NDB) is an in-memory ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
To support NDB Cluster, you should update my.cnf as shown in the following example. You may also specify these parameters on the command line when invoking the executables. Note The options shown here should not be confused with those that are used ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
For example, you cannot have a tablespace and a log file group both named dd1. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section ...