Created
February 10, 2025 14:14
-
-
Save achanda/aacfd32b1764f69f622135b813ba107a 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=0 --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 0 1000000 | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 50334704, 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 = 1413718703, write_delay_time = 179701229497, write_scheduling_flushes_compactions_time = 909765599, write_pre_and_post_process_time = 443657546, 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 = 35497058, 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 : 45620 | |
| rocksdb.no.file.errors COUNT : 0 | |
| rocksdb.stall.micros COUNT : 179697873 | |
| 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 : 1778735393 | |
| rocksdb.compact.write.bytes COUNT : 1680115712 | |
| rocksdb.flush.write.bytes COUNT : 145113817 | |
| 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 : 20738 | |
| 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 : 1751815292 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 440334 | |
| 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 : 23642696 | |
| 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 : 27100 | |
| 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 : 1805581170 | |
| rocksdb.non.last.level.read.count COUNT : 134933 | |
| 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 : 517306 | |
| 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 : 182480 | |
| 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 : 97694269 | |
| rocksdb.prefetch.hits COUNT : 182480 | |
| 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 : 0.997016 P95 : 3.968697 P99 : 6.224886 P100 : 393981.000000 COUNT : 1000001 SUM : 182528741 | |
| rocksdb.compaction.times.micros P50 : 41092.981305 P95 : 77912.725225 P99 : 105159.121622 P100 : 166588.000000 COUNT : 8641 SUM : 371570216 | |
| rocksdb.compaction.times.cpu_micros P50 : 2424.750981 P95 : 4910.517857 P99 : 6268.389286 P100 : 6766.000000 COUNT : 8641 SUM : 22287077 | |
| 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 : 2117.525773 P95 : 6357.922535 P99 : 9341.385542 P100 : 12880.000000 COUNT : 2505 SUM : 6345298 | |
| rocksdb.compaction.outfile.sync.micros P50 : 1314.062500 P95 : 5862.053654 P99 : 8795.184906 P100 : 36324.000000 COUNT : 26944 SUM : 53503179 | |
| 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 : 3723.264781 P95 : 10470.488048 P99 : 13927.882470 P100 : 64797.000000 COUNT : 10583 SUM : 46248456 | |
| rocksdb.table.open.io.micros P50 : 540.502382 P95 : 4027.640845 P99 : 6238.477612 P100 : 15466.000000 COUNT : 45620 SUM : 51334492 | |
| 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.598399 P95 : 1010.749685 P99 : 2797.793991 P100 : 12956.000000 COUNT : 405328 SUM : 47575593 | |
| rocksdb.read.block.get.micros P50 : 1.158425 P95 : 2.624720 P99 : 7.945098 P100 : 45.000000 COUNT : 45620 SUM : 79017 | |
| rocksdb.write.raw.block.micros P50 : 0.670036 P95 : 15.716555 P99 : 75.554654 P100 : 15077.000000 COUNT : 528681 SUM : 3446410 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.240160 P95 : 5.409784 P99 : 5.964835 P100 : 8.000000 COUNT : 9644 SUM : 29210 | |
| 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 : 141403.118040 P95 : 228551.351351 P99 : 255200.000000 P100 : 393937.000000 COUNT : 1252 SUM : 179697873 | |
| rocksdb.sst.read.micros P50 : 371.491788 P95 : 3426.891283 P99 : 5767.244864 P100 : 15409.000000 COUNT : 134933 SUM : 122757437 | |
| rocksdb.file.read.flush.micros P50 : 1435.326087 P95 : 5711.879195 P99 : 7034.500000 P100 : 9429.000000 COUNT : 3126 SUM : 6041261 | |
| rocksdb.file.read.compaction.micros P50 : 361.641115 P95 : 3298.495119 P99 : 5646.182584 P100 : 15409.000000 COUNT : 131807 SUM : 116716176 | |
| 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.522105 P95 : 0.992000 P99 : 45.810594 P100 : 15073.000000 COUNT : 1086811 SUM : 3246970 | |
| rocksdb.file.write.flush.micros P50 : 0.502476 P95 : 0.954705 P99 : 0.994903 P100 : 18.000000 COUNT : 87653 SUM : 35972 | |
| rocksdb.file.write.compaction.micros P50 : 0.523901 P95 : 0.995411 P99 : 48.017497 P100 : 15073.000000 COUNT : 999158 SUM : 3210998 | |
| 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 : 21864.465682 P95 : 32679.447853 P99 : 46879.878049 P100 : 73940.000000 COUNT : 2505 SUM : 55991208 | |
| 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 : 1205.628555 P95 : 2767.729932 P99 : 3054.112903 P100 : 53343.000000 COUNT : 72719 SUM : 104437989 | |
| 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 : 2645.334523 P95 : 4096.000000 P99 : 4096.000000 P100 : 4096.000000 COUNT : 45620 SUM : 121273856 | |
| 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 | |
| Number of NotFounds | |
| 0 | |
| Number of oks | |
| 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: 186.162 seconds | |
| LSM-tree structure: | |
| ------------------- | |
| Level 0: | |
| Total for Level 0: 0 elements, 0 bytes | |
| Level 1: | |
| Total for Level 1: 1733 elements, 248259 bytes | |
| Level 2: | |
| Total for Level 2: 6960 elements, 995054 bytes | |
| Level 3: | |
| Total for Level 3: 30132 elements, 4293225 bytes | |
| Level 4: | |
| Total for Level 4: 117755 elements, 16764862 bytes | |
| Level 5: | |
| Total for Level 5: 471645 elements, 67028268 bytes | |
| Level 6: | |
| Total for Level 6: 371776 elements, 52878522 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 0 1000000 | |
| [WARNING] Counter overflow detected. Calculated energy difference with overflow handling. | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 63234550, block_cache_hit_count = 0, block_read_count = 5086953, block_read_byte = 20825849597, block_read_time = 1176997701238, block_read_cpu_time = 92625895845, 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 = 5086602519, 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 = 63253083405, get_from_memtable_time = 0, get_from_memtable_count = 0, get_post_process_time = 1284615219924, get_from_output_files_time = 16022256920554, 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 = 8918060073, read_filter_block_nanos = 0, new_table_block_iter_nanos = 1198529538070, new_table_iterator_nanos = 0, block_seek_nanos = 14127482030, find_table_nanos = 863306182242, 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 = 1085177745580, 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 = 0@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6, bloom_filter_full_positive = 0@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6, bloom_filter_full_true_positive = 0@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6, user_key_return_count = 1@level1, 0@level2, 0@level3, 0@level4, 0@level5, 0@level6, get_from_table_nanos = 2950860319447@level1, 2637579695341@level2, 2523649939866@level3, 2870970924210@level4, 3135724170634@level5, 1897434247650@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 = 29162845875, bytes_written = 0, open_nanos = 11553485502, allocate_nanos = 0, write_nanos = 0, read_nanos = 1835511953078, range_sync_nanos = 0, fsync_nanos = 0, prepare_write_nanos = 0, logger_nanos = 25491, cpu_write_nanos = 0, cpu_read_nanos = 127546485345, 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 : 1000001 | |
| rocksdb.l0.hit COUNT : 0 | |
| rocksdb.l1.hit COUNT : 1 | |
| 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 : 0 | |
| rocksdb.number.keys.read COUNT : 1000001 | |
| rocksdb.number.keys.updated COUNT : 0 | |
| rocksdb.bytes.written COUNT : 0 | |
| 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 : 3247818 | |
| 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 : 702072 | |
| rocksdb.compact.write.bytes COUNT : 657408 | |
| 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 : 29 | |
| 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 : 630264 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 159 | |
| 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 : 9472 | |
| 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 : 11 | |
| 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 : 29163601693 | |
| rocksdb.non.last.level.read.count COUNT : 8334868 | |
| 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 : 11582775 | |
| 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 : 12991272 | |
| 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 : 7396226949 | |
| rocksdb.prefetch.hits COUNT : 12991272 | |
| rocksdb.footer.corruption.count COUNT : 0 | |
| rocksdb.db.get.micros P50 : 17462.669529 P95 : 21555.927031 P99 : 21919.772142 P100 : 67729.000000 COUNT : 1000001 SUM : 17370958083 | |
| 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 : 57718.000000 P99 : 57718.000000 P100 : 57718.000000 COUNT : 4 SUM : 179714 | |
| rocksdb.compaction.times.cpu_micros P50 : 2400.000000 P95 : 3291.000000 P99 : 3291.000000 P100 : 3291.000000 COUNT : 4 SUM : 9160 | |
| 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 : 3150.000000 P95 : 8085.000000 P99 : 8604.000000 P100 : 8604.000000 COUNT : 11 SUM : 35548 | |
| 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 : 3900.000000 P95 : 12770.000000 P99 : 13149.000000 P100 : 13149.000000 COUNT : 6 SUM : 31660 | |
| rocksdb.table.open.io.micros P50 : 244.616847 P95 : 371.482662 P99 : 503.471911 P100 : 18774.000000 COUNT : 3247818 SUM : 819973787 | |
| 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.608527 P95 : 882.900000 P99 : 1729.000000 P100 : 2095.000000 COUNT : 157 SUM : 11979 | |
| rocksdb.read.block.get.micros P50 : 183.577374 P95 : 356.233538 P99 : 510.861102 P100 : 21621.000000 COUNT : 8334771 SUM : 1201274516 | |
| rocksdb.write.raw.block.micros P50 : 0.685714 P95 : 26.200000 P99 : 48.393333 P100 : 56.000000 COUNT : 192 SUM : 656 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.250000 P95 : 3.750000 P99 : 3.950000 P100 : 4.000000 COUNT : 5 SUM : 14 | |
| 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.931455 P95 : 360.190428 P99 : 516.880355 P100 : 21610.000000 COUNT : 8334868 SUM : 1837356276 | |
| 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 : 182.727273 P95 : 1397.500000 P99 : 2030.000000 P100 : 2093.000000 COUNT : 87 SUM : 32317 | |
| rocksdb.file.read.db.open.micros P50 : 206.923077 P95 : 318.000000 P99 : 318.000000 P100 : 318.000000 COUNT : 40 SUM : 8164 | |
| 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.523873 P95 : 0.995358 P99 : 42.641667 P100 : 55.000000 COUNT : 395 SUM : 581 | |
| 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.523873 P95 : 0.995358 P99 : 42.641667 P100 : 55.000000 COUNT : 395 SUM : 581 | |
| 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 : 1000001 SUM : 0 | |
| 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 : 1085.000662 P95 : 1278.501258 P99 : 1295.701311 P100 : 2520.000000 COUNT : 3247828 SUM : 3299040417 | |
| 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 : 2982.957480 P95 : 4096.000000 P99 : 4096.000000 P100 : 4096.000000 COUNT : 3247818 SUM : 9214974464 | |
| rocksdb.db.get.core.joules P50 : 112015.957994 P95 : 164407.283939 P99 : 169064.290690 P100 : 18446744073559394304.000000 COUNT : 1000001 SUM : 109828821286 | |
| 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 : 18447.163345 P95 : 29261.072124 P99 : 32378.889570 P100 : 148254.000000 COUNT : 5086953 SUM : 96553148279 | |
| rocksdb.db.get.disk.core.joules P50 : 11862.349418 P95 : 20528.787316 P99 : 21743.116267 P100 : 108825.000000 COUNT : 5086953 SUM : 60737244799 | |
| 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 | |
| Number of NotFounds | |
| 1000000 | |
| Number of oks | |
| 1 | |
| DB_GET_CORE_JOULES | |
| Count: 1000001 Average: 109828.7115 StdDev: 151330.86 | |
| Min: 5737 Median: 112015.9580 Max: 18446744073559394629 | |
| Percentiles: P50: 112015.96 P75: 141122.25 P99: 169064.29 P99.9: 217555.51 P99.99: 342911.73 | |
| ------------------------------------------------------ | |
| ( 4400, 6600 ] 4 0.000% 0.000% | |
| ( 6600, 9900 ] 3 0.000% 0.001% | |
| ( 9900, 14000 ] 1 0.000% 0.001% | |
| ( 22000, 33000 ] 47 0.005% 0.005% | |
| ( 33000, 50000 ] 1025 0.102% 0.108% | |
| ( 50000, 75000 ] 28711 2.871% 2.979% # | |
| ( 75000, 110000 ] 452894 45.289% 48.268% ######### | |
| ( 110000, 170000 ] 515353 51.535% 99.804% ########## | |
| ( 170000, 250000 ] 1620 0.162% 99.966% | |
| ( 250000, 380000 ] 340 0.034% 100.000% | |
| ( 380000, 570000 ] 2 0.000% 100.000% | |
| ( 9200000000000000000, 13000000000000000000 ] 1 0.000% 100.000% | |
| 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: 5086953 Average: 18980.5466 StdDev: 3109.74 | |
| Min: 7507 Median: 18447.1633 Max: 148254 | |
| Percentiles: P50: 18447.16 P75: 20936.23 P99: 32378.89 P99.9: 44271.14 P99.99: 69859.77 | |
| ------------------------------------------------------ | |
| ( 6600, 9900 ] 1173 0.023% 0.023% | |
| ( 9900, 14000 ] 270116 5.310% 5.333% # | |
| ( 14000, 22000 ] 4087437 80.351% 85.684% ################ | |
| ( 22000, 33000 ] 717893 14.112% 99.797% ### | |
| ( 33000, 50000 ] 7914 0.156% 99.952% | |
| ( 50000, 75000 ] 2406 0.047% 100.000% | |
| ( 75000, 110000 ] 9 0.000% 100.000% | |
| ( 110000, 170000 ] 5 0.000% 100.000% | |
| DB_GET_DISK_CORE_JOULES | |
| Count: 5086953 Average: 11939.8085 StdDev: 2941.16 | |
| Min: 2808 Median: 11862.3494 Max: 108825 | |
| Percentiles: P50: 11862.35 P75: 14457.14 P99: 21743.12 P99.9: 27290.45 P99.99: 46072.56 | |
| ------------------------------------------------------ | |
| ( 1900, 2900 ] 1 0.000% 0.000% | |
| ( 2900, 4400 ] 366 0.007% 0.007% | |
| ( 4400, 6600 ] 70228 1.381% 1.388% | |
| ( 6600, 9900 ] 1375753 27.045% 28.433% ##### | |
| ( 9900, 14000 ] 2292266 45.062% 73.494% ######### | |
| ( 14000, 22000 ] 1340514 26.352% 99.846% ##### | |
| ( 22000, 33000 ] 5693 0.112% 99.958% | |
| ( 33000, 50000 ] 2111 0.041% 100.000% | |
| ( 50000, 75000 ] 14 0.000% 100.000% | |
| ( 75000, 110000 ] 7 0.000% 100.000% | |
| Query time: 17375.5 seconds |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment