Re: Acquire queries executed in each transaction only from MySQL
Posted by:
知亮 大塚
Date: June 27, 2018 08:31PM
general_log can't distinguish each transaction.
For example, I execute 2 (T1, T2) transaction in parallel.
2018-06-28T11:15:50.211421+09:00 7 Query begin
2018-06-28T11:15:58.651335+09:00 7 Query select * from t1
2018-06-28T11:16:42.730192+09:00 7 Query insert into t1 (col1, col2) values (2,3)
2018-06-28T11:16:49.219737+09:00 6 Query begin
2018-06-28T11:16:58.259100+09:00 7 Query select * from t1
2018-06-28T11:17:26.683469+09:00 6 Query insert into t1 (col1, col2) values (3,4)
2018-06-28T11:17:41.795235+09:00 7 Query commit
2018-06-28T11:17:44.412252+09:00 6 Query commit
This is the output of general_log, and I can't find out which queries are T1 or T2.
For the same reason, slow_query_log(long_query_time=0) doesn't work.
Subject
Views
Written By
Posted
773
June 27, 2018 10:57AM
502
June 27, 2018 11:02AM
628
June 27, 2018 02:23PM
Re: Acquire queries executed in each transaction only from MySQL
551
June 27, 2018 08:31PM
436
June 27, 2018 11:29PM
503
June 28, 2018 01:14AM
515
June 28, 2018 08:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.