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/host-cache.html
The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The cache contains information about errors that occur during the client connection process. Some errors are ...The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
If you specify --log-slave-updates or --slave-preserve-commit-order together with --skip-log-bin or --disable-log-bin, a warning or error message is issued. Setting this variable on the source to a value unrecognized by the replica causes the ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
check-table-functions: How to proceed when scanning data dictionary for functions used in table constraints and other expressions, and such a function causes an error. innodb_print_ddl_logs: Whether or not to print DDL logs to error log. Options ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If the problem occurs during compilation, include the exact error messages and also a few lines of context around the offending code in the file where the error occurs. If you get a parse error for an SQL statement, please check your syntax closely.
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. An error occurs if a key part definition contains ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value, such as '42S01' to specify “unknown table”: DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' BEGIN -- body of handler END; Do not use SQLSTATE values that begin with '00' because those indicate success rather than an error ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
For additional connection-related information, check the Connection_errors_xxx status variables and the host_cache table. All Com_stmt_xxx variables are increased even if a prepared statement argument is unknown or an error occurred during execution. Connection_errors_xxx These variables provide information about errors that occur during the client connection ...
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. Your first resource when troubleshooting server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
Instead, use ndb_perror to obtain error message information from NDB error codes. Beginning with this release, MySQL NDB Cluster is being developed in parallel with the standard MySQL 8.0 server under a new unified release model with the following ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
With neither of these modifications, REVOKE either succeeds for all named users and roles, or rolls back and has no effect if any error occurs; the statement is written to the binary log only if it succeeds for all named users and roles. Otherwise, ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...