3.1.5读写分离节点执行sql提示内存超限 实际提示不对还有内存

curl -X GET -s http://172.31.143.160:8041/metrics | grep -E “starrocks_be_.*_mem_bytes|starrocks_be_tcmal
loc_bytes_in_use”

TYPE starrocks_be_bitmap_index_mem_bytes gauge

starrocks_be_bitmap_index_mem_bytes 0

TYPE starrocks_be_bloom_filter_index_mem_bytes gauge

starrocks_be_bloom_filter_index_mem_bytes 0

TYPE starrocks_be_chunk_allocator_mem_bytes gauge

starrocks_be_chunk_allocator_mem_bytes 59394936

TYPE starrocks_be_clone_mem_bytes gauge

starrocks_be_clone_mem_bytes 0

TYPE starrocks_be_column_metadata_mem_bytes gauge

starrocks_be_column_metadata_mem_bytes 300621129

TYPE starrocks_be_column_pool_mem_bytes gauge

starrocks_be_column_pool_mem_bytes 65286531755

TYPE starrocks_be_column_zonemap_index_mem_bytes gauge

starrocks_be_column_zonemap_index_mem_bytes 67046985

TYPE starrocks_be_compaction_mem_bytes gauge

starrocks_be_compaction_mem_bytes 2090386920

TYPE starrocks_be_consistency_mem_bytes gauge

starrocks_be_consistency_mem_bytes 0

TYPE starrocks_be_load_mem_bytes gauge

starrocks_be_load_mem_bytes 0

TYPE starrocks_be_metadata_mem_bytes gauge

starrocks_be_metadata_mem_bytes 343648327

TYPE starrocks_be_ordinal_index_mem_bytes gauge

starrocks_be_ordinal_index_mem_bytes 164355168

TYPE starrocks_be_process_mem_bytes gauge

starrocks_be_process_mem_bytes 110089923672

TYPE starrocks_be_query_mem_bytes gauge

starrocks_be_query_mem_bytes 0

TYPE starrocks_be_rowset_metadata_mem_bytes gauge

starrocks_be_rowset_metadata_mem_bytes 0

TYPE starrocks_be_schema_change_mem_bytes gauge

starrocks_be_schema_change_mem_bytes 0

TYPE starrocks_be_segment_metadata_mem_bytes gauge

starrocks_be_segment_metadata_mem_bytes 42636475

TYPE starrocks_be_segment_zonemap_mem_bytes gauge

starrocks_be_segment_zonemap_mem_bytes 34998184

TYPE starrocks_be_short_key_index_mem_bytes gauge

starrocks_be_short_key_index_mem_bytes 322927

TYPE starrocks_be_storage_page_cache_mem_bytes gauge

starrocks_be_storage_page_cache_mem_bytes 339547888

TYPE starrocks_be_tablet_metadata_mem_bytes gauge

starrocks_be_tablet_metadata_mem_bytes 390723

TYPE starrocks_be_tablet_schema_mem_bytes gauge

starrocks_be_tablet_schema_mem_bytes 390723

TYPE starrocks_be_update_mem_bytes gauge

starrocks_be_update_mem_bytes 31635176848

是的 改过

使用虽然那么多 实际是这样的 已经不能用了 但是内存还有哇 升级机器也不行 感觉过会就触发

也不能再调整了

be.conf 中修改一下 disable_column_pool=1 ,修改后需要重启。column pool 这个没啥用还占用了较多的内存,后面会默认禁掉

感谢大佬的回复 现在是1比1的内存了 我再观察观察看看待会会慢了还有可用内存不 :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: