Search Results
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/8.4/en/myisamlog.html
To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-concepts.html
In the listing just shown, backup_id stands for the backup identifier and node_id is the unique identifier for the node creating the file. A backup is a snapshot of the database at a given time. The data actually stored in the database tables at ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-configuration.html
In addition, CompressedBackup causes NDB to use compression when creating and writing to backup files. You can enforce encryption of backup files by setting RequireEncryptedBackup to 1; this prevents the creation of backups without specifying ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-parallel-data-nodes.html
To force creation of a single-threaded backup, set EnableMultithreadedBackup = 0 for all data nodes (you can do this by setting the parameter in the [ndbd default] section of the config.ini global configuration file). It is possible to take a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux.html
Regardless of the method used, it is still necessary following installation of the NDB Cluster binaries to create configuration files for all cluster nodes, before you can start the cluster. This section covers installation methods for NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
Important An NDB Cluster management node caches the configuration data that it reads from config.ini; once it has created a configuration cache, it ignores the config.ini file on subsequent starts unless forced to do otherwise. Once the NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...