Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new instance: Create a new data directory. Warning Normally, you should never have two servers that update data in ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
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-config-starting.html
Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's data. For these reasons, it is not possible to offer a single configuration ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
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/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...