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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-security.html
Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive data. Because memcached does not use an authentication mechanism by default, and the ...Do not allow memcached access to these servers from the Internet; only allow access from within a firewalled intranet, ideally from a subnet whose membership you can ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ...[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/installation-layouts.html
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows” Section 2.8.3, “MySQL Layout for Source Installation” Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package” Table 2.12, “MySQL Installation Layout ... The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. Using the SET_VAR optimizer hint to update the value of optimizer_switch temporarily, you can enable invisible indexes for the duration of a single query only, ...The feature applies to indexes other than primary keys (either explicit or ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-key-types.html
MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is installed. The permitted key lengths are subject to multiple factors: General keyring loadable-function ...