Debian Codegraph @

mysql-test/suite/ndb_opt/spj_skew.result

raw
1 create table test.parent(a int primary key, b int) engine=ndb;
2 create table test.child(b int primary key, c int) engine=ndb;
3 insert into test.parent values
4 (1,2),(2,3),(3,4),(4,5),(5,5),(6,7),(7,8),(8,9);
5 insert into test.child values
6 (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);
7 create temporary table counters_at_startup
8 select * from ndbinfo.counters
9 where block_name="DBSPJ";
10
11 Report (and fail) if there are too much skew in 'TABLE_SCANS_RECEIVED':
12 Skewed SPJ load counter_name min(cnt.val-old.val) max(cnt.val-old.val)