Created
February 6, 2025 15:04
-
-
Save achanda/0573edba573d427506c20698e08e6d35 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@guest:~/RocksDB-Wrapper# ./bin/working_version --cc=1 --size_ratio=4 --entries_per_page=32 --entry_size=128 --buffer_size_in_pages=16 --bits_per_key=5 --stat=1 | |
| Destroying database ... | |
| Clearing system cache ... | |
| cmpt_sty cmpt_pri T P B E M file_size L1_size blk_cch BPK WSZ | |
| 1 1 4 16 32 128 65536 65536 262144 0 5 1000000 | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 50396602, block_cache_hit_count = 0, block_read_count = 0, block_read_byte = 0, block_read_time = 0, block_read_cpu_time = 0, block_cache_index_hit_count = 0, block_cache_standalone_handle_count = 0, block_cache_real_handle_count = 0, index_block_read_count = 0, block_cache_filter_hit_count = 0, filter_block_read_count = 0, compression_dict_block_read_count = 0, block_cache_index_read_byte = 0, block_cache_filter_read_byte = 0, block_cache_compression_dict_read_byte = 0, block_cache_read_byte = 0, secondary_cache_hit_count = 0, compressed_sec_cache_insert_real_count = 0, compressed_sec_cache_insert_dummy_count = 0, compressed_sec_cache_uncompressed_bytes = 0, compressed_sec_cache_compressed_bytes = 0, block_checksum_time = 0, block_decompress_time = 0, get_read_bytes = 0, multiget_read_bytes = 0, iter_read_bytes = 0, blob_cache_hit_count = 0, blob_read_count = 0, blob_read_byte = 0, blob_read_time = 0, blob_checksum_time = 0, blob_decompress_time = 0, internal_key_skipped_count = 0, internal_delete_skipped_count = 0, internal_recent_skipped_count = 0, internal_merge_count = 0, internal_merge_point_lookup_count = 0, internal_range_del_reseek_count = 0, get_snapshot_time = 0, get_from_memtable_time = 0, get_from_memtable_count = 0, get_post_process_time = 0, get_from_output_files_time = 0, seek_on_memtable_time = 0, seek_on_memtable_count = 0, next_on_memtable_count = 0, prev_on_memtable_count = 0, seek_child_seek_time = 0, seek_child_seek_count = 0, seek_min_heap_time = 0, seek_max_heap_time = 0, seek_internal_seek_time = 0, find_next_user_entry_time = 0, write_wal_time = 0, write_memtable_time = 1429908914, write_delay_time = 182486568556, write_scheduling_flushes_compactions_time = 950577139, write_pre_and_post_process_time = 450072481, write_thread_wait_nanos = 0, db_mutex_lock_nanos = 0, db_condition_wait_nanos = 0, merge_operator_time_nanos = 0, read_index_block_nanos = 0, read_filter_block_nanos = 0, new_table_block_iter_nanos = 0, new_table_iterator_nanos = 0, block_seek_nanos = 0, find_table_nanos = 0, bloom_memtable_hit_count = 0, bloom_memtable_miss_count = 0, bloom_sst_hit_count = 0, bloom_sst_miss_count = 0, key_lock_wait_time = 0, key_lock_wait_count = 0, env_new_sequential_file_nanos = 0, env_new_random_access_file_nanos = 0, env_new_writable_file_nanos = 0, env_reuse_writable_file_nanos = 0, env_new_random_rw_file_nanos = 0, env_new_directory_nanos = 0, env_file_exists_nanos = 0, env_get_children_nanos = 0, env_get_children_file_attributes_nanos = 0, env_delete_file_nanos = 0, env_create_dir_nanos = 0, env_create_dir_if_missing_nanos = 0, env_delete_dir_nanos = 0, env_get_file_size_nanos = 0, env_get_file_modification_time_nanos = 0, env_rename_file_nanos = 0, env_link_file_nanos = 0, env_lock_file_nanos = 0, env_unlock_file_nanos = 0, env_new_logger_nanos = 0, get_cpu_nanos = 0, iter_next_cpu_nanos = 0, iter_prev_cpu_nanos = 0, iter_seek_cpu_nanos = 0, iter_next_count = 0, iter_prev_count = 0, iter_seek_count = 0, encrypt_data_nanos = 0, decrypt_data_nanos = 0, number_async_seek = 0, bloom_filter_useful = bloom_filter_full_positive = bloom_filter_full_true_positive = user_key_return_count = get_from_table_nanos = block_cache_hit_count = block_cache_miss_count = | |
| RocksDB IO Stats Context: | |
| thread_pool_id = 4, bytes_read = 0, bytes_written = 0, open_nanos = 0, allocate_nanos = 0, write_nanos = 0, read_nanos = 0, range_sync_nanos = 0, fsync_nanos = 0, prepare_write_nanos = 0, logger_nanos = 41942562, cpu_write_nanos = 0, cpu_read_nanos = 0, file_io_stats_by_temperature.hot_file_bytes_read = 0, file_io_stats_by_temperature.warm_file_bytes_read = 0, file_io_stats_by_temperature.cold_file_bytes_read = 0, file_io_stats_by_temperature.hot_file_read_count = 0, file_io_stats_by_temperature.warm_file_read_count = 0, file_io_stats_by_temperature.cold_file_read_count = 0 | |
| Rocksdb Stats: | |
| rocksdb.block.cache.miss COUNT : 0 | |
| rocksdb.block.cache.hit COUNT : 0 | |
| rocksdb.block.cache.add COUNT : 0 | |
| rocksdb.block.cache.add.failures COUNT : 0 | |
| rocksdb.block.cache.index.miss COUNT : 0 | |
| rocksdb.block.cache.index.hit COUNT : 0 | |
| rocksdb.block.cache.index.add COUNT : 0 | |
| rocksdb.block.cache.index.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.filter.miss COUNT : 0 | |
| rocksdb.block.cache.filter.hit COUNT : 0 | |
| rocksdb.block.cache.filter.add COUNT : 0 | |
| rocksdb.block.cache.filter.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.data.miss COUNT : 0 | |
| rocksdb.block.cache.data.hit COUNT : 0 | |
| rocksdb.block.cache.data.add COUNT : 0 | |
| rocksdb.block.cache.data.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.bytes.read COUNT : 0 | |
| rocksdb.block.cache.bytes.write COUNT : 0 | |
| rocksdb.block.cache.compression.dict.miss COUNT : 0 | |
| rocksdb.block.cache.compression.dict.hit COUNT : 0 | |
| rocksdb.block.cache.compression.dict.add COUNT : 0 | |
| rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.add.redundant COUNT : 0 | |
| rocksdb.block.cache.index.add.redundant COUNT : 0 | |
| rocksdb.block.cache.filter.add.redundant COUNT : 0 | |
| rocksdb.block.cache.data.add.redundant COUNT : 0 | |
| rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 | |
| rocksdb.secondary.cache.hits COUNT : 0 | |
| rocksdb.secondary.cache.filter.hits COUNT : 0 | |
| rocksdb.secondary.cache.index.hits COUNT : 0 | |
| rocksdb.secondary.cache.data.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.dummy.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.promotions COUNT : 0 | |
| rocksdb.compressed.secondary.cache.promotion.skips COUNT : 0 | |
| rocksdb.bloom.filter.useful COUNT : 0 | |
| rocksdb.bloom.filter.full.positive COUNT : 0 | |
| rocksdb.bloom.filter.full.true.positive COUNT : 0 | |
| rocksdb.bloom.filter.prefix.checked COUNT : 0 | |
| rocksdb.bloom.filter.prefix.useful COUNT : 0 | |
| rocksdb.bloom.filter.prefix.true.positive COUNT : 0 | |
| rocksdb.persistent.cache.hit COUNT : 0 | |
| rocksdb.persistent.cache.miss COUNT : 0 | |
| rocksdb.sim.block.cache.hit COUNT : 0 | |
| rocksdb.sim.block.cache.miss COUNT : 0 | |
| rocksdb.memtable.hit COUNT : 0 | |
| rocksdb.memtable.miss COUNT : 0 | |
| rocksdb.l0.hit COUNT : 0 | |
| rocksdb.l1.hit COUNT : 0 | |
| rocksdb.l2andup.hit COUNT : 0 | |
| rocksdb.compaction.key.drop.new COUNT : 0 | |
| rocksdb.compaction.key.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.key.drop.range_del COUNT : 0 | |
| rocksdb.compaction.key.drop.user COUNT : 0 | |
| rocksdb.compaction.range_del.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.cancelled COUNT : 0 | |
| rocksdb.number.keys.written COUNT : 1000001 | |
| rocksdb.number.keys.read COUNT : 0 | |
| rocksdb.number.keys.updated COUNT : 0 | |
| rocksdb.bytes.written COUNT : 143000015 | |
| rocksdb.bytes.read COUNT : 0 | |
| rocksdb.number.db.seek COUNT : 0 | |
| rocksdb.number.db.next COUNT : 0 | |
| rocksdb.number.db.prev COUNT : 0 | |
| rocksdb.number.db.seek.found COUNT : 0 | |
| rocksdb.number.db.next.found COUNT : 0 | |
| rocksdb.number.db.prev.found COUNT : 0 | |
| rocksdb.db.iter.bytes.read COUNT : 0 | |
| rocksdb.number.iter.skip COUNT : 0 | |
| rocksdb.number.reseeks.iteration COUNT : 0 | |
| rocksdb.num.iterator.created COUNT : 1 | |
| rocksdb.num.iterator.deleted COUNT : 1 | |
| rocksdb.no.file.opens COUNT : 45652 | |
| rocksdb.no.file.errors COUNT : 0 | |
| rocksdb.stall.micros COUNT : 182482921 | |
| rocksdb.db.mutex.wait.micros COUNT : 0 | |
| rocksdb.number.multiget.get COUNT : 0 | |
| rocksdb.number.multiget.keys.read COUNT : 0 | |
| rocksdb.number.multiget.bytes.read COUNT : 0 | |
| rocksdb.number.multiget.keys.found COUNT : 0 | |
| rocksdb.number.merge.failures COUNT : 0 | |
| rocksdb.getupdatessince.calls COUNT : 0 | |
| rocksdb.wal.synced COUNT : 0 | |
| rocksdb.wal.bytes COUNT : 0 | |
| rocksdb.write.self COUNT : 1000001 | |
| rocksdb.write.other COUNT : 0 | |
| rocksdb.write.wal COUNT : 0 | |
| rocksdb.compact.read.bytes COUNT : 1799346716 | |
| rocksdb.compact.write.bytes COUNT : 1684593152 | |
| rocksdb.flush.write.bytes COUNT : 146010036 | |
| rocksdb.compact.read.marked.bytes COUNT : 0 | |
| rocksdb.compact.read.periodic.bytes COUNT : 0 | |
| rocksdb.compact.read.ttl.bytes COUNT : 0 | |
| rocksdb.compact.write.marked.bytes COUNT : 0 | |
| rocksdb.compact.write.periodic.bytes COUNT : 0 | |
| rocksdb.compact.write.ttl.bytes COUNT : 0 | |
| rocksdb.number.direct.load.table.properties COUNT : 20890 | |
| rocksdb.number.superversion_acquires COUNT : 1 | |
| rocksdb.number.superversion_releases COUNT : 0 | |
| rocksdb.number.superversion_cleanups COUNT : 0 | |
| rocksdb.number.block.compressed COUNT : 0 | |
| rocksdb.number.block.decompressed COUNT : 0 | |
| rocksdb.bytes.compressed.from COUNT : 0 | |
| rocksdb.bytes.compressed.to COUNT : 0 | |
| rocksdb.bytes.compression_bypassed COUNT : 1745976039 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 438838 | |
| rocksdb.number.block_compression_rejected COUNT : 0 | |
| rocksdb.bytes.decompressed.from COUNT : 0 | |
| rocksdb.bytes.decompressed.to COUNT : 0 | |
| rocksdb.merge.operation.time.nanos COUNT : 0 | |
| rocksdb.filter.operation.time.nanos COUNT : 0 | |
| rocksdb.compaction.total.time.cpu_micros COUNT : 23764996 | |
| rocksdb.row.cache.hit COUNT : 0 | |
| rocksdb.row.cache.miss COUNT : 0 | |
| rocksdb.read.amp.estimate.useful.bytes COUNT : 0 | |
| rocksdb.read.amp.total.read.bytes COUNT : 0 | |
| rocksdb.number.rate_limiter.drains COUNT : 0 | |
| rocksdb.blobdb.num.put COUNT : 0 | |
| rocksdb.blobdb.num.write COUNT : 0 | |
| rocksdb.blobdb.num.get COUNT : 0 | |
| rocksdb.blobdb.num.multiget COUNT : 0 | |
| rocksdb.blobdb.num.seek COUNT : 0 | |
| rocksdb.blobdb.num.next COUNT : 0 | |
| rocksdb.blobdb.num.prev COUNT : 0 | |
| rocksdb.blobdb.num.keys.written COUNT : 0 | |
| rocksdb.blobdb.num.keys.read COUNT : 0 | |
| rocksdb.blobdb.bytes.written COUNT : 0 | |
| rocksdb.blobdb.bytes.read COUNT : 0 | |
| rocksdb.blobdb.write.inlined COUNT : 0 | |
| rocksdb.blobdb.write.inlined.ttl COUNT : 0 | |
| rocksdb.blobdb.write.blob COUNT : 0 | |
| rocksdb.blobdb.write.blob.ttl COUNT : 0 | |
| rocksdb.blobdb.blob.file.bytes.written COUNT : 0 | |
| rocksdb.blobdb.blob.file.bytes.read COUNT : 0 | |
| rocksdb.blobdb.blob.file.synced COUNT : 0 | |
| rocksdb.blobdb.blob.index.expired.count COUNT : 0 | |
| rocksdb.blobdb.blob.index.expired.size COUNT : 0 | |
| rocksdb.blobdb.blob.index.evicted.count COUNT : 0 | |
| rocksdb.blobdb.blob.index.evicted.size COUNT : 0 | |
| rocksdb.blobdb.gc.num.files COUNT : 0 | |
| rocksdb.blobdb.gc.num.new.files COUNT : 0 | |
| rocksdb.blobdb.gc.failures COUNT : 0 | |
| rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 | |
| rocksdb.blobdb.gc.bytes.relocated COUNT : 0 | |
| rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 | |
| rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 | |
| rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 | |
| rocksdb.blobdb.cache.miss COUNT : 0 | |
| rocksdb.blobdb.cache.hit COUNT : 0 | |
| rocksdb.blobdb.cache.add COUNT : 0 | |
| rocksdb.blobdb.cache.add.failures COUNT : 0 | |
| rocksdb.blobdb.cache.bytes.read COUNT : 0 | |
| rocksdb.blobdb.cache.bytes.write COUNT : 0 | |
| rocksdb.txn.overhead.mutex.prepare COUNT : 0 | |
| rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 | |
| rocksdb.txn.overhead.duplicate.key COUNT : 0 | |
| rocksdb.txn.overhead.mutex.snapshot COUNT : 0 | |
| rocksdb.txn.get.tryagain COUNT : 0 | |
| rocksdb.files.marked.trash COUNT : 0 | |
| rocksdb.files.marked.trash.deleted COUNT : 0 | |
| rocksdb.files.deleted.immediately COUNT : 27129 | |
| rocksdb.error.handler.bg.error.count COUNT : 0 | |
| rocksdb.error.handler.bg.io.error.count COUNT : 0 | |
| rocksdb.error.handler.bg.retryable.io.error.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.success.count COUNT : 0 | |
| rocksdb.memtable.payload.bytes.at.flush COUNT : 136000008 | |
| rocksdb.memtable.garbage.bytes.at.flush COUNT : 0 | |
| rocksdb.verify_checksum.read.bytes COUNT : 0 | |
| rocksdb.backup.read.bytes COUNT : 0 | |
| rocksdb.backup.write.bytes COUNT : 0 | |
| rocksdb.remote.compact.read.bytes COUNT : 0 | |
| rocksdb.remote.compact.write.bytes COUNT : 0 | |
| rocksdb.hot.file.read.bytes COUNT : 0 | |
| rocksdb.warm.file.read.bytes COUNT : 0 | |
| rocksdb.cold.file.read.bytes COUNT : 0 | |
| rocksdb.hot.file.read.count COUNT : 0 | |
| rocksdb.warm.file.read.count COUNT : 0 | |
| rocksdb.cold.file.read.count COUNT : 0 | |
| rocksdb.last.level.read.bytes COUNT : 0 | |
| rocksdb.last.level.read.count COUNT : 0 | |
| rocksdb.non.last.level.read.bytes COUNT : 1828681411 | |
| rocksdb.non.last.level.read.count COUNT : 135453 | |
| rocksdb.last.level.seek.filtered COUNT : 0 | |
| rocksdb.last.level.seek.filter.match COUNT : 0 | |
| rocksdb.last.level.seek.data COUNT : 0 | |
| rocksdb.last.level.seek.data.useful.no.filter COUNT : 0 | |
| rocksdb.last.level.seek.data.useful.filter.match COUNT : 0 | |
| rocksdb.non.last.level.seek.filtered COUNT : 0 | |
| rocksdb.non.last.level.seek.filter.match COUNT : 0 | |
| rocksdb.non.last.level.seek.data COUNT : 0 | |
| rocksdb.non.last.level.seek.data.useful.no.filter COUNT : 0 | |
| rocksdb.non.last.level.seek.data.useful.filter.match COUNT : 0 | |
| rocksdb.block.checksum.compute.count COUNT : 561698 | |
| rocksdb.block.checksum.mismatch.count COUNT : 0 | |
| rocksdb.multiget.coroutine.count COUNT : 0 | |
| rocksdb.read.async.micros COUNT : 0 | |
| rocksdb.async.read.error.count COUNT : 0 | |
| rocksdb.table.open.prefetch.tail.miss COUNT : 0 | |
| rocksdb.table.open.prefetch.tail.hit COUNT : 228260 | |
| rocksdb.timestamp.filter.table.checked COUNT : 0 | |
| rocksdb.timestamp.filter.table.filtered COUNT : 0 | |
| rocksdb.readahead.trimmed COUNT : 0 | |
| rocksdb.fifo.max.size.compactions COUNT : 0 | |
| rocksdb.fifo.ttl.compactions COUNT : 0 | |
| rocksdb.prefetch.bytes COUNT : 0 | |
| rocksdb.prefetch.bytes.useful COUNT : 114819977 | |
| rocksdb.prefetch.hits COUNT : 228260 | |
| rocksdb.footer.corruption.count COUNT : 0 | |
| rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.write.micros P50 : 1.057729 P95 : 3.981066 P99 : 5.993359 P100 : 849500.000000 COUNT : 1000001 SUM : 185378887 | |
| rocksdb.compaction.times.micros P50 : 41130.071990 P95 : 78340.909091 P99 : 105344.456763 P100 : 759411.000000 COUNT : 8699 SUM : 377733188 | |
| rocksdb.compaction.times.cpu_micros P50 : 2414.852986 P95 : 4953.982759 P99 : 6273.831034 P100 : 7169.000000 COUNT : 8699 SUM : 22405427 | |
| rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.table.sync.micros P50 : 2410.928962 P95 : 6427.233429 P99 : 9465.892857 P100 : 16875.000000 COUNT : 2505 SUM : 7012806 | |
| rocksdb.compaction.outfile.sync.micros P50 : 1371.570248 P95 : 5906.619981 P99 : 9069.673469 P100 : 26079.000000 COUNT : 26962 SUM : 54625195 | |
| rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.manifest.file.sync.micros P50 : 3808.034361 P95 : 10730.975143 P99 : 14755.555556 P100 : 60361.000000 COUNT : 10680 SUM : 47743372 | |
| rocksdb.table.open.io.micros P50 : 551.132740 P95 : 4074.136196 P99 : 6333.375093 P100 : 38471.000000 COUNT : 45652 SUM : 52895829 | |
| rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.read.block.compaction.micros P50 : 0.603875 P95 : 1010.282799 P99 : 2818.250729 P100 : 28183.000000 COUNT : 403852 SUM : 47725978 | |
| rocksdb.read.block.get.micros P50 : 0.718703 P95 : 2.162325 P99 : 3.538545 P100 : 78.000000 COUNT : 91304 SUM : 111825 | |
| rocksdb.write.raw.block.micros P50 : 0.664102 P95 : 12.929240 P99 : 68.796307 P100 : 38234.000000 COUNT : 556706 SUM : 3487254 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.210148 P95 : 5.389691 P99 : 5.936283 P100 : 8.000000 COUNT : 9743 SUM : 29310 | |
| rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.write.stall P50 : 142507.936508 P95 : 228279.329609 P99 : 267490.909091 P100 : 849447.000000 COUNT : 1252 SUM : 182482921 | |
| rocksdb.sst.read.micros P50 : 371.992365 P95 : 3468.325008 P99 : 5848.266947 P100 : 38258.000000 COUNT : 135453 SUM : 124694137 | |
| rocksdb.file.read.flush.micros P50 : 1547.959184 P95 : 5891.806020 P99 : 8560.813953 P100 : 38258.000000 COUNT : 3045 SUM : 6350391 | |
| rocksdb.file.read.compaction.micros P50 : 362.461109 P95 : 3334.879244 P99 : 5712.921002 P100 : 28172.000000 COUNT : 132408 SUM : 118343746 | |
| rocksdb.file.read.db.open.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.db.iterator.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.verify.db.checksum.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.verify.file.checksums.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.sst.write.micros P50 : 0.520757 P95 : 0.989439 P99 : 40.781834 P100 : 38228.000000 COUNT : 1142879 SUM : 3276507 | |
| rocksdb.file.write.flush.micros P50 : 0.503045 P95 : 0.955786 P99 : 0.996030 P100 : 43.000000 COUNT : 92665 SUM : 37528 | |
| rocksdb.file.write.compaction.micros P50 : 0.522380 P95 : 0.992522 P99 : 43.335002 P100 : 38228.000000 COUNT : 1050214 SUM : 3238979 | |
| rocksdb.file.write.db.open.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.bytes.per.read P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.bytes.per.write P50 : 139.999970 P95 : 143.000000 P99 : 143.000000 P100 : 143.000000 COUNT : 1000001 SUM : 143000015 | |
| rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.flush.micros P50 : 22664.835165 P95 : 35125.000000 P99 : 48644.047619 P100 : 742575.000000 COUNT : 2505 SUM : 59382967 | |
| rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.prefetched.bytes.discarded P50 : 2367.976659 P95 : 3558.716268 P99 : 4232.113338 P100 : 76597.000000 COUNT : 72783 SUM : 169099258 | |
| rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.table.open.prefetch.tail.read.bytes P50 : 3362.553829 P95 : 4324.143419 P99 : 5082.864048 P100 : 5120.000000 COUNT : 45652 SUM : 138659328 | |
| rocksdb.db.get.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.get.filter.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.get.index.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.get.disk.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.get.memory.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.put.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.put.memory.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| DB_GET_CORE_JOULES | |
| Count: 0 Average: 0.0000 StdDev: 0.00 | |
| Min: 0 Median: 0.0000 Max: 0 | |
| Percentiles: P50: 0.00 P75: 0.00 P99: 0.00 P99.9: 0.00 P99.99: 0.00 | |
| ------------------------------------------------------ | |
| DB_GET_FILTER_CORE_JOULES | |
| Count: 0 Average: 0.0000 StdDev: 0.00 | |
| Min: 0 Median: 0.0000 Max: 0 | |
| Percentiles: P50: 0.00 P75: 0.00 P99: 0.00 P99.9: 0.00 P99.99: 0.00 | |
| ------------------------------------------------------ | |
| DB_GET_INDEX_CORE_JOULES | |
| Count: 0 Average: 0.0000 StdDev: 0.00 | |
| Min: 0 Median: 0.0000 Max: 0 | |
| Percentiles: P50: 0.00 P75: 0.00 P99: 0.00 P99.9: 0.00 P99.99: 0.00 | |
| ------------------------------------------------------ | |
| DB_GET_DISK_CORE_JOULES | |
| Count: 0 Average: 0.0000 StdDev: 0.00 | |
| Min: 0 Median: 0.0000 Max: 0 | |
| Percentiles: P50: 0.00 P75: 0.00 P99: 0.00 P99.9: 0.00 P99.99: 0.00 | |
| ------------------------------------------------------ | |
| Bulk load time: 188.866 seconds | |
| LSM-tree structure: | |
| ------------------- | |
| Level 0: | |
| Total for Level 0: 0 elements, 0 bytes | |
| Level 1: | |
| Total for Level 1: 1890 elements, 274187 bytes | |
| Level 2: | |
| Total for Level 2: 7236 elements, 1041123 bytes | |
| Level 3: | |
| Total for Level 3: 28860 elements, 4142795 bytes | |
| Level 4: | |
| Total for Level 4: 117698 elements, 16849623 bytes | |
| Level 5: | |
| Total for Level 5: 468354 elements, 66969798 bytes | |
| Level 6: | |
| Total for Level 6: 375963 elements, 53795653 bytes | |
| ------------------- | |
| Total elements across all levels: 1000001 | |
| cmpt_sty cmpt_pri T P B E M file_size L1_size blk_cch BPK WSZ | |
| 1 1 4 16 32 128 65536 65536 262144 0 5 1000000 | |
| [WARNING] ZERO start: 33942408468 end: 33942408468 | |
| [WARNING] ZERO start: 46756458428 end: 46756458428 | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 25677717, block_cache_hit_count = 0, block_read_count = 1240161, block_read_byte = 5065974777, block_read_time = 281350628457, block_read_cpu_time = 24813209508, block_cache_index_hit_count = 0, block_cache_standalone_handle_count = 0, block_cache_real_handle_count = 0, index_block_read_count = 0, block_cache_filter_hit_count = 0, filter_block_read_count = 0, compression_dict_block_read_count = 0, block_cache_index_read_byte = 0, block_cache_filter_read_byte = 0, block_cache_compression_dict_read_byte = 0, block_cache_read_byte = 0, secondary_cache_hit_count = 0, compressed_sec_cache_insert_real_count = 0, compressed_sec_cache_insert_dummy_count = 0, compressed_sec_cache_uncompressed_bytes = 0, compressed_sec_cache_compressed_bytes = 0, block_checksum_time = 2852610056, block_decompress_time = 0, get_read_bytes = 64000000, multiget_read_bytes = 0, iter_read_bytes = 0, blob_cache_hit_count = 0, blob_read_count = 0, blob_read_byte = 0, blob_read_time = 0, blob_checksum_time = 0, blob_decompress_time = 0, internal_key_skipped_count = 0, internal_delete_skipped_count = 0, internal_recent_skipped_count = 0, internal_merge_count = 0, internal_merge_point_lookup_count = 0, internal_range_del_reseek_count = 0, get_snapshot_time = 62440690587, get_from_memtable_time = 0, get_from_memtable_count = 0, get_post_process_time = 1278251370609, get_from_output_files_time = 10538551003532, seek_on_memtable_time = 0, seek_on_memtable_count = 0, next_on_memtable_count = 0, prev_on_memtable_count = 0, seek_child_seek_time = 0, seek_child_seek_count = 0, seek_min_heap_time = 0, seek_max_heap_time = 0, seek_internal_seek_time = 0, find_next_user_entry_time = 0, write_wal_time = 0, write_memtable_time = 0, write_delay_time = 0, write_scheduling_flushes_compactions_time = 0, write_pre_and_post_process_time = 0, write_thread_wait_nanos = 0, db_mutex_lock_nanos = 0, db_condition_wait_nanos = 0, merge_operator_time_nanos = 0, read_index_block_nanos = 8150875175, read_filter_block_nanos = 2608251087, new_table_block_iter_nanos = 287156745672, new_table_iterator_nanos = 0, block_seek_nanos = 6142391324, find_table_nanos = 838391464236, bloom_memtable_hit_count = 0, bloom_memtable_miss_count = 0, bloom_sst_hit_count = 1240161, bloom_sst_miss_count = 3264935, key_lock_wait_time = 0, key_lock_wait_count = 0, env_new_sequential_file_nanos = 0, env_new_random_access_file_nanos = 0, env_new_writable_file_nanos = 0, env_reuse_writable_file_nanos = 0, env_new_random_rw_file_nanos = 0, env_new_directory_nanos = 0, env_file_exists_nanos = 0, env_get_children_nanos = 0, env_get_children_file_attributes_nanos = 0, env_delete_file_nanos = 0, env_create_dir_nanos = 0, env_create_dir_if_missing_nanos = 0, env_delete_dir_nanos = 0, env_get_file_size_nanos = 0, env_get_file_modification_time_nanos = 0, env_rename_file_nanos = 0, env_link_file_nanos = 0, env_lock_file_nanos = 0, env_unlock_file_nanos = 0, env_new_logger_nanos = 0, get_cpu_nanos = 711412719393, iter_next_cpu_nanos = 0, iter_prev_cpu_nanos = 0, iter_seek_cpu_nanos = 0, iter_next_count = 0, iter_prev_count = 0, iter_seek_count = 0, encrypt_data_nanos = 0, decrypt_data_nanos = 0, number_async_seek = 0, bloom_filter_useful = 817142@level1, 655755@level2, 780576@level3, 681926@level4, 329536@level5, 0@level6, bloom_filter_full_positive = 52481@level1, 59500@level2, 86475@level3, 169512@level4, 494930@level5, 377263@level6, bloom_filter_full_true_positive = 1502@level1, 7040@level2, 28721@level3, 116176@level4, 469299@level5, 377263@level6, user_key_return_count = 1502@level1, 7040@level2, 28721@level3, 116176@level4, 469299@level5, 377263@level6, get_from_table_nanos = 1314861687974@level1, 1235006152978@level2, 1616524628823@level3, 1873922104266@level4, 2780892755996@level5, 1712077678127@level6, block_cache_hit_count = 0@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6, block_cache_miss_count = 0@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6 | |
| RocksDB IO Stats Context: | |
| thread_pool_id = 4, bytes_read = 13856069304, bytes_written = 0, open_nanos = 10012827440, allocate_nanos = 0, write_nanos = 0, read_nanos = 932402140814, range_sync_nanos = 0, fsync_nanos = 0, prepare_write_nanos = 0, logger_nanos = 26622, cpu_write_nanos = 0, cpu_read_nanos = 69138688693, file_io_stats_by_temperature.hot_file_bytes_read = 0, file_io_stats_by_temperature.warm_file_bytes_read = 0, file_io_stats_by_temperature.cold_file_bytes_read = 0, file_io_stats_by_temperature.hot_file_read_count = 0, file_io_stats_by_temperature.warm_file_read_count = 0, file_io_stats_by_temperature.cold_file_read_count = 0 | |
| Rocksdb Stats: | |
| rocksdb.block.cache.miss COUNT : 0 | |
| rocksdb.block.cache.hit COUNT : 0 | |
| rocksdb.block.cache.add COUNT : 0 | |
| rocksdb.block.cache.add.failures COUNT : 0 | |
| rocksdb.block.cache.index.miss COUNT : 0 | |
| rocksdb.block.cache.index.hit COUNT : 0 | |
| rocksdb.block.cache.index.add COUNT : 0 | |
| rocksdb.block.cache.index.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.filter.miss COUNT : 0 | |
| rocksdb.block.cache.filter.hit COUNT : 0 | |
| rocksdb.block.cache.filter.add COUNT : 0 | |
| rocksdb.block.cache.filter.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.data.miss COUNT : 0 | |
| rocksdb.block.cache.data.hit COUNT : 0 | |
| rocksdb.block.cache.data.add COUNT : 0 | |
| rocksdb.block.cache.data.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.bytes.read COUNT : 0 | |
| rocksdb.block.cache.bytes.write COUNT : 0 | |
| rocksdb.block.cache.compression.dict.miss COUNT : 0 | |
| rocksdb.block.cache.compression.dict.hit COUNT : 0 | |
| rocksdb.block.cache.compression.dict.add COUNT : 0 | |
| rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 | |
| rocksdb.block.cache.add.redundant COUNT : 0 | |
| rocksdb.block.cache.index.add.redundant COUNT : 0 | |
| rocksdb.block.cache.filter.add.redundant COUNT : 0 | |
| rocksdb.block.cache.data.add.redundant COUNT : 0 | |
| rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 | |
| rocksdb.secondary.cache.hits COUNT : 0 | |
| rocksdb.secondary.cache.filter.hits COUNT : 0 | |
| rocksdb.secondary.cache.index.hits COUNT : 0 | |
| rocksdb.secondary.cache.data.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.dummy.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.hits COUNT : 0 | |
| rocksdb.compressed.secondary.cache.promotions COUNT : 0 | |
| rocksdb.compressed.secondary.cache.promotion.skips COUNT : 0 | |
| rocksdb.bloom.filter.useful COUNT : 3264935 | |
| rocksdb.bloom.filter.full.positive COUNT : 1240161 | |
| rocksdb.bloom.filter.full.true.positive COUNT : 1000001 | |
| rocksdb.bloom.filter.prefix.checked COUNT : 0 | |
| rocksdb.bloom.filter.prefix.useful COUNT : 0 | |
| rocksdb.bloom.filter.prefix.true.positive COUNT : 0 | |
| rocksdb.persistent.cache.hit COUNT : 0 | |
| rocksdb.persistent.cache.miss COUNT : 0 | |
| rocksdb.sim.block.cache.hit COUNT : 0 | |
| rocksdb.sim.block.cache.miss COUNT : 0 | |
| rocksdb.memtable.hit COUNT : 0 | |
| rocksdb.memtable.miss COUNT : 1000001 | |
| rocksdb.l0.hit COUNT : 0 | |
| rocksdb.l1.hit COUNT : 1502 | |
| rocksdb.l2andup.hit COUNT : 998499 | |
| rocksdb.compaction.key.drop.new COUNT : 0 | |
| rocksdb.compaction.key.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.key.drop.range_del COUNT : 0 | |
| rocksdb.compaction.key.drop.user COUNT : 0 | |
| rocksdb.compaction.range_del.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0 | |
| rocksdb.compaction.cancelled COUNT : 0 | |
| rocksdb.number.keys.written COUNT : 0 | |
| rocksdb.number.keys.read COUNT : 1000001 | |
| rocksdb.number.keys.updated COUNT : 0 | |
| rocksdb.bytes.written COUNT : 0 | |
| rocksdb.bytes.read COUNT : 64000000 | |
| rocksdb.number.db.seek COUNT : 0 | |
| rocksdb.number.db.next COUNT : 0 | |
| rocksdb.number.db.prev COUNT : 0 | |
| rocksdb.number.db.seek.found COUNT : 0 | |
| rocksdb.number.db.next.found COUNT : 0 | |
| rocksdb.number.db.prev.found COUNT : 0 | |
| rocksdb.db.iter.bytes.read COUNT : 0 | |
| rocksdb.number.iter.skip COUNT : 0 | |
| rocksdb.number.reseeks.iteration COUNT : 0 | |
| rocksdb.num.iterator.created COUNT : 1 | |
| rocksdb.num.iterator.deleted COUNT : 1 | |
| rocksdb.no.file.opens COUNT : 2963152 | |
| rocksdb.no.file.errors COUNT : 0 | |
| rocksdb.stall.micros COUNT : 0 | |
| rocksdb.db.mutex.wait.micros COUNT : 0 | |
| rocksdb.number.multiget.get COUNT : 0 | |
| rocksdb.number.multiget.keys.read COUNT : 0 | |
| rocksdb.number.multiget.bytes.read COUNT : 0 | |
| rocksdb.number.multiget.keys.found COUNT : 0 | |
| rocksdb.number.merge.failures COUNT : 0 | |
| rocksdb.getupdatessince.calls COUNT : 0 | |
| rocksdb.wal.synced COUNT : 0 | |
| rocksdb.wal.bytes COUNT : 0 | |
| rocksdb.write.self COUNT : 0 | |
| rocksdb.write.other COUNT : 0 | |
| rocksdb.write.wal COUNT : 0 | |
| rocksdb.compact.read.bytes COUNT : 1130551 | |
| rocksdb.compact.write.bytes COUNT : 1049600 | |
| rocksdb.flush.write.bytes COUNT : 0 | |
| rocksdb.compact.read.marked.bytes COUNT : 0 | |
| rocksdb.compact.read.periodic.bytes COUNT : 0 | |
| rocksdb.compact.read.ttl.bytes COUNT : 0 | |
| rocksdb.compact.write.marked.bytes COUNT : 0 | |
| rocksdb.compact.write.periodic.bytes COUNT : 0 | |
| rocksdb.compact.write.ttl.bytes COUNT : 0 | |
| rocksdb.number.direct.load.table.properties COUNT : 34 | |
| rocksdb.number.superversion_acquires COUNT : 1 | |
| rocksdb.number.superversion_releases COUNT : 0 | |
| rocksdb.number.superversion_cleanups COUNT : 0 | |
| rocksdb.number.block.compressed COUNT : 0 | |
| rocksdb.number.block.decompressed COUNT : 0 | |
| rocksdb.bytes.compressed.from COUNT : 0 | |
| rocksdb.bytes.compressed.to COUNT : 0 | |
| rocksdb.bytes.compression_bypassed COUNT : 1002577 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 253 | |
| rocksdb.number.block_compression_rejected COUNT : 0 | |
| rocksdb.bytes.decompressed.from COUNT : 0 | |
| rocksdb.bytes.decompressed.to COUNT : 0 | |
| rocksdb.merge.operation.time.nanos COUNT : 0 | |
| rocksdb.filter.operation.time.nanos COUNT : 0 | |
| rocksdb.compaction.total.time.cpu_micros COUNT : 14544 | |
| rocksdb.row.cache.hit COUNT : 0 | |
| rocksdb.row.cache.miss COUNT : 0 | |
| rocksdb.read.amp.estimate.useful.bytes COUNT : 0 | |
| rocksdb.read.amp.total.read.bytes COUNT : 0 | |
| rocksdb.number.rate_limiter.drains COUNT : 0 | |
| rocksdb.blobdb.num.put COUNT : 0 | |
| rocksdb.blobdb.num.write COUNT : 0 | |
| rocksdb.blobdb.num.get COUNT : 0 | |
| rocksdb.blobdb.num.multiget COUNT : 0 | |
| rocksdb.blobdb.num.seek COUNT : 0 | |
| rocksdb.blobdb.num.next COUNT : 0 | |
| rocksdb.blobdb.num.prev COUNT : 0 | |
| rocksdb.blobdb.num.keys.written COUNT : 0 | |
| rocksdb.blobdb.num.keys.read COUNT : 0 | |
| rocksdb.blobdb.bytes.written COUNT : 0 | |
| rocksdb.blobdb.bytes.read COUNT : 0 | |
| rocksdb.blobdb.write.inlined COUNT : 0 | |
| rocksdb.blobdb.write.inlined.ttl COUNT : 0 | |
| rocksdb.blobdb.write.blob COUNT : 0 | |
| rocksdb.blobdb.write.blob.ttl COUNT : 0 | |
| rocksdb.blobdb.blob.file.bytes.written COUNT : 0 | |
| rocksdb.blobdb.blob.file.bytes.read COUNT : 0 | |
| rocksdb.blobdb.blob.file.synced COUNT : 0 | |
| rocksdb.blobdb.blob.index.expired.count COUNT : 0 | |
| rocksdb.blobdb.blob.index.expired.size COUNT : 0 | |
| rocksdb.blobdb.blob.index.evicted.count COUNT : 0 | |
| rocksdb.blobdb.blob.index.evicted.size COUNT : 0 | |
| rocksdb.blobdb.gc.num.files COUNT : 0 | |
| rocksdb.blobdb.gc.num.new.files COUNT : 0 | |
| rocksdb.blobdb.gc.failures COUNT : 0 | |
| rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 | |
| rocksdb.blobdb.gc.bytes.relocated COUNT : 0 | |
| rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 | |
| rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 | |
| rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 | |
| rocksdb.blobdb.cache.miss COUNT : 0 | |
| rocksdb.blobdb.cache.hit COUNT : 0 | |
| rocksdb.blobdb.cache.add COUNT : 0 | |
| rocksdb.blobdb.cache.add.failures COUNT : 0 | |
| rocksdb.blobdb.cache.bytes.read COUNT : 0 | |
| rocksdb.blobdb.cache.bytes.write COUNT : 0 | |
| rocksdb.txn.overhead.mutex.prepare COUNT : 0 | |
| rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 | |
| rocksdb.txn.overhead.duplicate.key COUNT : 0 | |
| rocksdb.txn.overhead.mutex.snapshot COUNT : 0 | |
| rocksdb.txn.get.tryagain COUNT : 0 | |
| rocksdb.files.marked.trash COUNT : 0 | |
| rocksdb.files.marked.trash.deleted COUNT : 0 | |
| rocksdb.files.deleted.immediately COUNT : 15 | |
| rocksdb.error.handler.bg.error.count COUNT : 0 | |
| rocksdb.error.handler.bg.io.error.count COUNT : 0 | |
| rocksdb.error.handler.bg.retryable.io.error.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 | |
| rocksdb.error.handler.autoresume.success.count COUNT : 0 | |
| rocksdb.memtable.payload.bytes.at.flush COUNT : 0 | |
| rocksdb.memtable.garbage.bytes.at.flush COUNT : 0 | |
| rocksdb.verify_checksum.read.bytes COUNT : 0 | |
| rocksdb.backup.read.bytes COUNT : 0 | |
| rocksdb.backup.write.bytes COUNT : 0 | |
| rocksdb.remote.compact.read.bytes COUNT : 0 | |
| rocksdb.remote.compact.write.bytes COUNT : 0 | |
| rocksdb.hot.file.read.bytes COUNT : 0 | |
| rocksdb.warm.file.read.bytes COUNT : 0 | |
| rocksdb.cold.file.read.bytes COUNT : 0 | |
| rocksdb.hot.file.read.count COUNT : 0 | |
| rocksdb.warm.file.read.count COUNT : 0 | |
| rocksdb.cold.file.read.count COUNT : 0 | |
| rocksdb.last.level.read.bytes COUNT : 0 | |
| rocksdb.last.level.read.count COUNT : 0 | |
| rocksdb.non.last.level.read.bytes COUNT : 13857262827 | |
| rocksdb.non.last.level.read.count COUNT : 4203429 | |
| rocksdb.last.level.seek.filtered COUNT : 0 | |
| rocksdb.last.level.seek.filter.match COUNT : 0 | |
| rocksdb.last.level.seek.data COUNT : 0 | |
| rocksdb.last.level.seek.data.useful.no.filter COUNT : 0 | |
| rocksdb.last.level.seek.data.useful.filter.match COUNT : 0 | |
| rocksdb.non.last.level.seek.filtered COUNT : 0 | |
| rocksdb.non.last.level.seek.filter.match COUNT : 0 | |
| rocksdb.non.last.level.seek.data COUNT : 0 | |
| rocksdb.non.last.level.seek.data.useful.no.filter COUNT : 0 | |
| rocksdb.non.last.level.seek.data.useful.filter.match COUNT : 0 | |
| rocksdb.block.checksum.compute.count COUNT : 10129898 | |
| rocksdb.block.checksum.mismatch.count COUNT : 0 | |
| rocksdb.multiget.coroutine.count COUNT : 0 | |
| rocksdb.read.async.micros COUNT : 0 | |
| rocksdb.async.read.error.count COUNT : 0 | |
| rocksdb.table.open.prefetch.tail.miss COUNT : 0 | |
| rocksdb.table.open.prefetch.tail.hit COUNT : 14815760 | |
| rocksdb.timestamp.filter.table.checked COUNT : 0 | |
| rocksdb.timestamp.filter.table.filtered COUNT : 0 | |
| rocksdb.readahead.trimmed COUNT : 0 | |
| rocksdb.fifo.max.size.compactions COUNT : 0 | |
| rocksdb.fifo.ttl.compactions COUNT : 0 | |
| rocksdb.prefetch.bytes COUNT : 0 | |
| rocksdb.prefetch.bytes.useful COUNT : 7957869547 | |
| rocksdb.prefetch.hits COUNT : 14815760 | |
| rocksdb.footer.corruption.count COUNT : 0 | |
| rocksdb.db.get.micros P50 : 11976.660495 P95 : 19375.568359 P99 : 21497.178394 P100 : 127428.000000 COUNT : 1000001 SUM : 11880114981 | |
| rocksdb.db.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.compaction.times.micros P50 : 41500.000000 P95 : 46141.000000 P99 : 46141.000000 P100 : 46141.000000 COUNT : 6 SUM : 243536 | |
| rocksdb.compaction.times.cpu_micros P50 : 2400.000000 P95 : 3330.000000 P99 : 3330.000000 P100 : 3330.000000 COUNT : 6 SUM : 14126 | |
| rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.table.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.compaction.outfile.sync.micros P50 : 2775.000000 P95 : 8497.500000 P99 : 8712.000000 P100 : 8712.000000 COUNT : 17 SUM : 58849 | |
| rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.manifest.file.sync.micros P50 : 4664.000000 P95 : 4664.000000 P99 : 4664.000000 P100 : 4664.000000 COUNT : 7 SUM : 28563 | |
| rocksdb.table.open.io.micros P50 : 268.483874 P95 : 376.711765 P99 : 565.135873 P100 : 26217.000000 COUNT : 2963152 SUM : 798191764 | |
| rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.read.block.compaction.micros P50 : 0.579812 P95 : 819.250000 P99 : 1829.500000 P100 : 2490.000000 COUNT : 247 SUM : 18821 | |
| rocksdb.read.block.get.micros P50 : 1.099166 P95 : 239.084831 P99 : 368.431533 P100 : 36512.000000 COUNT : 7166465 SUM : 294845362 | |
| rocksdb.write.raw.block.micros P50 : 0.583636 P95 : 35.345833 P99 : 62.187500 P100 : 451.000000 COUNT : 321 SUM : 1490 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.000000 P95 : 3.650000 P99 : 3.930000 P100 : 4.000000 COUNT : 7 SUM : 18 | |
| rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.write.stall P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.sst.read.micros P50 : 213.169217 P95 : 357.875513 P99 : 520.519640 P100 : 36497.000000 COUNT : 4203429 SUM : 933367649 | |
| rocksdb.file.read.flush.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.compaction.micros P50 : 227.500000 P95 : 2150.000000 P99 : 2883.333333 P100 : 3042.000000 COUNT : 110 SUM : 55932 | |
| rocksdb.file.read.db.open.micros P50 : 178.000000 P95 : 295.000000 P99 : 295.000000 P100 : 295.000000 COUNT : 46 SUM : 8373 | |
| rocksdb.file.read.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.db.iterator.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.verify.db.checksum.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.read.verify.file.checksums.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.sst.write.micros P50 : 0.520537 P95 : 0.989021 P99 : 48.747500 P100 : 449.000000 COUNT : 659 SUM : 1392 | |
| rocksdb.file.write.flush.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.file.write.compaction.micros P50 : 0.520537 P95 : 0.989021 P99 : 48.747500 P100 : 449.000000 COUNT : 659 SUM : 1392 | |
| rocksdb.file.write.db.open.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.bytes.per.read P50 : 63.499988 P95 : 64.000000 P99 : 64.000000 P100 : 64.000000 COUNT : 1000001 SUM : 64000000 | |
| rocksdb.bytes.per.write P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.flush.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.prefetched.bytes.discarded P50 : 2386.436989 P95 : 3205.508944 P99 : 4066.000000 P100 : 4066.000000 COUNT : 2963166 SUM : 6944550174 | |
| rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.table.open.prefetch.tail.read.bytes P50 : 3528.342343 P95 : 4365.957754 P99 : 4608.000000 P100 : 4608.000000 COUNT : 2963152 SUM : 9545441792 | |
| rocksdb.db.get.core.joules P50 : 69540.128633 P95 : 106539.391625 P99 : 130263.706594 P100 : 780028.000000 COUNT : 1000001 SUM : 71973647836 | |
| rocksdb.db.get.filter.core.joules P50 : 8507.539687 P95 : 13430.365870 P99 : 14220.613710 P100 : 77514.000000 COUNT : 4505096 SUM : 38793291494 | |
| rocksdb.db.get.index.core.joules P50 : 17751.735310 P95 : 21743.198764 P99 : 28726.559404 P100 : 317321.000000 COUNT : 1240161 SUM : 21404286692 | |
| rocksdb.db.get.disk.core.joules P50 : 10536.382153 P95 : 13961.948920 P99 : 20443.013897 P100 : 303344.000000 COUNT : 1240161 SUM : 12995685952 | |
| rocksdb.db.get.memory.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.put.core.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| rocksdb.db.put.memory.joules P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 | |
| DB_GET_CORE_JOULES | |
| Count: 1000001 Average: 71973.5759 StdDev: 15910.03 | |
| Min: 21973 Median: 69540.1286 Max: 780028 | |
| Percentiles: P50: 69540.13 P75: 87137.02 P99: 130263.71 P99.9: 200996.92 P99.99: 317660.74 | |
| ------------------------------------------------------ | |
| ( 14000, 22000 ] 1 0.000% 0.000% | |
| ( 22000, 33000 ] 1654 0.165% 0.165% | |
| ( 33000, 50000 ] 51376 5.138% 5.303% # | |
| ( 50000, 75000 ] 571861 57.186% 62.489% ########### | |
| ( 75000, 110000 ] 360781 36.078% 98.567% ####### | |
| ( 110000, 170000 ] 12815 1.281% 99.849% | |
| ( 170000, 250000 ] 1324 0.132% 99.981% | |
| ( 250000, 380000 ] 171 0.017% 99.998% | |
| ( 380000, 570000 ] 14 0.001% 100.000% | |
| ( 570000, 860000 ] 4 0.000% 100.000% | |
| DB_GET_FILTER_CORE_JOULES | |
| Count: 4505096 Average: 8610.9800 StdDev: 2381.70 | |
| Min: 0 Median: 8507.5397 Max: 77514 | |
| Percentiles: P50: 8507.54 P75: 10563.00 P99: 14220.61 P99.9: 21637.43 P99.99: 44164.36 | |
| ------------------------------------------------------ | |
| [ 0, 1 ] 2 0.000% 0.000% | |
| ( 580, 870 ] 5 0.000% 0.000% | |
| ( 870, 1300 ] 39 0.001% 0.001% | |
| ( 1300, 1900 ] 220 0.005% 0.006% | |
| ( 1900, 2900 ] 2501 0.056% 0.061% | |
| ( 2900, 4400 ] 77906 1.729% 1.791% | |
| ( 4400, 6600 ] 914389 20.297% 22.087% #### | |
| ( 6600, 9900 ] 2175422 48.288% 70.376% ########## | |
| ( 9900, 14000 ] 1288355 28.598% 98.973% ###### | |
| ( 14000, 22000 ] 43734 0.971% 99.944% | |
| ( 22000, 33000 ] 1268 0.028% 99.972% | |
| ( 33000, 50000 ] 1225 0.027% 99.999% | |
| ( 50000, 75000 ] 29 0.001% 100.000% | |
| ( 75000, 110000 ] 1 0.000% 100.000% | |
| DB_GET_INDEX_CORE_JOULES | |
| Count: 1240161 Average: 17259.2806 StdDev: 2814.49 | |
| Min: 7080 Median: 17751.7353 Max: 317321 | |
| Percentiles: P50: 17751.74 P75: 19969.22 P99: 28726.56 P99.9: 49733.28 P99.99: 73556.08 | |
| ------------------------------------------------------ | |
| ( 6600, 9900 ] 440 0.035% 0.035% | |
| ( 9900, 14000 ] 95086 7.667% 7.703% ## | |
| ( 14000, 22000 ] 1118532 90.192% 97.895% ################## | |
| ( 22000, 33000 ] 22406 1.807% 99.702% | |
| ( 33000, 50000 ] 2496 0.201% 99.903% | |
| ( 50000, 75000 ] 1143 0.092% 99.995% | |
| ( 75000, 110000 ] 48 0.004% 99.999% | |
| ( 110000, 170000 ] 6 0.000% 100.000% | |
| ( 170000, 250000 ] 2 0.000% 100.000% | |
| ( 250000, 380000 ] 2 0.000% 100.000% | |
| DB_GET_DISK_CORE_JOULES | |
| Count: 1240161 Average: 10479.0313 StdDev: 2297.27 | |
| Min: 2563 Median: 10536.3822 Max: 303344 | |
| Percentiles: P50: 10536.38 P75: 12439.47 P99: 20443.01 P99.9: 29920.93 P99.99: 48747.27 | |
| ------------------------------------------------------ | |
| ( 1900, 2900 ] 2 0.000% 0.000% | |
| ( 2900, 4400 ] 417 0.034% 0.034% | |
| ( 4400, 6600 ] 27211 2.194% 2.228% | |
| ( 6600, 9900 ] 488775 39.412% 41.640% ######## | |
| ( 9900, 14000 ] 667947 53.860% 95.500% ########### | |
| ( 14000, 22000 ] 53897 4.346% 99.846% # | |
| ( 22000, 33000 ] 933 0.075% 99.921% | |
| ( 33000, 50000 ] 923 0.074% 99.995% | |
| ( 50000, 75000 ] 43 0.003% 99.999% | |
| ( 75000, 110000 ] 8 0.001% 100.000% | |
| ( 110000, 170000 ] 2 0.000% 100.000% | |
| ( 170000, 250000 ] 1 0.000% 100.000% | |
| ( 250000, 380000 ] 2 0.000% 100.000% | |
| Query time: 11884.8 seconds |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment