mysql transaction log

This articleArticleThis is the second article in the series, in case you have not read the first article. The address of the previous article is as follows: Transaction logs in SQL Server (I)-physical and logical architecture of transaction logs Introduction Each SQL Server database records the corresponding logs to the log files according to the order of t

Detailed description of InnoDB Transaction log (redo log and undo log) To avoid performance problems caused by I/O bottlenecks during data writing to the maximum extent, MySQL adopts a cache mechanism: When the query modifies the data in the database, innoDB first reads the

transactions in T-sql:1 starting transaction: BEGIN TRANSACTION2 COMMIT TRANSACTION: COMMIT Transaction3 Rolling back transactions: ROLLBACK TRANSACTIONTransaction classification:1 Explicit transactions: explicitly specify the beginning of a transaction with BEGIN transaction.2 Implicit

Tags: style blog http ar color OS using SP filesIntroductionThe transaction log in SQL Server is undoubtedly one of the most important parts of SQL Server. Because SQL Server uses transaction logs to ensure persistence (durability) and transaction rollback (Rollback). This also partially ensures the acid properties of

The possible causes are: statistics, the sort of such operations too much, too often. Solution: or to optimize the statement. In the tempdb library properties, in [Enterprise Manager], in the [file properties] of [transaction log], take a bite in front of [File Auto growth], and see if you have enough disk space on your log file. If it's not enough, save it for a

changes made to the data must be recorded in the permanent storage, which is usually stored in the physical database. After the software and hardware crash, the InnoDB data table driver uses the log file to reconstruct and modify the data table. Reliability and high speed cannot both be achieved. The innodb_flush_log_at_trx_commit option determines when to save the transaction to the

permanent storage, which is usually stored in the physical database. After the software and hardware crash, the InnoDB data table driver uses the log file to reconstruct and modify the data table. Reliability and high speed cannot both be achieved. The innodb_flush_log_at_trx_commit option determines when to save the transaction to the log. Note: The storage eng

Tags: style blog http ar color OS using SP forThis article is a series of articles in the fourth and the last, this article requires the first three articles of knowledge as the basis, the first three articles address as follows:On transaction log in SQL Server (i)----the physical and logical architecture of transaction logsTalking about

The problem of repeated data insertions before the line, by troubleshooting the problem and the default isolation level of MySQL-repeatable read (can be reread) , repeatable read ensures that multiple instances of the same transaction will see the same data row when concurrently reading the data. Now through the experiment, the problem is analyzed.1. Turn on transaction