Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. The following are known problems with MERGE ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
Due to differences between when the optimizer evaluates GROUP BY and HAVING, matching may succeed but GROUPING() evaluation does not produce the expected result. The function return value and type are the same as the return value and type of its ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If you use myisamchk to repair or optimize tables, you must always ensure that the mysqld server is not using the table (this also applies if external locking is disabled). This section describes how to check for and deal with data corruption in ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
You can do this by using OPTIMIZE TABLE on the tables in question. It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. The following options to mysqld can be used to change the behavior of MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers ...
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/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
Note The OPTIMIZE TABLE statement does not have any effect on Disk Data tables. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
You should be aware that the methods described previously in this section are not optimized for very large data sets or large transactions. It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB ...