Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
The TIMED column for the error row in the setup_instruments table is inapplicable because timing information is not collected. These include row-level accesses to persistent base tables or temporary tables. Thus, events_waits_current for a table I/O ... An instrument name consists of a sequence of elements separated by '/' ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G *************************** 1. row *************************** ID: 5 USER: event_scheduler HOST: localhost DB: NULL COMMAND: Daemon ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. Replication filter rules are applied first, prior to making any privilege or ... If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
When binlog_format=MIXED is set, the statement is logged in row-based format. This temporary file is not encrypted, even if binary log encryption is active on the source, If encryption is required, use row-based or mixed binary logging format ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
With row-based replication, triggers executed on the source do not execute on the replica. Instead, the row changes on the source resulting from trigger execution are replicated and applied on the replica. If under row-based replication the replica ... With statement-based replication, triggers executed on the source also execute on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
If the statement has been logged using the row format, the database where data is to be changed is the database that is checked. Note Only DML statements can be logged using the row format. When using row-based logging with the same option, the ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Initially, the RESOURCE_GROUPS table has these rows describing the default groups: mysql> SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS\G *************************** 1. row *************************** RESOURCE_GROUP_NAME: USR_default ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache. This section describes the conditions that are favorable for SSL session reuse, the server variables used for managing and ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
Modifications that the current transaction made to rows after the savepoint was set are undone in the rollback, but InnoDB does not release the row locks that were stored in memory after the savepoint. (For a new inserted row, the lock information ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...