Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
DROP SPATIAL REFERENCE SYSTEM: See Section 15.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
The table cannot even be opened, so you cannot drop an index for which the plugin is used. If you do not care about the table, DROP TABLE can be used even if any plugins associated with the table are missing. UNINSTALL PLUGIN plugin_name This ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
To correct this, use DROP FUNCTION to drop the loadable function, and then use CREATE FUNCTION to re-create the loadable function with a different nonconflicting name. A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes beforehand, then re-create them after the upgrade is complete. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-auto-reconnect.html
If the connection drops, it is possible that the session associated with the connection on the server side will still be running if the server has not yet detected that the client is no longer connected. The MySQL client library can perform an ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-setup.html
To compile and install a plugin library file, use the instructions in Section 4.4.3, “Compiling and Installing Plugin Libraries”. To make the library file available for use, install it in the plugin directory (the directory named by the ...