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/server-system-variables.html
The MySQL optimizer assumes that no more than this number of key seeks are required when searching for matching rows in a table by scanning an index, regardless of the actual cardinality of the index (see Section 15.7.7.22, “SHOW INDEX ...This ...
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.44. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 8.0 and ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Slave_rows_last_search_algorithm_used: Search algorithm most recently used by this ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is utf8mb4_0900_ai_ci, whereas lookups are case-sensitive if the collation is utf8mb4_0900_as_cs or ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
Prior to MySQL 8.0.17, the result returned by this function used the UTF-16 character set; in MySQL 8.0.17 and later, the character set and collation of the expression searched for matches is used. Prior to MySQL 8.0.17, the result returned by this ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
Because the contents of INNODB_FT_BEING_DELETED typically have a short lifetime, this table has limited utility for monitoring or debugging. For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 14.9.6, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
In this case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table. Because the InnoDB memcached plugin is tightly integrated with a single memcached daemon, and the in-memory caching mechanism is handled by MySQL ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. You can also use http://www.mysql.com/search/ to ...We try to keep the manual up to date by updating it frequently with solutions to newly found ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
On Unix, perform rotation manually like this: From the command line, rename the current log files: mv audit.log.2 audit.log.3 mv audit.log.1 audit.log.2 mv audit.log audit.log.1 This strategy overwrites the current audit.log.3 contents, placing a ...