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-online-ddl-limitations.html
When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online log. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
If you encounter this error, restore the previous innodb_data_file_path setting, and refer to the system tablespace resizing instructions. The system tablespace is the storage area for the change buffer. It may also contain table and index data if ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
If the server startup fails or the Component_status value is Disabled, check the server error log. If component_keyring_encrypted_file cannot find the configuration file, an error results, and the component cannot initialize. If an error occurs, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
If the server startup fails or the Component_status value is Disabled, check the server error log. If an error occurs, server startup fails and the administrator must correct any issues indicated by diagnostics in the server error log. The ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. As of MySQL 8.0.14, a derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%ldap%'; +----------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +----------------------------+---------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
If there is a difference between the tables, an error is returned and the statement fails. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: 'tbl_name.MRG' (errno: 2), it generally indicates that some of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. Normally, myisamchk or myisamchk --medium-check should be able to determine whether there are any errors in ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --wait, -w Command-Line Format --wait Type Boolean Default Value false Instead of terminating with an ... The options described in this section can be used for any type of table maintenance operation performed by ...