Created
February 9, 2025 01:48
-
-
Save achanda/074829d8642057c4be92d0a9bd14a92e 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=10 --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 10 1000000 | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 50343160, 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 = 1430925177, write_delay_time = 189186718347, write_scheduling_flushes_compactions_time = 1093964673, write_pre_and_post_process_time = 442266538, 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 = 63254107, 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 : 46075 | |
| rocksdb.no.file.errors COUNT : 0 | |
| rocksdb.stall.micros COUNT : 189183559 | |
| 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 : 1828433402 | |
| rocksdb.compact.write.bytes COUNT : 1700479488 | |
| rocksdb.flush.write.bytes COUNT : 146709610 | |
| 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 : 21123 | |
| 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 : 1754409915 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 441057 | |
| 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 : 24380824 | |
| 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 : 27281 | |
| 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 : 1858658300 | |
| rocksdb.non.last.level.read.count COUNT : 136727 | |
| 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 : 565425 | |
| 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 : 230375 | |
| 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 : 128233963 | |
| rocksdb.prefetch.hits COUNT : 230375 | |
| 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.005056 P95 : 4.018387 P99 : 6.604669 P100 : 393974.000000 COUNT : 1000001 SUM : 192219574 | |
| rocksdb.compaction.times.micros P50 : 42748.331108 P95 : 86135.313531 P99 : 106243.564356 P100 : 161908.000000 COUNT : 8704 SUM : 391291428 | |
| rocksdb.compaction.times.cpu_micros P50 : 2470.832091 P95 : 5220.781476 P99 : 6329.250362 P100 : 6776.000000 COUNT : 8704 SUM : 23001702 | |
| 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 : 2394.328922 P95 : 6456.752412 P99 : 9499.285714 P100 : 19349.000000 COUNT : 2505 SUM : 6981689 | |
| rocksdb.compaction.outfile.sync.micros P50 : 1388.841927 P95 : 6045.372940 P99 : 9552.591474 P100 : 23899.000000 COUNT : 27127 SUM : 56555729 | |
| 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 : 3874.806202 P95 : 11484.639935 P99 : 16809.536424 P100 : 45414.000000 COUNT : 10697 SUM : 48885847 | |
| rocksdb.table.open.io.micros P50 : 565.836212 P95 : 4167.480532 P99 : 6454.411765 P100 : 20369.000000 COUNT : 46075 SUM : 54909582 | |
| 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.604657 P95 : 1019.787577 P99 : 2872.447294 P100 : 21029.000000 COUNT : 406077 SUM : 49221594 | |
| rocksdb.read.block.get.micros P50 : 0.730711 P95 : 2.225017 P99 : 3.629121 P100 : 50.000000 COUNT : 92150 SUM : 117058 | |
| rocksdb.write.raw.block.micros P50 : 0.662413 P95 : 12.560128 P99 : 75.798726 P100 : 13271.000000 COUNT : 559585 SUM : 4173873 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.241473 P95 : 5.393506 P99 : 5.937919 P100 : 9.000000 COUNT : 9745 SUM : 29453 | |
| 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 : 146808.988764 P95 : 235492.537313 P99 : 264800.000000 P100 : 393912.000000 COUNT : 1252 SUM : 189183559 | |
| rocksdb.sst.read.micros P50 : 381.623443 P95 : 3584.190498 P99 : 6047.850330 P100 : 21020.000000 COUNT : 136727 SUM : 129768612 | |
| rocksdb.file.read.flush.micros P50 : 1483.809524 P95 : 5927.962264 P99 : 9277.981132 P100 : 16571.000000 COUNT : 3099 SUM : 6359025 | |
| rocksdb.file.read.compaction.micros P50 : 371.661528 P95 : 3470.424646 P99 : 5943.726880 P100 : 21020.000000 COUNT : 133628 SUM : 123409587 | |
| 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.521062 P95 : 0.990018 P99 : 41.544332 P100 : 13266.000000 COUNT : 1148802 SUM : 3959932 | |
| rocksdb.file.write.flush.micros P50 : 0.502985 P95 : 0.955672 P99 : 0.995911 P100 : 22.000000 COUNT : 92673 SUM : 36988 | |
| rocksdb.file.write.compaction.micros P50 : 0.522710 P95 : 0.993150 P99 : 44.646204 P100 : 13266.000000 COUNT : 1056129 SUM : 3922944 | |
| 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 : 23629.146919 P95 : 37962.574850 P99 : 48162.574850 P100 : 59335.000000 COUNT : 2505 SUM : 59333330 | |
| 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 : 2434.165806 P95 : 4008.207569 P99 : 4348.853030 P100 : 62304.000000 COUNT : 73358 SUM : 177733940 | |
| 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 : 3520.730166 P95 : 4375.401220 P99 : 5632.000000 P100 : 5632.000000 COUNT : 46075 SUM : 151766528 | |
| 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: 195.533 seconds | |
| LSM-tree structure: | |
| ------------------- | |
| Level 0: | |
| Total for Level 0: 0 elements, 0 bytes | |
| Level 1: | |
| Total for Level 1: 1683 elements, 243771 bytes | |
| Level 2: | |
| Total for Level 2: 6961 elements, 1005416 bytes | |
| Level 3: | |
| Total for Level 3: 29781 elements, 4295081 bytes | |
| Level 4: | |
| Total for Level 4: 116753 elements, 16784460 bytes | |
| Level 5: | |
| Total for Level 5: 466994 elements, 67067865 bytes | |
| Level 6: | |
| Total for Level 6: 377829 elements, 54333919 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 10 1000000 | |
| [WARNING] ZERO start: 5278533911 end: 5278533911 | |
| End of experiment - TEST !! | |
| RocksDB Perf Context: | |
| user_key_comparison_count = 24647816, block_cache_hit_count = 0, block_read_count = 1169526, block_read_byte = 4756342486, block_read_time = 266825535891, block_read_cpu_time = 23020456168, 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 = 2942798958, 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 = 62211951439, get_from_memtable_time = 0, get_from_memtable_count = 0, get_post_process_time = 1278357182730, get_from_output_files_time = 10297709776819, 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 = 7747596674, read_filter_block_nanos = 2609492653, new_table_block_iter_nanos = 272230007242, new_table_iterator_nanos = 0, block_seek_nanos = 5719520328, find_table_nanos = 848239771286, bloom_memtable_hit_count = 0, bloom_memtable_miss_count = 0, bloom_sst_hit_count = 1025479, bloom_sst_miss_count = 3443673, 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 = 701492920744, 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 = 839047@level1, 742718@level2, 801928@level3, 709736@level4, 350244@level5, 0@level6, bloom_filter_full_positive = 8148@level1, 11323@level2, 35008@level3, 121306@level4, 469757@level5, 379937@level6, bloom_filter_full_true_positive = 1288@level1, 6060@level2, 28981@level3, 115996@level4, 467074@level5, 379937@level6, user_key_return_count = 1288@level1, 6725@level2, 28981@level3, 115996@level4, 467074@level5, 379937@level6, get_from_table_nanos = 1155127817265@level1, 1586540293364@level2, 1424641660563@level3, 1700351030036@level4, 2702010895022@level5, 1723744800033@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 = 14134339899, bytes_written = 0, open_nanos = 10067725317, allocate_nanos = 0, write_nanos = 0, read_nanos = 930205586355, range_sync_nanos = 0, fsync_nanos = 0, prepare_write_nanos = 0, logger_nanos = 19147, cpu_write_nanos = 0, cpu_read_nanos = 67774800957, 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 : 3443673 | |
| rocksdb.bloom.filter.full.positive COUNT : 1025479 | |
| rocksdb.bloom.filter.full.true.positive COUNT : 999336 | |
| 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 : 1288 | |
| rocksdb.l2andup.hit COUNT : 998713 | |
| 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 : 2942192 | |
| 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 : 1328378 | |
| rocksdb.compact.write.bytes COUNT : 1218560 | |
| 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 : 40 | |
| 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 : 1156561 | |
| rocksdb.bytes.compression.rejected COUNT : 0 | |
| rocksdb.number.block_compression_bypassed COUNT : 293 | |
| 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 : 19428 | |
| 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 : 21 | |
| 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 : 14135741868 | |
| rocksdb.non.last.level.read.count COUNT : 4111858 | |
| 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 : 9853131 | |
| 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 : 14567660 | |
| 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 : 8555061315 | |
| rocksdb.prefetch.hits COUNT : 14567660 | |
| rocksdb.footer.corruption.count COUNT : 0 | |
| rocksdb.db.get.micros P50 : 11758.641681 P95 : 14654.463302 P99 : 20532.068180 P100 : 29888.000000 COUNT : 1000001 SUM : 11639149581 | |
| 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 : 56250.000000 P95 : 83763.000000 P99 : 83763.000000 P100 : 83763.000000 COUNT : 7 SUM : 393427 | |
| rocksdb.compaction.times.cpu_micros P50 : 2600.000000 P95 : 3979.000000 P99 : 3979.000000 P100 : 3979.000000 COUNT : 7 SUM : 18432 | |
| 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 : 3400.000000 P95 : 6600.000000 P99 : 8304.000000 P100 : 8304.000000 COUNT : 20 SUM : 68470 | |
| 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 : 7012.500000 P95 : 10958.000000 P99 : 10958.000000 P100 : 10958.000000 COUNT : 9 SUM : 59033 | |
| rocksdb.table.open.io.micros P50 : 277.800757 P95 : 379.607793 P99 : 573.573316 P100 : 9137.000000 COUNT : 2942192 SUM : 809754191 | |
| 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.614894 P95 : 979.650000 P99 : 2177.500000 P100 : 2576.000000 COUNT : 289 SUM : 27083 | |
| rocksdb.read.block.get.micros P50 : 1.097918 P95 : 238.905189 P99 : 371.932871 P100 : 9806.000000 COUNT : 6910610 SUM : 279766078 | |
| rocksdb.write.raw.block.micros P50 : 0.652098 P95 : 21.090000 P99 : 85.180000 P100 : 4889.000000 COUNT : 373 SUM : 12979 | |
| rocksdb.numfiles.in.singlecompaction P50 : 2.500000 P95 : 3.800000 P99 : 3.960000 P100 : 4.000000 COUNT : 8 SUM : 24 | |
| 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 : 215.498428 P95 : 365.771526 P99 : 529.810634 P100 : 9786.000000 COUNT : 4111858 SUM : 931136532 | |
| 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 : 226.190476 P95 : 1992.857143 P99 : 2832.857143 P100 : 3791.000000 COUNT : 147 SUM : 77864 | |
| rocksdb.file.read.db.open.micros P50 : 212.500000 P95 : 347.500000 P99 : 1660.000000 P100 : 1861.000000 COUNT : 40 SUM : 9856 | |
| 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.521798 P95 : 0.991417 P99 : 44.778000 P100 : 4884.000000 COUNT : 766 SUM : 12812 | |
| 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.521798 P95 : 0.991417 P99 : 44.778000 P100 : 4884.000000 COUNT : 766 SUM : 12812 | |
| 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 : 2354.060690 P95 : 3337.676199 P99 : 4150.000000 P100 : 4150.000000 COUNT : 2942212 SUM : 6693853325 | |
| 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 : 3592.552618 P95 : 5272.001838 P99 : 5632.000000 P100 : 5632.000000 COUNT : 2942192 SUM : 10066490368 | |
| rocksdb.db.get.core.joules P50 : 69118.166000 P95 : 105429.687194 P99 : 109352.028829 P100 : 291992.000000 COUNT : 1000001 SUM : 70683679136 | |
| rocksdb.db.get.filter.core.joules P50 : 8488.333990 P95 : 13398.446017 P99 : 13984.140907 P100 : 55908.000000 COUNT : 4469152 SUM : 38379347275 | |
| rocksdb.db.get.index.core.joules P50 : 17918.039250 P95 : 21993.994376 P99 : 31230.148744 P100 : 94543.000000 COUNT : 1168779 SUM : 20549016944 | |
| rocksdb.db.get.disk.core.joules P50 : 10786.252415 P95 : 17331.165991 P99 : 21174.143041 P100 : 55786.000000 COUNT : 1169526 SUM : 12614125795 | |
| 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: 70683.6085 StdDev: 12407.89 | |
| Min: 21362 Median: 69118.1660 Max: 291992 | |
| Percentiles: P50: 69118.17 P75: 85817.98 P99: 109352.03 P99.9: 155619.82 P99.99: 219702.09 | |
| ------------------------------------------------------ | |
| ( 14000, 22000 ] 5 0.000% 0.000% | |
| ( 22000, 33000 ] 1688 0.169% 0.169% | |
| ( 33000, 50000 ] 44300 4.430% 4.599% # | |
| ( 50000, 75000 ] 593686 59.369% 63.968% ############ | |
| ( 75000, 110000 ] 356930 35.693% 99.661% ####### | |
| ( 110000, 170000 ] 3146 0.315% 99.975% | |
| ( 170000, 250000 ] 235 0.023% 99.999% | |
| ( 250000, 380000 ] 11 0.001% 100.000% | |
| DB_GET_FILTER_CORE_JOULES | |
| Count: 4469152 Average: 8587.6129 StdDev: 2299.47 | |
| Min: 0 Median: 8488.3340 Max: 55908 | |
| Percentiles: P50: 8488.33 P75: 10469.97 P99: 13984.14 P99.9: 21471.82 P99.99: 40660.20 | |
| ------------------------------------------------------ | |
| [ 0, 1 ] 1 0.000% 0.000% | |
| ( 380, 580 ] 1 0.000% 0.000% | |
| ( 580, 870 ] 10 0.000% 0.000% | |
| ( 870, 1300 ] 57 0.001% 0.002% | |
| ( 1300, 1900 ] 160 0.004% 0.005% | |
| ( 1900, 2900 ] 1656 0.037% 0.042% | |
| ( 2900, 4400 ] 62694 1.403% 1.445% | |
| ( 4400, 6600 ] 908151 20.320% 21.765% #### | |
| ( 6600, 9900 ] 2205167 49.342% 71.107% ########## | |
| ( 9900, 14000 ] 1251404 28.001% 99.108% ###### | |
| ( 14000, 22000 ] 37883 0.848% 99.956% | |
| ( 22000, 33000 ] 1157 0.026% 99.982% | |
| ( 33000, 50000 ] 808 0.018% 100.000% | |
| ( 50000, 75000 ] 3 0.000% 100.000% | |
| DB_GET_INDEX_CORE_JOULES | |
| Count: 1168779 Average: 17581.6103 StdDev: 2830.52 | |
| Min: 7202 Median: 17918.0393 Max: 94543 | |
| Percentiles: P50: 17918.04 P75: 20182.46 P99: 31230.15 P99.9: 46143.33 P99.99: 70787.73 | |
| ------------------------------------------------------ | |
| ( 6600, 9900 ] 263 0.023% 0.023% | |
| ( 9900, 14000 ] 78553 6.721% 6.743% # | |
| ( 14000, 22000 ] 1032299 88.323% 95.066% ################## | |
| ( 22000, 33000 ] 54792 4.688% 99.754% # | |
| ( 33000, 50000 ] 2203 0.188% 99.943% | |
| ( 50000, 75000 ] 664 0.057% 100.000% | |
| ( 75000, 110000 ] 5 0.000% 100.000% | |
| DB_GET_DISK_CORE_JOULES | |
| Count: 1169526 Average: 10785.6737 StdDev: 2422.85 | |
| Min: 2747 Median: 10786.2524 Max: 55786 | |
| Percentiles: P50: 10786.25 P75: 12720.72 P99: 21174.14 P99.9: 26875.44 P99.99: 46643.02 | |
| ------------------------------------------------------ | |
| ( 1900, 2900 ] 2 0.000% 0.000% | |
| ( 2900, 4400 ] 202 0.017% 0.017% | |
| ( 4400, 6600 ] 17789 1.521% 1.538% | |
| ( 6600, 9900 ] 432819 37.008% 38.547% ####### | |
| ( 9900, 14000 ] 619687 52.986% 91.533% ########### | |
| ( 14000, 22000 ] 97385 8.327% 99.860% ## | |
| ( 22000, 33000 ] 1066 0.091% 99.951% | |
| ( 33000, 50000 ] 572 0.049% 100.000% | |
| ( 50000, 75000 ] 4 0.000% 100.000% | |
| Query time: 11643.7 seconds |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment