PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. | 1.5219271183014 | | 6 | When configured properly, MySQL ... The MySQL FULLTEXT ... By ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
By default, MySQL (8.0.18 and later) employs hash joins whenever possible. Note MySQL 8.0.18 supported setting a hash_join flag in optimizer_switch, as well as the optimizer hints HASH_JOIN and NO_HASH_JOIN. In MySQL 8.0.19 and later, none of these ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. There are several distinctions between the way user names and passwords are used by MySQL and your operating system: User names, as used by MySQL for authentication purposes, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB assigns new values for the AUTO_INCREMENT column one at a time as each row is processed. As of MySQL 8.0, interleaved lock mode (innodb_autoinc_lock_mode=2) is the default setting. Prior to MySQL 8.0, consecutive lock mode is the default ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM ... The MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. To ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. As discussed elsewhere in this Manual ...The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...The MeCab full-text parser plugin is supported for use with InnoDB and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
mysql> SET @ls = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))); +----------------------------------------------+ | ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) | ...You can extract particular points of a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. This pertains to migration strategy because the way in which the source and destination keystores are managed ...A ...