1--source include/have_rocksdb.inc
2
3create table ten(a int primary key);
4insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5create table one_k(a int primary key);
6insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;
7
8create table t100(pk int primary key, a int, b int, key(a));
9insert into t100 select a,a,a from test.one_k;
10
11set global rocksdb_force_flush_memtable_now=1;
12select num_rows, entry_deletes, entry_singledeletes from information_schema.rocksdb_index_file_map where index_number = (select max(index_number) from information_schema.rocksdb_index_file_map) order by entry_deletes, entry_singledeletes;
13
14update t100 set a=a+1;
15set global rocksdb_force_flush_memtable_now=1;
16select num_rows, entry_deletes, entry_singledeletes from information_schema.rocksdb_index_file_map where index_number = (select max(index_number) from information_schema.rocksdb_index_file_map) order by entry_deletes, entry_singledeletes;
17
18drop table ten, t100, one_k;
19
20