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-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
SELECT INSERT statements with AUTO_INCREMENT UPDATE or DELETE statements with WHERE clauses that do not use keys or do not change most of the examined rows. For most users, the mixed replication format should provide the best combination of data ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
For information on key system variables, see Section 19.4.10.2, “Configuring Semisynchronous Replication”. Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
Some key system variables are: rpl_semi_sync_source_enabled or rpl_semi_sync_master_enabled Controls whether semisynchronous replication is enabled on the source server. When you install the source and replica plugins for semisynchronous ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
The innodb_flush_log_at_trx_commit=1 setting mentioned in the list below is a key setting for a replication setup that uses InnoDB with transactions. In order for replication to be resilient to unexpected halts of the server (sometimes described as ...
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
Note This statement is replaced in later versions of MySQL by RESET BINARY LOGS AND GTIDS, and should be considered deprecated. See RESET BINARY LOGS AND GTIDS Statement, in the MySQL 8.4 Manual, for more information. RESET MASTER [TO ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
Prior to MySQL 8.0.32, this statement did not work with variables whose name contained a dot character (.), such as MyISAM multiple key cache variables and variables registered by components. RESET PERSIST [[IF EXISTS] system_var_name] RESET ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
The information returned in a MySQL error is not gratuitous because that information is key in debugging MySQL using applications. Client applications that access MySQL should use the following guidelines to avoid interpreting external data ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 8. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/8.0/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] SHOW STATUS provides server status information (see Section 7.1.10, “Server Status Variables”). Status variable information is also available from these sources: Performance Schema ...