| 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 |