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/group-replication-failure-detection.html
A member that is isolated from the rest of the group suspects that all the others have failed. If a member is actually isolated from the rest of the group, it might attempt to propagate its view, but that will have no consequences as it cannot ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
“Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
(This is also true for the MySQL upgrade procedure if it determines that table checking is needed because it processes tables the same way.) mysqlcheck must be used when the mysqld server is running, which means that you do not have to stop the ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
Because CAP_SYS_ADMIN must be enabled explicitly by the system administrator, MySQL binaries by default do not have network namespace support enabled. On the server side, the bind_address, admin_address, and mysqlx_bind_address system variables have ... A network namespace is a logical copy of the network stack from the host ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
Digesting occurs in the parser regardless of whether the Performance Schema is available, so that other features such as MySQL Enterprise Firewall and query rewrite plugins have access to statement digests. Other similar statements that have ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
If you have enabled GTID assignment on a replication channel using the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS option of the CHANGE REPLICATION SOURCE TO or CHANGE MASTER TO statement, see Section 19.1.7.3.2, “Skipping Transactions Without GTIDs”. This method of skipping transactions is not suitable when you have enabled GTID assignment on a replication channel using the ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS option of the CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication configuration. In some specific situations, as listed in the description for replica_preserve_commit_order and ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
To check a table, you must have some privilege for it. With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. CHANGED ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. An NDB tablespace supports multiple data files which can have any legal file names; more data files can be added ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. It is possible to define multiple triggers for a given table that have the same trigger event and action time. For example, you can have ... CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } other_trigger_name This statement creates a new ...