Mysql查看sql是否走事务 - 数据库编程

date_interval) FROM T_PLUGIN_CALENDAR 126002192Query SELECT COUNT(*) FROMT_PLUGIN_TODO 126002192Query SELECT COUNT(*) FROMT_PLUGIN_MEMO //sql太长忽略 126002192Query SELECT @@session.tx_isolation 126002192Query SET SESSION TRANSACTION ISOLATIONLEVEL REPEATABLE READ 126002192Query SET autocommit=0 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select pk from T_GANTT_CHARTwhere pk =47 for update 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query select *....sql 太长忽略 126002192Query update T_GANTT_OBJECT setcreated='2014-08-19 16:56:49', deleted=0, last_update='2014-08-23 14:20:42',duration=0, endDate='2014-08-13 00:00:00', oId=-1, orderValue=20, parentId=237,preId=-1, predecessorOffset=0, progress=100, refId=-1, relationType='start_start',startDate='2014-08-05 00:00:00', id=96, title='01_系统设计',type='activity', visible=1 where pk=238 126002192Query update T_GANTT_CHART setcreated='2014-08-19 16:56:49', deleted=0, last_update='2014-10-17 11:22:18',gantt_objects_as_xml=237, name='3D项目', owner_fk=8,read_access='ALL', settings_as_xml='3D项目',style_as_xml='', task_fk=94, write_access='ALL' where pk=47 126002192Query update T_GANTT_OBJECT setcreated='2014-08-19 17:57:01', deleted=0, last_update='2014-08-23 14:20:42',duration=0, endDate='2014-10-18 00:00:00', oId=3, orderValue=20, parentId=241,preId=219, predecessorOffset=0, progress=null, refId=2, relationType='start_start',startDate='2014-10-15 00:00:00', id=100, title='促销数据',type='activity', visible=1 where pk=243 126002192Query commit 126002192Query SET autocommit=1 126002192Query SET SESSION TRANSACTION ISOLATIONLEVEL READ COMMITTED

根据上面的日志明显可以断定了：

当设置SET autocommit=1 之后的sql都是没有走事务的，

当SET autocommit=0之后到commit之前的都是走了事务的。记要完毕。

分析完毕后别忘记把日志关闭，不然很影响性能的哦

root@localhost:(none)>set global general_log=off;

Query OK, 0 rows affected (0.00 sec)

root@localhost:(none)>show global variables like 'general_log%';

+------------------+---------------------------+

| Variable_name    | Value                     |

+------------------+---------------------------+

| general_log      | OFF                       |

| general_log_file |/data/mysql/log/mysql.log |

+------------------+---------------------------+

2 rows in set (0.00 sec)

root@localhost:(none)>

Mysql查看sql是否走事务(二)