Search Results
https://dev.mysql.com/doc/refman/9.7/en/dbug-package.html
The debug_options value is a sequence of colon-separated fields: field_1:field_2:...:field_N Each field within the value consists of a mandatory flag character, optionally preceded by a + or - character, and optionally followed by a comma-separated ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/9.7/en/ddl-rewriter-installation.html
To install the ddl_rewriter plugin, use the INSTALL PLUGIN statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.so'; To verify plugin installation, examine the Information Schema ...
https://dev.mysql.com/doc/refman/9.7/en/declare-cursor.html
For information available through SHOW statements, it is possible in many cases to obtain equivalent information by using a cursor with an INFORMATION_SCHEMA table. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor ...
https://dev.mysql.com/doc/refman/9.7/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/9.7/en/downgrading.html
Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A replication topology is downgraded by following the rolling downgrade scheme described at Section ...
https://dev.mysql.com/doc/refman/9.7/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.20, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/9.7/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must ...
https://dev.mysql.com/doc/refman/9.7/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all redo log files (#ib_redoN files). If you created any InnoDB tables, also ... 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/9.7/en/error-log-event-fields.html
Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A core field is set up automatically for error events. However, its ...
https://dev.mysql.com/doc/refman/9.7/en/error-message-elements.html
It is MySQL-specific and is not portable to other database systems. Error codes are stable across General Availability (GA) releases of a given MySQL series. This section discusses how error messages originate within MySQL and the elements they ...