PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/en/mysql-cluster-backup-configuration.html
In addition, CompressedBackup causes NDB to use compression when creating and writing to backup files. Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup.html
The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the ndb_mgm management client. To distinguish this type of backup from a backup made using mysqldump, we ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance ...