1--source include/have_rocksdb.inc
2--source ../include/have_write_committed.inc
3
4# reload with load optimized config
5--let $restart_parameters=restart:--rocksdb_write_disable_wal=1 --rocksdb_flush_log_at_trx_commit=0 --rocksdb_default_cf_options=write_buffer_size=16k;target_file_size_base=16k;level0_file_num_compaction_trigger=4;level0_slowdown_writes_trigger=256;level0_stop_writes_trigger=256;max_write_buffer_number=16;compression_per_level=kNoCompression;memtable=vector:1024 --rocksdb_override_cf_options=__system__={memtable=skip_list:16} --rocksdb_compaction_sequential_deletes=0 --rocksdb_compaction_sequential_deletes_window=0 --rocksdb_allow_concurrent_memtable_write=0
6--source include/restart_mysqld.inc
7
8create table t1(
9       id bigint not null primary key,
10       i1 bigint, #unique
11       i2 bigint, #repeating
12       c1 varchar(20), #unique
13       c2 varchar(20), #repeating
14       index t1_2(i1)
15) engine=rocksdb;
16
17--disable_query_log
18set rocksdb_bulk_load=1;
19let $i=0;
20while ($i<50000)
21{
22  inc $i;
23  eval insert t1(id, i1, i2, c1, c2) values($i, $i, $i div 10, $i, $i div 10);
24}
25set rocksdb_bulk_load=0;
26--enable_query_log
27
28select count(*), sum(id), sum(i1), sum(i2) from t1;
29
30# reload without load optimized config
31--let $restart_parameters=restart:--rocksdb_write_disable_wal=0 --rocksdb_default_cf_options=write_buffer_size=64k;target_file_size_base=64k;max_bytes_for_level_base=1m;compression_per_level=kNoCompression;
32--source include/restart_mysqld.inc
33
34select count(*), sum(id), sum(i1), sum(i2) from t1;
35
36drop table t1;
37--let $restart_parameters=
38--source include/restart_mysqld.inc
39