Debian Codegraph @

mysql-test/suite/ndbcluster/stats_counters.test

raw
1 --result_format 2
2 --source include/have_ndb.inc
3
4 ##
5 ## Bug#33840016 Fix ndb_api_wait_nanos_count* statistics gathering
6 ## - check that the 'nanos_count' session value changes during query
7 ##
8 CREATE TABLE t1 (
9 pk int PRIMARY KEY,
10 b VARCHAR(100)
11 ) engine = NDB;
12
13 INSERT INTO t1 VALUES (1, "aaa"), (2, "bbb"), (3, "ccc"), (4, "ddd");
14
15 let $nanos_count_before =
16 `SELECT VARIABLE_VALUE FROM performance_schema.session_status
17 WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session'`;
18
19 ## This query should make the 'nanos_count' move
20 SELECT * FROM t1 WHERE pk=1 FOR UPDATE;
21
22 let $nanos_count_after =
23 `SELECT VARIABLE_VALUE FROM performance_schema.session_status
24 WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session'`;
25 if ($nanos_count_before == $nanos_count_after) {
26 # No change detected in 'nanos_count', dump variables and fail test
27 SELECT VARIABLE_VALUE FROM performance_schema.session_status
28 WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session';
29 echo nanos_count_before: $nanos_count_before;
30 echo nanos_count_after: $nanos_count_after;
31 die Failed to detect change in 'nanos_count' for session;
32 }
33
34 DROP TABLE t1;