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/rewriter-query-rewrite-plugin-usage.html
If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> CALL query_rewrite.flush_rewrite_rules(); ERROR 1644 (45000): Loading of some rule(s) failed. When this occurs, the plugin writes an error message ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
Final instrument names correspond to server commands and SQL statements: Server commands correspond to the COM_xxx codes defined in the mysql_com.h header file and processed in sql/sql_parse.cc. Some final instrument names are specific to error ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
After this time, if the read operation is not successful, X Plugin closes the connection and returns a warning notice with the error code ER_IO_READ_ERROR to the client application. Important Because X Plugin is not a mandatory plugin, it does not ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/8.0/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...In other cases, when a collation description is generally correct but contains some unknown tags, the collation is initialized and is available for ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
IF NOT EXISTS has the same meaning for CREATE EVENT as for CREATE TABLE: If an event named event_name already exists in the same schema, no action is taken, and no error results. row *************************** Level: Note Code: 1588 Message: Event ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
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/converting-tables-to-innodb.html
Make sure that any error handlers in your application also ROLLBACK incomplete changes or COMMIT completed changes. Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
The strings you specify as input values are automatically encoded as numbers. The index value of the empty string error value is 0. If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. Duplicate values in the ...