| 1 |
# ==== Purpose ==== |
| 2 |
# |
| 3 |
# Auxiliary file used by transaction_gtid.test |
| 4 |
# |
| 5 |
# Invoked between transactions in order to reset the state: |
| 6 |
# - set GTID_NEXT to AUTOMATIC since this is required after |
| 7 |
# any transaction that has GTID_NEXT=UUID:NUMBER |
| 8 |
# - RESET MASTER in order to clear @@global.gtid_executed, so |
| 9 |
# that the same GTID can be executed again. |
| 10 |
# - truncate the performance_schema.events_transaction_* tables |
| 11 |
# |
| 12 |
# All this is done on the connection 'server_1'. |
| 13 |
|
| 14 |
--disable_query_log |
| 15 |
--connection server_1 |
| 16 |
RESET MASTER; |
| 17 |
TRUNCATE TABLE performance_schema.events_transactions_history; |
| 18 |
TRUNCATE TABLE performance_schema.events_transactions_current; |
| 19 |
--enable_query_log |
| 20 |
--connection default |