sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Initializing worker threads... Creating table 'sbtest1'... Inserting 1000000 records into 'sbtest1' Creating a secondary index on 'sbtest1'... version() 5.7.24-27-log *************************** 1. row *************************** Name: sbtest1 Engine: ROCKSDB Version: 10 Row_format: Fixed Rows: 1000000 Avg_row_length: 199 Data_length: 199121259 Max_data_length: 0 Index_length: 9030494 Data_free: 0 Auto_increment: 1000001 Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: Variable_name Value rocksdb_access_hint_on_compaction_start 1 rocksdb_advise_random_on_open ON rocksdb_allow_concurrent_memtable_write OFF rocksdb_allow_mmap_reads OFF rocksdb_allow_mmap_writes OFF rocksdb_allow_to_start_after_corruption OFF rocksdb_block_cache_size 2147483648 rocksdb_block_restart_interval 16 rocksdb_block_size 4096 rocksdb_block_size_deviation 10 rocksdb_bulk_load OFF rocksdb_bulk_load_allow_sk OFF rocksdb_bulk_load_allow_unsorted OFF rocksdb_bulk_load_size 1000 rocksdb_bytes_per_sync 0 rocksdb_cache_index_and_filter_blocks ON rocksdb_checksums_pct 100 rocksdb_collect_sst_properties ON rocksdb_commit_in_the_middle OFF rocksdb_commit_time_batch_for_recovery OFF rocksdb_compact_cf rocksdb_compaction_readahead_size 0 rocksdb_compaction_sequential_deletes 0 rocksdb_compaction_sequential_deletes_count_sd OFF rocksdb_compaction_sequential_deletes_file_size 0 rocksdb_compaction_sequential_deletes_window 0 rocksdb_concurrent_prepare ON rocksdb_create_checkpoint rocksdb_create_if_missing ON rocksdb_create_missing_column_families OFF rocksdb_datadir ./.rocksdb rocksdb_db_write_buffer_size 0 rocksdb_deadlock_detect OFF rocksdb_deadlock_detect_depth 50 rocksdb_debug_optimizer_no_zero_cardinality ON rocksdb_debug_ttl_ignore_pk OFF rocksdb_debug_ttl_read_filter_ts 0 rocksdb_debug_ttl_rec_ts 0 rocksdb_debug_ttl_snapshot_ts 0 rocksdb_default_cf_options compression=kLZ4Compression;bottommost_compression=kLZ4Compression rocksdb_delayed_write_rate 0 rocksdb_delete_obsolete_files_period_micros 21600000000 rocksdb_enable_bulk_load_api ON rocksdb_enable_native_partition OFF rocksdb_enable_thread_tracking ON rocksdb_enable_ttl ON rocksdb_enable_ttl_read_filtering ON rocksdb_enable_write_thread_adaptive_yield OFF rocksdb_error_if_exists OFF rocksdb_error_on_suboptimal_collation OFF rocksdb_flush_log_at_trx_commit 1 rocksdb_force_compute_memtable_stats ON rocksdb_force_compute_memtable_stats_cachetime 60000000 rocksdb_force_flush_memtable_and_lzero_now OFF rocksdb_force_flush_memtable_now OFF rocksdb_force_index_records_in_range 0 rocksdb_hash_index_allow_collision ON rocksdb_ignore_unknown_options ON rocksdb_index_type kBinarySearch rocksdb_info_log_level error_level rocksdb_is_fd_close_on_exec ON rocksdb_keep_log_file_num 1000 rocksdb_large_prefix OFF rocksdb_lock_scanned_rows OFF rocksdb_lock_wait_timeout 1 rocksdb_log_file_time_to_roll 0 rocksdb_manifest_preallocation_size 4194304 rocksdb_manual_wal_flush ON rocksdb_max_background_jobs 2 rocksdb_max_latest_deadlocks 5 rocksdb_max_log_file_size 0 rocksdb_max_manifest_file_size 18446744073709551615 rocksdb_max_open_files 2500 rocksdb_max_row_locks 1048576 rocksdb_max_subcompactions 1 rocksdb_max_total_wal_size 0 rocksdb_merge_buf_size 67108864 rocksdb_merge_combine_read_size 1073741824 rocksdb_merge_tmp_file_removal_delay_ms 0 rocksdb_new_table_reader_for_compaction_inputs OFF rocksdb_no_block_cache OFF rocksdb_no_create_column_family OFF rocksdb_override_cf_options rocksdb_paranoid_checks ON rocksdb_pause_background_work OFF rocksdb_perf_context_level 0 rocksdb_persistent_cache_path rocksdb_persistent_cache_size_mb 0 rocksdb_pin_l0_filter_and_index_blocks_in_cache ON rocksdb_print_snapshot_conflict_queries OFF rocksdb_rate_limiter_bytes_per_sec 0 rocksdb_read_free_rpl_tables rocksdb_records_in_range 0 rocksdb_reset_stats OFF rocksdb_rpl_skip_tx_api OFF rocksdb_seconds_between_stat_computes 3600 rocksdb_signal_drop_index_thread OFF rocksdb_sim_cache_size 0 rocksdb_skip_bloom_filter_on_read OFF rocksdb_skip_fill_cache OFF rocksdb_sst_mgr_rate_bytes_per_sec 0 rocksdb_stats_dump_period_sec 600 rocksdb_stats_recalc_rate 0 rocksdb_store_row_debug_checksums OFF rocksdb_strict_collation_check ON rocksdb_strict_collation_exceptions rocksdb_table_cache_numshardbits 6 rocksdb_table_stats_sampling_pct 10 rocksdb_tmpdir rocksdb_trace_sst_api OFF rocksdb_two_write_queues ON rocksdb_unsafe_for_binlog OFF rocksdb_update_cf_options rocksdb_use_adaptive_mutex OFF rocksdb_use_direct_io_for_flush_and_compaction OFF rocksdb_use_direct_reads OFF rocksdb_use_fsync OFF rocksdb_validate_tables 1 rocksdb_verify_row_debug_checksums OFF rocksdb_wal_bytes_per_sync 0 rocksdb_wal_dir rocksdb_wal_recovery_mode 1 rocksdb_wal_size_limit_mb 0 rocksdb_wal_ttl_seconds 0 rocksdb_whole_key_filtering ON rocksdb_write_batch_max_bytes 0 rocksdb_write_disable_wal OFF rocksdb_write_ignore_missing_column_families OFF rocksdb_write_policy write_committed Variable_name Value log_bin ON Variable_name Value sync_binlog 1 sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 20 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 247092 other: 0 total: 247092 transactions: 247092 (4117.79 per sec.) queries: 247092 (4117.79 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0047s total number of events: 247092 Latency (ms): min: 2.63 avg: 4.86 max: 174.56 95th percentile: 5.47 sum: 1199874.91 Threads fairness: events (avg/stddev): 12354.6000/0.86 execution time (avg/stddev): 59.9937/0.00 sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 50 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 569356 other: 0 total: 569356 transactions: 569356 (9487.79 per sec.) queries: 569356 (9487.79 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0081s total number of events: 569356 Latency (ms): min: 2.76 avg: 5.27 max: 135.19 95th percentile: 5.88 sum: 2999861.99 Threads fairness: events (avg/stddev): 11387.1200/1.05 execution time (avg/stddev): 59.9972/0.00 sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 80 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 837324 other: 0 total: 837324 transactions: 837324 (13952.85 per sec.) queries: 837324 (13952.85 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0097s total number of events: 837324 Latency (ms): min: 3.08 avg: 5.73 max: 169.65 95th percentile: 6.43 sum: 4799784.62 Threads fairness: events (avg/stddev): 10466.5500/2.17 execution time (avg/stddev): 59.9973/0.00 sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 100 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 1011345 other: 0 total: 1011345 transactions: 1011345 (16852.61 per sec.) queries: 1011345 (16852.61 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0099s total number of events: 1011345 Latency (ms): min: 2.91 avg: 5.93 max: 176.82 95th percentile: 6.67 sum: 5999549.43 Threads fairness: events (avg/stddev): 10113.4500/2.98 execution time (avg/stddev): 59.9955/0.00 sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 150 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 0 write: 1316916 other: 0 total: 1316916 transactions: 1316916 (21942.59 per sec.) queries: 1316916 (21942.59 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0151s total number of events: 1316916 Latency (ms): min: 3.50 avg: 6.83 max: 227.35 95th percentile: 7.84 sum: 8999847.53 Threads fairness: events (avg/stddev): 8779.4400/3.00 execution time (avg/stddev): 59.9990/0.00