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-locks-set.html
If a duplicate-key error occurs, a shared lock on the duplicate index record is set. The operations by sessions 2 and 3 both result in a duplicate-key error and they both request a shared lock for the row. The operations by sessions 2 and 3 both ...
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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxNoOfSavedMessages: Maximum number of error messages to write in error log and maximum number of trace files to retain. MaxStartFailRetries: Maximum retries when data node fails on startup, requires StopOnError = 0. RestartOnErrorInsert: Control ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...