Search Results
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. While held by one session, other sessions cannot obtain a lock of the same name.
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. MySQL distributions provide a locking interface that is accessible at two levels: ...
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() ...