PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 COMMIT -- (implicit; DDL forces commit) 6. COMMIT; -- Transaction 2 COMMIT From the perspective of the server, Transaction 1 ends when table t2 is created. Within the event hierarchy, wait ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
If an instrument is used to create multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value and is summarized separately in this table. An instrument might be used to create multiple instances of the instrumented object. For ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
The scope of a prepared statement is the session within which it is created, which as several implications: A prepared statement created in one session is not available to other sessions. A prepared statement created within a stored program ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. An implication of the ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. For example, if t1 is an InnoDB table, use this statement: ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
If you use LOAD DATA with binlog_format=STATEMENT, each replica on which the changes are to be applied creates a temporary file containing the data. This temporary file is not encrypted, even if binary log encryption is active on the source, If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
For a channel on a Group Replication group member, do not specify the Group Replication group name as the UUID for creating the GTIDs. The exception to this is any downstream replicas of the replica where you enabled ... From MySQL 8.0.23, you can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. If the sources in the multi-source replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...