Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard MySQL. Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-multiple-nodes.html
Stored procedures, stored functions, triggers, and scheduled events are all supported by tables using the NDB storage engine, but these do not propagate automatically between MySQL Servers acting as Cluster SQL nodes, and must be re-created ...The ...