Search Results
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/lock-instance-for-backup.html
REPAIR TABLE TRUNCATE TABLE, OPTIMIZE TABLE, and account management statements are blocked. LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...