1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
create table ten(a int primary key);
insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
create table one_k(a int primary key);
insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;
create table t100(pk int primary key, a int, b int, key(a));
insert into t100 select a,a,a from test.one_k;
set global rocksdb_force_flush_memtable_now=1;
select 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;
num_rows entry_deletes entry_singledeletes
1000 0 0
update t100 set a=a+1;
set global rocksdb_force_flush_memtable_now=1;
select 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;
num_rows entry_deletes entry_singledeletes
1000 0 0
1000 0 1000
drop table ten, t100, one_k;
|
