1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
#
# Test for "Ndb_trans_hint_count_session" status variable
#
--source include/have_ndb.inc
# Show that the counter is visible in SHOW STATUS and SHOW VARIABLES.
# The variable is visible both in GLOBAL and SESSION scope
# but always show the session value(this is indicated by
# the suffix _session in the variable name).
#
--replace_column 2 #
SHOW GLOBAL STATUS LIKE 'Ndb_trans_hint_count_session';
--replace_column 2 #
SHOW SESSION STATUS LIKE 'Ndb_trans_hint_count_session';
--replace_column 2 #
SHOW STATUS LIKE 'Ndb_trans_hint_count_session';
SELECT VARIABLE_NAME FROM performance_schema.global_status
WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session';
SELECT VARIABLE_NAME FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session';
# Get initial counter value before using NDB
let $initial_trans_hint =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session'`;
#echo initial_trans_hint: $initial_trans_hint;
# Get initial counter value for number of started NDB transactions
let $initial_trans_start =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_api_trans_start_count_session'`;
#echo initial_trans_start: $initial_trans_start;
CREATE TABLE t1 (
a int PRIMARY KEY
) ENGINE = NDB;
--echo # Show that counter is still same, no transactions ran yet
let $trans_hint =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session'`;
#echo trans_hint: $trans_hint;
--disable_query_log ONCE
eval select $trans_hint - $initial_trans_hint as still_zero;
--echo # Run some NDB transactions
INSERT INTO t1 VALUES (1);
INSERT INTO t1 (a) VALUES (11);
INSERT INTO t1 (a) VALUES (12), (37);
SELECT * FROM t1 WHERE a = 1;
REPLACE t1 (a) VALUES (12);
SELECT * FROM t1 WHERE a = 12 ORDER BY a;
DELETE FROM t1 WHERE a = 11;
SELECT COUNT(*) FROM t1;
DELETE FROM t1;
--echo # Show that counter increased after performing NDB transactions
let $trans_hint =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session'`;
#echo trans_hint: $trans_hint;
--disable_query_log ONCE
eval select $trans_hint - $initial_trans_hint as seven_hinted_transactions;
--echo # Compare with counter showing number of started NDB transactions, should
--echo # be somewhat larger as not all transactions are hinted.
let $trans_start =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME LIKE 'Ndb_api_trans_start_count_session'`;
#echo trans_start: $trans_start;
--disable_query_log ONCE
eval select $trans_start - $initial_trans_start as twelve_started_transactions;
DROP TABLE t1;
|
