PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
For example: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEXES WHERE NAME='id_index' \G *************************** 1. row *************************** INDEX_ID: 91 NAME: id_index TABLE_ID: 68 TYPE: 0 N_FIELDS: 1 PAGE_NO: 4 SPACE: 57 ...If the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
This table provides applications a runtime source of MySQL keyword information. The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. Prior to MySQL 8.0.13, selecting from the KEYWORDS ...Reserved keywords may require special treatment in some contexts, such as special quoting when used as identifiers (see Section 11.3, “Keywords and Reserved ...
https://dev.mysql.com/doc/refman/8.0/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Beginning with MySQL 8.0.19, you can use a TABLE statement in place of SELECT, as shown here: INSERT INTO ta TABLE tb; TABLE ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL can use indexes and ranges to search for NULL with IS NULL. MySQL can also optimize the combination col_name = expr OR ...
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ...mysql> SELECT JSON_OBJECT('id', 87, 'name', 'carrot'); +-----------------------------------------+ | JSON_OBJECT('id', 87, 'name', 'carrot') | +-----------------------------------------+ | {"id": 87, "name": "carrot"} | +-----------------------------------------+ JSON_QUOTE(string) Quotes a string as a JSON value by wrapping it with double quote characters and escaping interior quote and other characters, then returning the result as a utf8mb4 ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Type String The destination keyring plugin for key migration. The option value ...
https://dev.mysql.com/doc/refman/8.0/en/lz4-decompress.html
The lz4_decompress utility decompresses mysqlpump output that was created using LZ4 compression. Note lz4_decompress is deprecated as of MySQL 8.0.34; expect it to be removed in a future version of MySQL. This is because the associated mysqlpump ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
See Section 27.2, “Using Stored Routines” and Adding Functions to MySQL for more information. (Although you must handle backups and storage issues yourself in this case.) If you need really high speed, look at the low-level MySQL interfaces. For ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...