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/replication-gtids-concepts.html
In releases before MySQL 8.0.17 when binary logging is enabled, compression is triggered by the fact of the binary log being rotated at startup. In releases from MySQL 8.0.20, compression is triggered by the thread launch. A global transaction ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, cloning or copying of the data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
Reconnection attempts are triggered when the replica reaches its connection timeout (specified by the replica_net_timeout or slave_net_timeout system variable) without receiving data or a heartbeat signal from the source. The replication filter ...
https://dev.mysql.com/doc/refman/8.0/en/savepoint.html
A new savepoint level is created when a stored function is invoked or a trigger is activated. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored. SAVEPOINT identifier ...
https://dev.mysql.com/doc/refman/8.0/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
Thus, it does not cause ON DELETE triggers to fire, it cannot be performed for InnoDB tables with parent-child foreign key relationships, and it cannot be rolled back like a DML operation. Logically, TRUNCATE TABLE is similar to a DELETE statement ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
(It is possible to implement other semantics using triggers.) MySQL requires that the referenced columns be indexed for performance reasons. For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ALTER statements for stored programs, triggers, views, and loadable functions. An atomic DDL statement combines the data dictionary updates, storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically ...