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/information-schema-plugins-table.html
PLUGIN_TYPE The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION. For plugins installed with INSTALL PLUGIN, the PLUGIN_NAME and PLUGIN_LIBRARY values are also registered in the mysql.plugin table. For information about ...The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-status-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. Note Information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. For an explanation of the inner workings of the InnoDB buffer pool, an overview of its LRU replacement algorithm, and general configuration information, ...Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 14.9, “InnoDB Table and Page Compression”. For example, if you archive the output of ...These ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. For example, if every 60 minutes you archived the output of INNODB_CMPMEM_RESET, it would show the hourly statistics.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. For example, you might insert duplicate values into a column while a unique index is being ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
Server Error Message Reference provides troubleshooting information for some of the common InnoDB-specific errors that you may encounter. For information about these sorts of problems and errors, see Section 14.22.3, “Troubleshooting InnoDB Data ... The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 5.4.2, “The Error ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The DELAYED keyword is scheduled for removal in a future release. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and ...
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/keyring-key-types.html
The permitted key lengths are subject to multiple factors: General keyring loadable-function interface limits (for keys managed using one of the keyring functions described in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”), ... MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is ...