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/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use the world database, which can be downloaded from https://dev.mysql.com/doc/index-other.html. The examples use this ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-instances.html
The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that MySQL Server is installed on each host (see Chapter 2, Installing ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
WHERE index_part1=1 OR index_part2=10 Sometimes MySQL does not use an index, even if one is available. LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
The USER_ATTRIBUTES table (available as of MySQL 8.0.21) provides information about user comments and user attributes. As of MySQL 8.0.22, USER_ATTRIBUTES contents are accessible as follows: All rows are accessible if: The current thread is a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
You can set this parameter in the MySQL configuration file (my.cnf or my.ini) or dynamically, using a SET statement. Depending on the combination of option values, MySQL uses a page size of 1KB, 2KB, 4KB, 8KB, or 16KB for the tablespace data file ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. LOCK TABLES sets table locks, but ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL layer. Figure 17.4 MySQL Server with Integrated memcached Server Features of the daemon_memcached ...