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