Debian Codegraph @

mysql-test/suite/ndbcluster/trans_hint_count.result

raw
1 SHOW GLOBAL STATUS LIKE 'Ndb_trans_hint_count_session';
2 Variable_name Value
3 Ndb_trans_hint_count_session #
4 SHOW SESSION STATUS LIKE 'Ndb_trans_hint_count_session';
5 Variable_name Value
6 Ndb_trans_hint_count_session #
7 SHOW STATUS LIKE 'Ndb_trans_hint_count_session';
8 Variable_name Value
9 Ndb_trans_hint_count_session #
10 SELECT VARIABLE_NAME FROM performance_schema.global_status
11 WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session';
12 VARIABLE_NAME
13 Ndb_trans_hint_count_session
14 SELECT VARIABLE_NAME FROM performance_schema.session_status
15 WHERE VARIABLE_NAME LIKE 'Ndb_trans_hint_count_session';
16 VARIABLE_NAME
17 Ndb_trans_hint_count_session
18 CREATE TABLE t1 (
19 a int PRIMARY KEY
20 ) ENGINE = NDB;
21 # Show that counter is still same, no transactions ran yet
22 still_zero
23 0
24 # Run some NDB transactions
25 INSERT INTO t1 VALUES (1);
26 INSERT INTO t1 (a) VALUES (11);
27 INSERT INTO t1 (a) VALUES (12), (37);
28 SELECT * FROM t1 WHERE a = 1;
29 a
30 1
31 REPLACE t1 (a) VALUES (12);
32 SELECT * FROM t1 WHERE a = 12 ORDER BY a;
33 a
34 12
35 DELETE FROM t1 WHERE a = 11;
36 SELECT COUNT(*) FROM t1;
37 COUNT(*)
38 3
39 DELETE FROM t1;
40 # Show that counter increased after performing NDB transactions
41 seven_hinted_transactions
42 7
43 # Compare with counter showing number of started NDB transactions, should
44 # be somewhat larger as not all transactions are hinted.
45 twelve_started_transactions
46 12
47 DROP TABLE t1;