5 recommended articles about non-transaction tables

When looking at the max_binlog_stmt_cache_size parameter explanation, there is such a sentence. If nontransactional statements within a transaction require more than this many bytes of memory, the server generates an error. So, what are nontransactional statements? Look for the nontransactional keyword at http://dev.mysql.com/, and the first one that comes out is Rollback Failure for Nontransactional Tables. So what are Nontransactional Tables? Nontransactional Tables, non-transactional tables, tables that do not support transactions, that is, tables that use the MyISAM storage engine. Characteristics of non-transaction tables

1. MySQL transaction tables and non-transaction tables

##Introduction: When viewing the max_binlog_stmt_cache_size parameter explanation, there is such a sentence: If nontransactional statements within a transaction require more than this many bytes of memory, the server generates an error.

2. Mysql master desynchronization problem handling

##Introduction: Due to various reasons, Data inconsistencies often occur in the mysql master-slave architecture, which can be roughly summarized into the following categories: 1: writing data to the standby database 2: executing non-deterministic query 3: rolling back transactions that mix transaction tables and non-transaction tables 4

3.

Mysql non-transaction table rollback failure phenomenon

Introduction: When executing ROLLBACK (rollback), if the next The following message indicates that 1 or more tables used in the transaction do not support transactions: Warning: Some changes to non-transactional tables cannot be rolled back. These non-transactional tables are not affected by ROLLBACK statements. If you accidentally mixed transactional and non-transactional tables in a transaction, the most likely cause of this message is that you thought this

4.

Mysql master never Synchronization problem handling

Introduction: Due to various reasons, data inconsistency often occurs in the mysql master-slave architecture. The situations that arise can be roughly summarized into the following categories: 1: Writing data to the standby database 2: Executing non-deterministic query 3: Rolling back transactions that mix transaction tables and non-transaction tables 4: Binlog or relaylog data corruption Data out of sync brings to the application The harm is fatal. When the master-slave number appears

##5.

Easily solve the phenomenon of Mysql non-transaction table rollback failure_MySQL

Introduction: Easily solve the phenomenon of Mysql non-transaction table rollback failure

The above is the detailed content of 5 recommended articles about non-transaction tables. For more information, please follow other related articles on the PHP Chinese website!