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/innodb-memcached-security.html
This section explains how to enable SASL with the daemon_memcached plugin. 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.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.html
The combination of memcached simplicity and InnoDB reliability and consistency provides users with the best of both worlds, as explained in Section 17.20.1, “Benefits of the InnoDB memcached Plugin”. Important The InnoDB memcached plugin was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Section 17.8.1, “InnoDB Startup Configuration” explains how to use these options. InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
Consider modifying the setting when encountering the following issues: Statistics are not accurate enough and the optimizer chooses suboptimal plans, as shown in EXPLAIN output. The persistent optimizer statistics feature improves plan stability by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
The lock modes reported in this section are explained in Section 17.7.1, “InnoDB Locking”. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output ...
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. This optimization does not occur in cases when the column ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The next few paragraphs explain how each of these two functions handles the merging of different combinations of JSON documents (that is, of objects and arrays). The JSON data type provides these advantages over storing JSON-format strings in a ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-docker.html
This section explains how to deploy MySQL Server using Docker containers. While the docker client is used in the following instructions for demonstration purposes, in general, the MySQL container images provided by Oracle work with any container ...