Search Results
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
EVENT_BODY The language used for the statements in the event's DO clause. EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EXECUTE_AT For a one-time event, this is ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A lock wait ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
By comparing the values before and after statements operating on NDB tables, you can observe the corresponding actions taken on the API level, and thus the cost of performing the statement. You can see how various NDB API counters are incremented by ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
On the source, perform this INSERT statement: INSERT INTO mysql.ndb_replication VALUES ('test', 't1', 0, NULL, 'NDB$MAX(mycol)'); Note If the ndb_replication table does not already exist, you must create it. The table creation statement shown here ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
By default, mysqldump writes information as SQL statements to the standard output. With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. In this case, mysqldump writes a ... This section describes how to use mysqldump to create SQL-format dump ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current events_waits_history events_waits_history_long events_stages_current events_stages_history ... The consumer ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-limit.html
Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
The syntax to create channel specific replication filters extends the existing SQL statements and command options. The CHANGE REPLICATION FILTER statement supports the FOR CHANNEL clause to configure channel specific filters online. Changing Channel ... This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication ...