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