Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
(This happens because ALTER TABLE puts UNIQUE indexes before nonunique indexes to facilitate rapid detection of duplicate keys.) Consequently, queries on tables with such indexes may return unexpected results. The following are known problems with ...
https://dev.mysql.com/doc/refman/8.4/en/midpoint-insertion.html
By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a more sophisticated method called the midpoint insertion strategy. When using the midpoint insertion strategy, ...
https://dev.mysql.com/doc/refman/8.4/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ... The ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
Most of these issues can be overcome, but this also means that you are very unlikely to be able to switch an existing application datastore—that currently uses, for example, MyISAM or InnoDB—to use the NDB storage engine without allowing for the ... MySQL NDB Cluster uses the MySQL server with the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-installation.html
This section covers hardware and software requirements; networking issues; installation of NDB Cluster; basic configuration issues; starting, stopping, and restarting the cluster; loading of a sample database; and performing queries. This section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-management.html
Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB Cluster. This is covered in Section 25.4, “Configuration of NDB Cluster”, and Section 25.5, “NDB Cluster Programs”. The next few sections ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-counters.html
The counters table provides running totals of events such as reads and writes for specific kernel blocks and data nodes. Counts are kept from the most recent node start or restart; a node start or restart resets all counters on that node. The ...