PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
This technique is especially important for large tables and tables used in joins. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Instead, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end applications pushing the limits of performance. In MySQL 5.7, InnoDB is the default ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-windows-quick.html
Important The Community version of MySQL Shell requires the Visual C++ Redistributable for Visual Studio 2013 (available at the Microsoft Download Center) to work; make sure that is installed on your Windows system before installing MySQL Shell.
https://dev.mysql.com/doc/refman/5.7/en/introduction.html
Important To report problems or bugs, please use the instructions at Section 1.5, “How to Report Bugs or Problems”. The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server.
https://dev.mysql.com/doc/refman/5.7/en/json.html
It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. The JSON data type provides these advantages over storing JSON-format strings in a string ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
Important For an online migration operation, the migration server takes care of enabling and disabling keyring_operations on the running server. A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
Keyring service consumers require that a keyring plugin be installed. This section describes how to install the keyring plugin of your choosing. Also, for general information about installing plugins, see Section 5.5.1, “Installing and ...
https://dev.mysql.com/doc/refman/5.7/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. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
If it is important to ensure the same row order with and without LIMIT, include additional columns in the ORDER BY clause to make the order deterministic. If you need only a specified number of rows from a result set, use a LIMIT clause in the ...