MariaDB 10.3 MyRocks之监控信息

最新推荐文章于 2025-03-29 06:45:00 发布
最新推荐文章于 2025-03-29 06:45:00 发布
阅读量901 收藏
点赞数
分类专栏： MySQL MariaDB 文章标签： MyRocks
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/vkingnew/article/details/81546481
版权

MyRocks本身提供了不少监控信息 我们可以通过show status 查看rocksdb的信息，也可以通过information_schema下相关的表进行查看监控。也可以通过Percona公司提供的开源的监控工具PMM来可视化信息监控。

--查表表的定义：
MariaDB [sbtest]> show create table sbtest1\G
*************************** 1. row ***************************
       Table: sbtest1
Create Table: CREATE TABLE `sbtest1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `k` int(11) NOT NULL DEFAULT 0,
  `c` char(120) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `pad` char(60) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
) ENGINE=ROCKSDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
1 row in set (0.000 sec)

通过show global status like 'rocksdb%'; 查看rocksdb存储引擎状态信息：
MariaDB [sbtest]> show global status like 'rocksdb%';
+----------------------------------------------------+---------+
| Variable_name                                      | Value   |
+----------------------------------------------------+---------+
| Rocksdb_rows_deleted                               | 0       |
| Rocksdb_rows_inserted                              | 9       |
| Rocksdb_rows_read                                  | 10      |
| Rocksdb_rows_updated                               | 1       |
| Rocksdb_rows_deleted_blind                         | 0       |
| Rocksdb_rows_expired                               | 0       |
| Rocksdb_rows_filtered                              | 26      |
| Rocksdb_system_rows_deleted                        | 0       |
| Rocksdb_system_rows_inserted                       | 0       |
| Rocksdb_system_rows_read                           | 0       |
| Rocksdb_system_rows_updated                        | 0       |
| Rocksdb_memtable_total                             | 5680    |
| Rocksdb_memtable_unflushed                         | 3768    |
| Rocksdb_queries_point                              | 0       |
| Rocksdb_queries_range                              | 17      |
| Rocksdb_covered_secondary_key_lookups              | 0       |
| Rocksdb_block_cache_add                            | 22      |
| Rocksdb_block_cache_add_failures                   | 0       |
| Rocksdb_block_cache_bytes_read                     | 2313400 |
| Rocksdb_block_cache_bytes_write                    | 950688  |
| Rocksdb_block_cache_data_add                       | 12      |
| Rocksdb_block_cache_data_bytes_insert              | 98720   |
| Rocksdb_block_cache_data_hit                       | 42      |
| Rocksdb_block_cache_data_miss                      | 14      |
| Rocksdb_block_cache_filter_add                     | 0       |
| Rocksdb_block_cache_filter_bytes_evict             | 0       |
| Rocksdb_block_cache_filter_bytes_insert            | 0       |
| Rocksdb_block_cache_filter_hit                     | 0       |
| Rocksdb_block_cache_filter_miss                    | 0       |
| Rocksdb_block_cache_hit                            | 87      |
| Rocksdb_block_cache_index_add                      | 10      |
| Rocksdb_block_cache_index_bytes_evict              | 80      |
| Rocksdb_block_cache_index_bytes_insert             | 851968  |
| Rocksdb_block_cache_index_hit                      | 45      |
| Rocksdb_block_cache_index_miss                     | 10      |
| Rocksdb_block_cache_miss                           | 24      |
| Rocksdb_block_cachecompressed_hit                  | 0       |
| Rocksdb_block_cachecompressed_miss                 | 0       |
| Rocksdb_bloom_filter_prefix_checked                | 0       |
| Rocksdb_bloom_filter_prefix_useful                 | 0       |
| Rocksdb_bloom_filter_useful                        | 0       |
| Rocksdb_bytes_read                                 | 467     |
| Rocksdb_bytes_written                              | 1603    |
| Rocksdb_compact_read_bytes                         | 178     |
| Rocksdb_compact_write_bytes                        | 1102    |
| Rocksdb_compaction_key_drop_new                    | 0       |
| Rocksdb_compaction_key_drop_obsolete               | 5       |
| Rocksdb_compaction_key_drop_user                   | 5       |
| Rocksdb_flush_write_bytes                          | 2404    |
| Rocksdb_get_hit_l0                                 | 2       |
| Rocksdb_get_hit_l1                                 | 6       |
| Rocksdb_get_hit_l2_and_up                          | 0       |
| Rocksdb_getupdatessince_calls                      | 0       |
| Rocksdb_iter_bytes_read                            | 3160    |
| Rocksdb_memtable_hit                               | 22      |
| Rocksdb_memtable_miss                              | 22      |
| Rocksdb_no_file_closes                             | 0       |
| Rocksdb_no_file_errors                             | 0       |
| Rocksdb_no_file_opens                              | 96      |
| Rocksdb_num_iterators                              | 0       |
| Rocksdb_number_block_not_compressed                | 0       |
| Rocksdb_number_db_next                             | 40      |
| Rocksdb_number_db_next_found                       | 26      |
| Rocksdb_number_db_prev                             | 0       |
| Rocksdb_number_db_prev_found                       | 0       |
| Rocksdb_number_db_seek                             | 36      |
| Rocksdb_number_db_seek_found                       | 30      |
| Rocksdb_number_deletes_filtered                    | 0       |
| Rocksdb_number_keys_read                           | 44      |
| Rocksdb_number_keys_updated                        | 0       |
| Rocksdb_number_keys_written                        | 51      |
| Rocksdb_number_merge_failures                      | 0       |
| Rocksdb_number_multiget_bytes_read                 | 0       |
| Rocksdb_number_multiget_get                        | 0       |
| Rocksdb_number_multiget_keys_read                  | 0       |
| Rocksdb_number_reseeks_iteration                   | 0       |
| Rocksdb_number_sst_entry_delete                    | 0       |
| Rocksdb_number_sst_entry_merge                     | 0       |
| Rocksdb_number_sst_entry_other                     | 0       |
| Rocksdb_number_sst_entry_put                       | 14      |
| Rocksdb_number_sst_entry_singledelete              | 0       |
| Rocksdb_number_superversion_acquires               | 14      |
| Rocksdb_number_superversion_cleanups               | 0       |
| Rocksdb_number_superversion_releases               | 0       |
| Rocksdb_row_lock_deadlocks                         | 0       |
| Rocksdb_row_lock_wait_timeouts                     | 0       |
| Rocksdb_snapshot_conflict_errors                   | 0       |
| Rocksdb_stall_l0_file_count_limit_slowdowns        | 0       |
| Rocksdb_stall_locked_l0_file_count_limit_slowdowns | 0       |
| Rocksdb_stall_l0_file_count_limit_stops            | 0       |
| Rocksdb_stall_locked_l0_file_count_limit_stops     | 0       |
| Rocksdb_stall_pending_compaction_limit_stops       | 0       |
| Rocksdb_stall_pending_compaction_limit_slowdowns   | 0       |
| Rocksdb_stall_memtable_limit_stops                 | 0       |
| Rocksdb_stall_memtable_limit_slowdowns             | 0       |
| Rocksdb_stall_total_stops                          | 0       |
| Rocksdb_stall_total_slowdowns                      | 0       |
| Rocksdb_stall_micros                               | 0       |
| Rocksdb_wal_bytes                                  | 1603    |
| Rocksdb_wal_group_syncs                            | 0       |
| Rocksdb_wal_synced                                 | 38      |
| Rocksdb_write_other                                | 0       |
| Rocksdb_write_self                                 | 26      |
| Rocksdb_write_timedout                             | 0       |
| Rocksdb_write_wal                                  | 52      |
+----------------------------------------------------+---------+
105 rows in set (0.001 sec)

查询information_schema 下rocksdb相关的表：
select table_name from INFORMATION_SCHEMA.tables where table_name like 'rocks%';
或者：
MariaDB [information_schema]> show tables like 'rocksdb%';
+-----------------------------------------+
| Tables_in_information_schema (rocksdb%) |
+-----------------------------------------+
| ROCKSDB_GLOBAL_INFO                     |
| ROCKSDB_CFSTATS                         |
| ROCKSDB_TRX                             |
| ROCKSDB_CF_OPTIONS                      |
| ROCKSDB_COMPACTION_STATS                |
| ROCKSDB_DBSTATS                         |
| ROCKSDB_DEADLOCK                        |
| ROCKSDB_PERF_CONTEXT                    |
| ROCKSDB_INDEX_FILE_MAP                  |
| ROCKSDB_LOCKS                           |
| ROCKSDB_PERF_CONTEXT_GLOBAL             |
| ROCKSDB_DDL                             |
+-----------------------------------------+
12 rows in set (0.000 sec)
上述12个表可以分为：
数据字典相关的表：
ROCKSDB_INDEX_FILE_MAP
ROCKSDB_DDL
事务相关的表：
ROCKSDB_TRX
ROCKSDB_LOCKS
ROCKSDB_DEADLOCK
性能相关：
ROCKSDB_PERF_CONTEXT_GLOBAL
ROCKSDB_PERF_CONTEXT
统计信息相关：
ROCKSDB_GLOBAL_INFO
ROCKSDB_CFSTATS
ROCKSDB_COMPACTION_STATS
ROCKSDB_DBSTATS 
column family相关：
ROCKSDB_CF_OPTIONS

--查看存储引擎的状态：
show engine rocksdb status.结果主要分为三部分
1）DB Stats
2）Compaction Stats
3）Memory_Stats
MariaDB [information_schema]> show engine rocksdb status\G
*************************** 1. row ***************************
  Type: STATISTICS
  Name: rocksdb
Status: rocksdb.block.cache.miss COUNT : 24
rocksdb.block.cache.hit COUNT : 97
rocksdb.block.cache.add COUNT : 22
rocksdb.block.cache.add.failures COUNT : 0
rocksdb.block.cache.index.miss COUNT : 10
rocksdb.block.cache.index.hit COUNT : 50
rocksdb.block.cache.index.add COUNT : 10
rocksdb.block.cache.index.bytes.insert COUNT : 851968
rocksdb.block.cache.index.bytes.evict COUNT : 80
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.filter.bytes.evict COUNT : 0
rocksdb.block.cache.data.miss COUNT : 14
rocksdb.block.cache.data.hit COUNT : 47
rocksdb.block.cache.data.add COUNT : 12
rocksdb.block.cache.data.bytes.insert COUNT : 98720
rocksdb.block.cache.bytes.read COUNT : 2315512
rocksdb.block.cache.bytes.write COUNT : 950688
rocksdb.bloom.filter.useful 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 : 25
rocksdb.memtable.miss COUNT : 26
rocksdb.l0.hit COUNT : 2
rocksdb.l1.hit COUNT : 6
rocksdb.l2andup.hit COUNT : 0
rocksdb.compaction.key.drop.new COUNT : 0
rocksdb.compaction.key.drop.obsolete COUNT : 5
rocksdb.compaction.key.drop.range_del COUNT : 0
rocksdb.compaction.key.drop.user COUNT : 5
rocksdb.compaction.range_del.drop.obsolete COUNT : 0
rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0
rocksdb.number.keys.written COUNT : 51
rocksdb.number.keys.read COUNT : 51
rocksdb.number.keys.updated COUNT : 0
rocksdb.bytes.written COUNT : 1603
rocksdb.bytes.read COUNT : 515
rocksdb.number.db.seek COUNT : 37
rocksdb.number.db.next COUNT : 40
rocksdb.number.db.prev COUNT : 0
rocksdb.number.db.seek.found COUNT : 31
rocksdb.number.db.next.found COUNT : 26
rocksdb.number.db.prev.found COUNT : 0
rocksdb.db.iter.bytes.read COUNT : 3254
rocksdb.no.file.closes COUNT : 0
rocksdb.no.file.opens COUNT : 96
rocksdb.no.file.errors COUNT : 0
rocksdb.l0.slowdown.micros COUNT : 0
rocksdb.memtable.compaction.micros COUNT : 0
rocksdb.l0.num.files.stall.micros COUNT : 0
rocksdb.stall.micros COUNT : 0
rocksdb.db.mutex.wait.micros COUNT : 0
rocksdb.rate.limit.delay.millis COUNT : 0
rocksdb.num.iterators COUNT : 0
rocksdb.number.multiget.get COUNT : 0
rocksdb.number.multiget.keys.read COUNT : 0
rocksdb.number.multiget.bytes.read COUNT : 0
rocksdb.number.deletes.filtered COUNT : 0
rocksdb.number.merge.failures COUNT : 0
rocksdb.bloom.filter.prefix.checked COUNT : 0
rocksdb.bloom.filter.prefix.useful COUNT : 0
rocksdb.number.reseeks.iteration COUNT : 0
rocksdb.getupdatessince.calls COUNT : 0
rocksdb.block.cachecompressed.miss COUNT : 0
rocksdb.block.cachecompressed.hit COUNT : 0
rocksdb.block.cachecompressed.add COUNT : 0
rocksdb.block.cachecompressed.add.failures COUNT : 0
rocksdb.wal.synced COUNT : 38
rocksdb.wal.bytes COUNT : 1603
rocksdb.write.self COUNT : 26
rocksdb.write.other COUNT : 0
rocksdb.write.timeout COUNT : 0
rocksdb.write.wal COUNT : 52
rocksdb.compact.read.bytes COUNT : 178
rocksdb.compact.write.bytes COUNT : 1102
rocksdb.flush.write.bytes COUNT : 2404
rocksdb.number.direct.load.table.properties COUNT : 0
rocksdb.number.superversion_acquires COUNT : 14
rocksdb.number.superversion_releases COUNT : 0
rocksdb.number.superversion_cleanups COUNT : 0
rocksdb.number.block.compressed COUNT : 3
rocksdb.number.block.decompressed COUNT : 19
rocksdb.number.block.not_compressed COUNT : 0
rocksdb.merge.operation.time.nanos COUNT : 12774
rocksdb.filter.operation.time.nanos COUNT : 68537
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.number.iter.skip COUNT : 25
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 : 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.overwritten COUNT : 0
rocksdb.blobdb.gc.num.keys.expired COUNT : 0
rocksdb.blobdb.gc.num.keys.relocated COUNT : 0
rocksdb.blobdb.gc.bytes.overwritten COUNT : 0
rocksdb.blobdb.gc.bytes.expired 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.db.get.micros statistics Percentiles :=> 50 : 7.200000 95 : 62.250000 99 : 139.400000 100 : 146.000000
rocksdb.db.write.micros statistics Percentiles :=> 50 : 250.000000 95 : 19600.000000 99 : 27728.000000 100 : 27728.000000
rocksdb.compaction.times.micros statistics Percentiles :=> 50 : 170.000000 95 : 1764.000000 99 : 1764.000000 100 : 1764.000000
rocksdb.subcompaction.setup.times.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.table.sync.micros statistics Percentiles :=> 50 : 1085.000000 95 : 30149.000000 99 : 30149.000000 100 : 30149.000000
rocksdb.compaction.outfile.sync.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.wal.file.sync.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.manifest.file.sync.micros statistics Percentiles :=> 50 : 2900.000000 95 : 27727.000000 99 : 27727.000000 100 : 27727.000000
rocksdb.table.open.io.micros statistics Percentiles :=> 50 : 45952.380952 95 : 205200.000000 99 : 720800.000000 100 : 770252.000000
rocksdb.db.multiget.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.block.compaction.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.block.get.micros statistics Percentiles :=> 50 : 430.000000 95 : 2258.000000 99 : 2258.000000 100 : 2258.000000
rocksdb.write.raw.block.micros statistics Percentiles :=> 50 : 1.000000 95 : 3.400000 99 : 3.880000 100 : 4.000000
rocksdb.l0.slowdown.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.memtable.compaction.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.num.files.stall.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.hard.rate.limit.delay.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.soft.rate.limit.delay.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.numfiles.in.singlecompaction statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.db.seek.micros statistics Percentiles :=> 50 : 9.500000 95 : 3125.000000 99 : 11158.000000 100 : 11158.000000
rocksdb.db.write.stall statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.sst.read.micros statistics Percentiles :=> 50 : 22.705882 95 : 22440.000000 99 : 45240.000000 100 : 362136.000000
rocksdb.num.subcompactions.scheduled statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.bytes.per.read statistics Percentiles :=> 50 : 4.833333 95 : 46.325000 99 : 90.000000 100 : 90.000000
rocksdb.bytes.per.write statistics Percentiles :=> 50 : 60.090909 95 : 88.000000 99 : 88.000000 100 : 88.000000
rocksdb.bytes.per.multiget statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.bytes.compressed statistics Percentiles :=> 50 : 93.000000 95 : 146.000000 99 : 146.000000 100 : 146.000000
rocksdb.bytes.decompressed statistics Percentiles :=> 50 : 14800.000000 95 : 318250.000000 99 : 322512.000000 100 : 322512.000000
rocksdb.compression.times.nanos statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.decompression.times.nanos statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.num.merge_operands statistics Percentiles :=> 50 : 1.000000 95 : 3.500000 99 : 3.900000 100 : 4.000000
rocksdb.blobdb.key.size statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.value.size statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.write.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.get.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.multiget.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.seek.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.next.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.prev.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.write.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.read.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.sync.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.gc.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.compression.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.decompression.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.db.flush.micros statistics Percentiles :=> 50 : 1900.000000 95 : 4439.000000 99 : 4439.000000 100 : 4439.000000
rocksdb.commit_latency statistics Percentiles :=> 50 : 51.00 95 : 1063.50 99 : 1112.00 100 : 1112.0rocksdb.is_write_stopped COUNT : 0
rocksdb.actual_delayed_write_rate COUNT : 0

*************************** 2. row ***************************
  Type: DBSTATS
  Name: rocksdb
Status: 
** DB Stats **
Uptime(secs): 51549.0 total, 3480.9 interval
Cumulative writes: 26 writes, 51 keys, 26 commit groups, 1.0 writes per commit group, ingest: 0.00 GB, 0.00 MB/s
Cumulative WAL: 26 writes, 0 syncs, 26.00 writes per sync, written: 0.00 GB, 0.00 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 0 writes, 0 keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.00 MB, 0.00 MB/s
Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 MB, 0.00 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent

*************************** 3. row ***************************
  Type: CF_COMPACTION
  Name: __system__
Status: 
** Compaction Stats [__system__] **
Level    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
  L0      2/0    2.25 KB   0.5      0.0     0.0      0.0       0.0      0.0       0.0   1.0      0.0      0.0         0         1    0.031       0      0
  L1      1/0    1.63 KB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   0.0      0.0      0.0         0         0    0.000       0      0
 Sum      3/0    3.88 KB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   1.0      0.0      0.0         0         1    0.031       0      0
 Int      0/0    0.00 KB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   0.0      0.0      0.0         0         0    0.000       0      0
Uptime(secs): 51549.0 total, 3480.9 interval
Flush(GB): cumulative 0.000, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count

** File Read Latency Histogram By Level [__system__] **
** Level 0 read latency histogram (micros):
Count: 10 Average: 1124.1000  StdDev: 3364.97
Min: 1  Median: 1.0000  Max: 11219
Percentiles: P50: 1.00 P75: 5.00 P99: 11219.00 P99.9: 11219.00 P99.99: 11219.00
------------------------------------------------------
[       0,       1 ]        5  50.000%  50.000% ##########
(       1,       2 ]        1  10.000%  60.000% ##
(       2,       3 ]        1  10.000%  70.000% ##
(       4,       6 ]        1  10.000%  80.000% ##
(       6,      10 ]        1  10.000%  90.000% ##
(    9900,   14000 ]        1  10.000% 100.000% ##

** Level 1 read latency histogram (micros):
Count: 5 Average: 2266.6000  StdDev: 4529.70
Min: 1  Median: 1.5000  Max: 11326
Percentiles: P50: 1.50 P75: 2.75 P99: 11326.00 P99.9: 11326.00 P99.99: 11326.00
------------------------------------------------------
[       0,       1 ]        2  40.000%  40.000% ########
(       1,       2 ]        1  20.000%  60.000% ####
(       2,       3 ]        1  20.000%  80.000% ####
(    9900,   14000 ]        1  20.000% 100.000% ####


*************************** 4. row ***************************
  Type: CF_COMPACTION
  Name: default
Status: 
** Compaction Stats [default] **
Level    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
  L0      2/0   18.35 MB   0.5      0.0     0.0      0.0       0.0      0.0       0.0   1.0      0.0      0.4         0         2    0.003       0      0
  L1      4/0   243.40 MB   1.0      0.0     0.0      0.0       0.0      0.0       0.0   0.0      1.1      0.0         0         2    0.001       5      5
  L2     84/0    1.77 GB   0.7      0.0     0.0      0.0       0.0      0.0       0.0   0.0      0.0      0.0         0         0    0.000       0      0
  L6      1/0   71.00 MB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   0.0      0.0      0.0         0         0    0.000       0      0
 Sum     91/0    2.09 GB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   1.0      0.3      0.3         0         4    0.002       5      5
 Int      0/0    0.00 KB   0.0      0.0     0.0      0.0       0.0      0.0       0.0   0.0      0.0      0.0         0         0    0.000       0      0
Uptime(secs): 51549.0 total, 3480.9 interval
Flush(GB): cumulative 0.000, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count

** File Read Latency Histogram By Level [default] **
** Level 0 read latency histogram (micros):
Count: 22 Average: 20036.5000  StdDev: 75367.84
Min: 1  Median: 10.0000  Max: 362136
Percentiles: P50: 10.00 P75: 725.00 P99: 351400.00 P99.9: 362136.00 P99.99: 362136.00
------------------------------------------------------
[       0,       1 ]        4  18.182%  18.182% ####
(       1,       2 ]        2   9.091%  27.273% ##
(       2,       3 ]        2   9.091%  36.364% ##
(       3,       4 ]        1   4.545%  40.909% #
(       4,       6 ]        1   4.545%  45.455% #
(       6,      10 ]        1   4.545%  50.000% #
(      10,      15 ]        2   9.091%  59.091% ##
(      15,      22 ]        2   9.091%  68.182% ##
(     380,     580 ]        1   4.545%  72.727% #
(     580,     870 ]        1   4.545%  77.273% #
(    1900,    2900 ]        1   4.545%  81.818% #
(    6600,    9900 ]        1   4.545%  86.364% #
(   14000,   22000 ]        1   4.545%  90.909% #
(   33000,   50000 ]        1   4.545%  95.455% #
(  250000,  380000 ]        1   4.545% 100.000% #

** Level 1 read latency histogram (micros):
Count: 15 Average: 2273.3333  StdDev: 4443.42
Min: 1  Median: 26.5000  Max: 14916
Percentiles: P50: 26.50 P75: 3087.50 P99: 14916.00 P99.9: 14916.00 P99.99: 14916.00
------------------------------------------------------
[       0,       1 ]        1   6.667%   6.667% #
(       1,       2 ]        1   6.667%  13.333% #
(       6,      10 ]        1   6.667%  20.000% #
(      15,      22 ]        3  20.000%  40.000% ####
(      22,      34 ]        4  26.667%  66.667% #####
(     580,     870 ]        1   6.667%  73.333% #
(    2900,    4400 ]        2  13.333%  86.667% ###
(    9900,   14000 ]        1   6.667%  93.333% #
(   14000,   22000 ]        1   6.667% 100.000% #

** Level 2 read latency histogram (micros):
Count: 254 Average: 5518.3661  StdDev: 9102.69
Min: 1  Median: 25.6000  Max: 57382
Percentiles: P50: 25.60 P75: 10818.97 P99: 41273.33 P99.9: 57382.00 P99.99: 57382.00
------------------------------------------------------
[       0,       1 ]        8   3.150%   3.150% #
(       1,       2 ]       35  13.780%  16.929% ###
(       2,       3 ]       13   5.118%  22.047% #
(       3,       4 ]        8   3.150%  25.197% #
(       4,       6 ]        7   2.756%  27.953% #
(       6,      10 ]        1   0.394%  28.346% 
(      10,      15 ]        1   0.394%  28.740% 
(      15,      22 ]       45  17.717%  46.457% ####
(      22,      34 ]       30  11.811%  58.268% ##
(      34,      51 ]        3   1.181%  59.449% 
(     170,     250 ]        1   0.394%  59.843% 
(     250,     380 ]        3   1.181%  61.024% 
(     380,     580 ]        5   1.969%  62.992% 
(     580,     870 ]        1   0.394%  63.386% 
(     870,    1300 ]        1   0.394%  63.780% 
(    1900,    2900 ]        4   1.575%  65.354% 
(    2900,    4400 ]        2   0.787%  66.142% 
(    4400,    6600 ]        2   0.787%  66.929% 
(    6600,    9900 ]       14   5.512%  72.441% #
(    9900,   14000 ]       29  11.417%  83.858% ##
(   14000,   22000 ]       27  10.630%  94.488% ##
(   22000,   33000 ]       10   3.937%  98.425% #
(   33000,   50000 ]        3   1.181%  99.606% 
(   50000,   75000 ]        1   0.394% 100.000% 

** Level 6 read latency histogram (micros):
Count: 6 Average: 2695.1667  StdDev: 4726.64
Min: 19  Median: 480.0000  Max: 13143
Percentiles: P50: 480.00 P75: 2400.00 P99: 13143.00 P99.9: 13143.00 P99.99: 13143.00
------------------------------------------------------
(      15,      22 ]        2  33.333%  33.333% #######
(     380,     580 ]        2  33.333%  66.667% #######
(    1900,    2900 ]        1  16.667%  83.333% ###
(    9900,   14000 ]        1  16.667% 100.000% ###


*************************** 5. row ***************************
  Type: MEMORY_STATS
  Name: rocksdb
Status: 
MemTable Total: 5680
MemTable Unflushed: 3768
Table Readers Total: 0
Cache Total: 950608
Default Cache Capacity: 0
5 rows in set (0.001 sec)


官方提供的查看事务的语句不被支持：
SHOW ENGING ROKSDB TRANCTION STATUS\G

通过PMM官方提供的图形界面监控我们可以知道需要重点关注的指标：
https://pmmdemo.percona.com/graph
选择MySQL --> MySQL RocksDB Metrics
我们可以利用percona提供的镜像和Docker很容易搭建起监控。

 

MyRocks引擎与MariaDB
唐国强的博客
01-30 197
【代码】MyRocks引擎与MariaDB。
mariadb10.3.38.tgz
10-08
mariadb10.3.38.tgz 是一个压缩包，包含了 MariaDB 数据库系统的 10.3.38 版本的所有必要文件。这一版本的 MariaDB 是一个开源的关系数据库管理系统，旨在替代 MySQL，并与 MySQL 兼容。 mariadb10.3.38.tgz 是安装 ...
docker-mariadb-myrocks
05-08
docker-mariadb-myrocks 带有MyRocks存储引擎的MariaDB。
MySQL · myrocks · myrocks监控信息
weixin_33675507的博客
03-21 179
rocksdb本身提供了丰富的监控信息，myrocks通过information_schema下的表和show命令等将这些信息展示出来，下面主要以示例的形式来简单介绍下 先创建测试表 CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT ,PRIMARY KEY(pk) comment 'c...
【数据库知识】Rocksdb详细介绍
最新发布
wendao76的专栏
03-29 886
RocksDB 是 Facebook 基于 Google LevelDB 改进的高性能嵌入式键值存储库，专为。
MariaDB 10.3.8 数据审计插件的安装使用
vkingnew 的技术博客
07-24 972
运行环境：Centos 7.5+MariaDB10.3.8 1.查询默认的plugin_dir: MariaDB [(none)]> show variables like 'plugin_dir'; +---------------+------------------------------+ | Variable_name | Value ...
MariaDB 10.3 MyRocks简介
vkingnew 的技术博客
07-30 2009
MyRocks简介： MyRocks是facebook开发的一款基于RocksDB的开源MySQL存储引擎，基于oracle MySQL5.6版本。 MyRocks库由Facebook 数据库工程团队维护。 RocksDB是一个可嵌入的、持久K-V存储。 RocksDB 是基于log-structured merge-tree（LSM-tree），针对快速存储进行了优化，并将出色的 存储空间和读...
mariadb 10.3.22 linux arm64完整离线安装包
08-30
MariaDB 10.3.22 是一个流行的开源关系型数据库管理系统，它是 MySQL 的一个分支，由 MySQL 的创始人 Monty Widenius 领导的团队开发。这个版本是针对 Linux 平台上的 ARM64 架构设计的，特别适合在像 UOS（统一操作...
mariadb-10.3.35-winx64.zip
05-27
MariaDB 10.3.35 是该分支的一个稳定版本，专为Windows 64位操作系统设计。这个版本包含了众多改进和新特性，使得它在性能、安全性以及功能上都有所提升。对于Windows环境来说，这是一个经过优化的数据库解决方案，...
mariadb-10.3.22-winx64.zip
05-07
mariadb-10.3.22-winx64.zip mariadb-10.3.22-winx64压缩包备用链接,官网下载,备用 MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL ...
Centos8离线安装mariadb(10.3.28)的所有依赖包（RPM）
03-08
本教程将详细介绍如何在CentOS 8系统上离线安装MariaDB 10.3.28及其所有依赖包。MariaDB是一种开源的关系型数据库管理系统，与MySQL高度兼容，被广泛应用于各种业务场景。 首先，你需要下载MariaDB 10.3.28的RPM包...
MariaDB 10.3 MyRocks调优之TTL(Time To Live)
vkingnew 的技术博客
08-10 858
背景知识： 运行环境：CentOS7.5+MariaDB 10.3.8 + MyRocks 在某些工作场景下一些数据需要运行一段时间后，比如短信发送，日志跟踪类的信息等 这些数据存储到MySQL数据库 保留一段时间就会删除。通常的做法是在表上加上一个 列createtime之类的，然后定期删除旧的数据。 然而在MyRocks 中删除数据会导致很多问题，这并非理想的操作方式。 删除数据会导致：...
MariaDB 10.3 MyRocks 实例搭建
vkingnew 的技术博客
08-02 1289
运行环境：CentOS 7.5+MariaDB 10.3 +MyRocks 存储引擎 背景： 想搭建一个运行默认存储引擎是MyRocks的MySQL实例，来和InnoDB比对下。 1.规划： 由于我的电脑资源有限，在单主机上搭建多实例。前面运行了由3个默认存储引擎为InnoDB的实例。 端口：3304 数据目录：/data/mysql/node4 socket文件： PID文件： 2.参数...
MySQL · myrocks · 相关tools介绍
weixin_40581617的博客
07-02 328
概述MyRocks提供了丰富的tools，如sst_dump, mysql_ldb等，这些工具对我们的运维和分析问题非常有用。sst_dump 可以导出sst中的数据和属性信息。 sst_dump --help sst_dump --file=<data_dir_OR_sst_file> [--command=check|scan|raw] --file=<data_...
MariaDB 10.3 MyRocks调优之 参数调优
vkingnew 的技术博客
08-02 2729
官方推荐的参数文件配置： [mysqld] rocksdb default-storage-engine=rocksdb skip-innodb default-tmp-storage-engine=MyISAM binlog_format=ROW collation-server=latin1_bin transaction-isolation=READ-COMMITTED rocksdb_...
MariaDB 10.3 MyRocks报错 ERROR 12014 (HY000)： Failed to acquire lock due to max_num_locks limit
vkingnew 的技术博客
07-31 1143
mysql> insert into sbtest select * from sbtest1; ERROR 12014 (HY000): Status error 10 received from RocksDB: Operation aborted: Failed to acquire lock due to max_num_locks limit mysql> insert i...
MariaDB10.3 MyRocks 之统计信息
vkingnew 的技术博客
08-10 548
MyRocks存储引擎使用CBO模型，为查询优化器提供统计信息。 主要是三类统计信息： 表统计信息 索引信息 范围分布评估 MyRocks如何计算统计信息： RocksDB使用LSM文件，这类文件一次写永不更新。当LSM文件被写的时候，MyRocks将会计算索引的基数 和sst文件中数据的行数。这类文件SST通常有行数、索引记录数 和多表多索引的tombstones. 基于性能的考虑，统计信息...
MariaDB10.3 MyRocks 安装卸载
vkingnew 的技术博客
07-30 1358
MariaDB MyRocks概述： MariaDB MyRocks 目前支持windows和Linux操作系统，MariaDB10.2.16+和10.3.7+为正式稳定版本。 在linux下通过RPM和DEB安装包安装的时候是通过单独的包安装的： sudo yum install MariaDB-rocksdb-engine sudo apt install mariadb-plugin-ro...
MariaDB 10.3 MyRocks vs InnoDB 基本的基准测试
vkingnew 的技术博客
08-02 1849
在Facebook官方的发布的比对中是采用的linkbench来比对InnoDB和MyRocks，其中提到在SSD硬盘存储磁盘空间降低至少2倍， 但是写入速度降低了10倍，对于需要大量存储数据的公司来说对存储的要求更持久一些。 Benchmark tests against 3 different instances – MyRocks (compressed), InnoDB (uncom...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值