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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-docker.html
You need to have Docker installed on your system before you can use a MySQL Server Docker image. The instructions for using the MySQL Docker container are divided into two sections. The Docker deployment framework supports easy installation and ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs to contain the following information: The pet name ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-formats.html
Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are using. The third, compressed format, can be created only with the myisampack utility (see Section 4.6.5, “myisampack — Generate Compressed, ...