search

Home >Database >Mysql Tutorial >mysql binlog里为啥会有rollback？

mysql binlog里为啥会有rollback？

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-06 09:33:321559browse

mysql

摘自master服务器的binlog信息：

#160310 10:49:31 server id 136 end_log_pos 1620489 CRC32 0x649900b9 Query thread_id=1575568 exec_time=0 error_code=0
SET TIMESTAMP=1457578171/*!*/;
SET @@session.sql_mode=1075838976/*!*/;
ROLLBACK
/*!*/;

at 1620489

为什么会出现rollback？
如果一个事务回滚的话，那么涉及该事务的所有语句应该都不会出现在binlog中才对啊。 求解！(复制模式为statement-based)

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-下面两个查询语句有什么区别Next article：mysql数据库建立触发器，做历史记录查询

Related articles

See more