Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_trans_conflict_info_stable.inc

raw
1 --disable_query_log
2 # Where multiple user transactions from the Secondary site are
3 # involved, the actual number of rows in-conflict, the number
4 # of epoch transactions with conflicts, and the number of
5 # iterations, vary depending on the distribution of the user
6 # transactions across epochs. e.g. if 3 transactions are in
7 # one epoch (and executed in one batch), then only actual
8 # conflicts will be recorded, but if they are separated, then
9 # implied rows may conflict as well. This can make these
10 # counter values non-deterministic, so this .inc file is used
11 # to check that the stable counters are correct. The stable
12 # counters are the number of rejected rows, and the number
13 # of rejected transactions, which must be the same, regardless
14 # of how the epoch boundaries lie.
15 #
16 #SELECT VARIABLE_VALUE-@init_ndb_conflict_fn_epoch_trans AS ndb_conflict_fn_epoch_trans FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_FN_EPOCH_TRANS";
17 #SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_row_conflict_count AS ndb_conflict_trans_row_conflict_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_ROW_CONFLICT_COUNT";
18 SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_row_reject_count AS ndb_conflict_trans_row_reject_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_ROW_REJECT_COUNT";
19 SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_reject_count AS ndb_conflict_trans_reject_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_REJECT_COUNT";
20 #SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_detect_iter_count AS ndb_conflict_trans_detect_iter_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_DETECT_ITER_COUNT";
21 #SELECT VARIABLE_VALUE-@init_ndb_conflict_trans_conflict_commit_count AS ndb_conflict_trans_conflict_commit_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_TRANS_CONFLICT_COMMIT_COUNT";
22 SELECT VARIABLE_VALUE-@init_ndb_conflict_epoch_delete_delete_count AS ndb_epoch_delete_delete_count FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE "NDB_CONFLICT_EPOCH_DELETE_DELETE_COUNT";
23 --enable_query_log