PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
An authentication plugin can report different error codes to indicate the root cause of a failure. While HOST_VALIDATED is NO, DNS resolution is attempted for each connection attempt, until it eventually completes with either a valid result or a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html
| +----------------------------------+----------------------------------+ From MyQL 8.0.31, you can also monitor an online buffer pool resizing operation using the Innodb_buffer_pool_resize_status_code and Innodb_buffer_pool_resize_status_progress ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. If you get a lot of these errors, without mysqld having died unexpectedly just before, then ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ...This ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
In each case, this relationship applies: {cl.CountryCode} -> {co.Code} cl.CountryCode is itself functionally dependent on {cl.CountryCode, cl.Language} which is a primary key. If in the join result co.Code is NULL-complemented, co.Name is as well.
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.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. If --add-drop-database is used with --all-databases or with --databases where the list of schemas to ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. In particular, any MAX value in ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, RESIGNAL is illegal and a RESIGNAL when handler not active error occurs. For example, the condition_value can be an SQLSTATE value, and the value can ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | +--------------------------------+------------------------------+ | XXX-XXX-XXX | XXXXXXXXX | +--------------------------------+------------------------------+ mysql> SELECT mask_canada_sin('909'); ERROR 1123 (HY000): Can't initialize function 'mask_canada_sin'; Argument 0 is too ...