Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. It is a good ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-formats.html
When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. Two of them, fixed and dynamic format, are chosen automatically depending on ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. This section discusses how to use myisamchk to check or repair MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-connection-strings.html
Write the connection string for each executable into a text file named Ndb.cfg and place this file in the executable's startup directory. With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
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 data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
In a Disk Data table, the first 256 bytes of a TEXT or BLOB column are stored in memory; only the remainder is stored on disk. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total; this includes JSON columns. Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database objects.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
In addition to the central configuration file, a cluster may also be controlled through a command-line interface available through the management client ndb_mgm. Commands for the event logs are given in Section 25.6.3, “Event Reports Generated in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-blobs.html
Parts of JSON values exceeding 4000 bytes in size are also stored in this table. For more information about how NDB Cluster stores columns of such types, see String Type Storage Requirements. The part and inline sizes of NDB blob columns can be set ...