Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Execution of any statement requiring a write lock on either or both of the slave_master_info and slave_relay_log_info tables is disallowed while replication is ongoing (although statements that perform only reads are permitted at any time). You can ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full mode value, including NO_DIR_IN_CREATE, is passed to the receiving server. For this reason, replication of such a statement may not be safe when STATEMENT mode is in use.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
If a replication source server does not write a statement to its binary log, the statement is not replicated. If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. On the replica side, decisions about whether to execute or ignore statements received from the source are made according to the --replicate-* options that the replica was started ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
pattern The template that indicates the pattern for statements that the rule matches. pattern_database The database used to match unqualified table names in statements. Qualified table names in statements match qualified names in the pattern if ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. The following sections provide additional information about SQL syntax for statements related to these ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
Only statements that modify databases or tables count against the update limit. To establish resource limits for an account at account-creation time, use the CREATE USER statement. To modify limits for an existing account, use an ALTER USER ... One ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). In sandbox mode, no statements other than ALTER USER are permitted. When ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END statement. For an IDLE XA transaction, you can issue either an XA PREPARE statement or an XA COMMIT ... ONE PHASE statement: XA PREPARE ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-next-result.html
mysql_next_result() is used when you execute multiple statements specified as a single statement string, or when you use CALL statements to execute stored procedures, which can return multiple result sets. mysql_next_result() reads the next ... int ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-result-metadata.html
MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT *stmt) Description mysql_stmt_result_metadata() is used to obtain result set metadata for a prepared statement. Its use requires that the statement when executed by mysql_stmt_execute() does produce ...The result set metadata returned by mysql_stmt_result_metadata() is in the form of a pointer to a MYSQL_RES structure that can be used to process the meta information such as number of fields and individual field ...