Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
Standard Upgrade Procedure To upgrade a replication topology, follow the instructions in Chapter 3, Upgrading MySQL for each individual MySQL Server instance, using this overall procedure: Upgrade the replicas first. MySQL Server performs the entire ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. Additional Resources You may find the Stored Procedures User Forum of use when working with stored procedures and functions. For answers to some commonly asked ...A ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
For an example of a stored procedure with an Auto Parallel Load call that uses the silent output type, see Quickstart: Load Data Using Lakehouse Auto Parallel Load Examples. MySQL 9.0.0 adds support for Lakehouse Incremental Load with the ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with its status-flag being 0a the 2nd resultset: 01 00 00 06 01 17 00 00 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql>GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
How are triggers managed in MySQL? Triggers can be created using the CREATE TRIGGER statement, and dropped using DROP TRIGGER. See Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”, for more about ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
Alternatively, drop FULLTEXT indexes before the export operation and recreate the indexes after importing the table on the destination instance. Usage Notes With the exception of tables that contain instantly added or dropped columns, ALTER TABLE ... Attempting to import a table with columns that were added or dropped using ALGORITHM=INSTANT without using a .cfg file can result in undefined ... This section describes how to import tables using the ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. A session holding a WRITE lock can perform table-level operations such as DROP TABLE or TRUNCATE TABLE. For sessions holding a READ lock, DROP TABLE and ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
CREATE TABLE, ALTER TABLE, and DROP TABLE are valid operations on a log table. For ALTER TABLE and DROP TABLE, the log table cannot be in use and must be disabled, as described later. To disable logging so that you can alter (or drop) a log table, ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...