MySQL内存持续上升，没有释放
MySQL版本：Ver 8.0.35 for Linux on x86_64 (MySQL Community Server - GPL)OS：Ubuntu 22.04.4 LTS
CPU：8H
Memory：16G
my.cnf
socket = /data/mysql/mysql.sock
prompt = "\u@mysqldb \R:\m:\s [\d]> "
no-auto-rehash
single-transaction
malloc-lib = /usr/lib/x86_64-linux-gnu/libjemalloc.so.2
#basic settings#
server-id = 100
port = 3306
user = mysql
autocommit = 1
socket = /data/mysql/mysql.sock
character_set_server=utf8mb4
datadir=/data/mysql/
basedir=/usr/local/mysql/
explicit_defaults_for_timestamp = 1
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
transaction_isolation = READ-COMMITTED
max_allowed_packet = 64M
event_scheduler = 1
#connection#
interactive_timeout = 1800
wait_timeout = 1800
lock_wait_timeout = 1800
skip_name_resolve = 1
max_connections = 1024
max_user_connections = 256
max_connect_errors = 1000000
#table cache performance settings#
table_open_cache = 4096
table_definition_cache = 4096
table_open_cache_instances = 64
#session memory settings#
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 2M
tmp_table_size = 2M
join_buffer_size = 2M
thread_cache_size = 64
#log settings#
log_error = error.log
log_bin = binlog
log_error_verbosity = 2
slow_query_log = 1
slow_query_log_file = slow.log
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_replica_statements = 1
log_throttle_queries_not_using_indexes = 10
binlog_expire_logs_seconds = 864000
long_query_time = 2
min_examined_row_limit = 100
log-bin-trust-function-creators = 1
binlog_cache_size= 2M
########innodb settings########
innodb_page_size = 16k
innodb_buffer_pool_size = 9G
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_lru_scan_depth = 4096
innodb_lock_wait_timeout = 5
innodb_io_capacity = 20000
innodb_io_capacity_max = 24000
innodb_flush_method = O_DIRECT
innodb_flush_neighbors = 0
innodb_redo_log_capacity = 4G
innodb_log_buffer_size = 64M
innodb_purge_threads = 4
innodb_thread_concurrency = 0
innodb_print_all_deadlocks = 1
innodb_strict_mode = 1
innodb_sort_buffer_size = 64M
innodb_write_io_threads = 8
innodb_read_io_threads = 4
innodb_file_per_table = 1
innodb_stats_persistent_sample_pages = 64
innodb_autoinc_lock_mode = 2
innodb_online_alter_log_max_size=100M
innodb_open_files=4096
innodb_flush_log_at_trx_commit = 1
#replication settings#
sync_binlog = 1
gtid_mode = on
enforce_gtid_consistency = 1
binlog_format = ROW
binlog_rows_query_log_events = 1
relay_log = relay.log
relay_log_recovery = 1
log_replica_updates = 1
replica_skip_errors = ddl_exist_errors
replica_parallel_workers = 8
replica_preserve_commit_order = 1
replica_transaction_retries = 128
binlog_gtid_simple_recovery = 1
log_timestamps = system
#mgr settings
loose-plugin_load_add = 'mysql_clone.so'
loose-plugin_load_add = 'group_replication.so'
loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"
loose-group_replication_local_address = "10.20.12.106:33061"
loose-group_replication_group_seeds = '10.20.12.106:33061,10.20.12.107:33061,10.20.12.108:33061'
loose-group_replication_start_on_boot = OFF
loose-group_replication_bootstrap_group = OFF
loose-group_replication_exit_state_action = READ_ONLY
loose-group_replication_flow_control_mode = "DISABLED"
loose-group_replication_single_primary_mode = ON
loose-group_replication_communication_max_message_size = 10M
loose-group_replication_transaction_size_limit = 1G
loose-group_replication_arbitrator = 0
loose-group_replication_single_primary_fast_mode = 1
loose-group_replication_request_time_threshold = 20000
loose-group_replication_recovery_get_public_key = 1
report-host = "10.20.12.106"
#perforamnce_schema settings#
performance-schema-instrument='memory/%=COUNTED'
performance_schema_digests_size = 40000
performance_schema_max_table_handles = 40000
performance_schema_max_table_instances = 40000
performance_schema_max_sql_text_length = 4096
performance_schema_max_digest_length = 4096
loose_innodb_numa_interleave = 1
innodb_buffer_pool_dump_pct = 40
innodb_page_cleaners = 8
innodb_undo_log_truncate = 1
innodb_max_undo_log_size = 4G
innodb_purge_rseg_truncate_frequency = 128
#innodb monitor settings
innodb_monitor_enable = "module_innodb"
innodb_monitor_enable = "module_server"
innodb_monitor_enable = "module_dml"
innodb_monitor_enable = "module_ddl"
innodb_monitor_enable = "module_trx"
innodb_monitor_enable = "module_os"
innodb_monitor_enable = "module_purge"
innodb_monitor_enable = "module_log"
innodb_monitor_enable = "module_lock"
innodb_monitor_enable = "module_buffer"
innodb_monitor_enable = "module_index"
innodb_monitor_enable = "module_ibuf_system"
innodb_monitor_enable = "module_buffer_page"
innodb_monitor_enable = "module_adaptive_hash"
参考叶老师的深入浅出MGR搭建的MGR集群。目前master节点内存使用率大约89%，从启动数据库就一直处于上升趋势。有一些慢查询，但是慢查询应该不会导致内存一直上升，请帮忙看看，谢谢。
有几篇参考可以先看下
- https://greatsql.cn/blog-10-1218.html
- https://greatsql.cn/thread-560-1-1.html
- https://greatsql.cn/thread-447-1-1.html
- https://greatsql.cn/thread-167-1-1.html yejr 发表于 2024-4-23 11:05
有几篇参考可以先看下
- https://greatsql.cn/blog-10-1218.html
- https://greatsql.cn/thread-560-1-1.ht ...
叶老师您好，
从你给我的帖子可以判断是内存泄漏了，但是我用命令：gdb --batch --pid 4757 --ex 'call malloc_trim(0)' 无法释放内存，这是为什么？
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA2wAAACLCAIAAACSp42hAAAgAElEQVR4Ae2di3HjOBBElZ8dlJSIagPxOpDduiDW5QBOg0+jMRhQpD62Zbfqao8Cgfk8gEQbFMndv7d3/u9lvyufp19cru2zBEBu/7tDerahKoiACIiACIiACIjAwxHYPVzEClgEREAEREAEREAERODTCUhEatVQBERABERABERABERgMwGJyM3IPl34KwAREAEREAEREAER+HQCEpESkSIgAiIgAiIgAiIgApsJeBGpG2su1vW6seZidGooAiIgAiIgAiLwcAQCEfl0/K+l8ffX0+lu7f1rKfl92N3kru3Bzst+1/l9ez/J2f3vdygzu2ccYfR3lJfYcqjp3nJ3fzSMoPxoWeWqNbW397DQjGfLlDgM7naHxipFdTICL26XvoqACIiACIiACIjAtyGwRkQ+Pz1VqTSIvwtBDHZsBbTXiBCR0GQm8vo67P349Hz8m1Zifx92u7qd9B8s5Prsa78r4jUszPVNF+6bemaZyK1aZT3iJ1T5KhQBERABERABEfhGBNaIyMPx+FyWCUn8maSjxbxxKZHFFqs92yY7edef47MTiLm5aUtoMlOHVc4u9gFaZSXaeTdZWSXm27v5ffqV1hqHwuQiV/hDAe9d817XLmW9GHMXpGqKgAiIgAiIgAiIwNcmsEpEvry97vPF3KqleAXu+GSLeTMVGGujagd70RyyL68sQg5aze0i0gTf8VDVbhKg7NoM7kyYhoXlQnYSl1TBcs9aNlrmlIhEn2pDBERABERABETgGxNYJSL/1V8oQmzteUUwC6yTIEtrcliS5BU7T5A0WdmVSv68vZpCS3ZGEYlLz95ar9NN5GXJm3/LWFcKS3l2lHftDqaPd885rz994fGv/S5zXII170V9tsVLhCQRCRTaEAEREAEREAER+MYE1opIu+C7fy0isoitusC3S6Lt76+np1+mAveHfdJtndDsdR7EaCNbtd3++Hp8ytrOFg5NU9aPu/OmtSXjtqIJgWtx0uXv/BWrj7nVciFupiHV20RqMuWikogM+0WFIiACIiACIiAC34zAahFpNy+nS8PlF4QkzqqG2+8OL78PT8f/XvaHl6Qpp7BIk5U6qf7L8XD8a79T3P9+zRq0u5xdHc3MJgXZrQ52q6FZL9q/VCdHEhWmy9ZVwNb/u19PpiXJDoVE5Kx3VC4CIiACIiACIvCdCGwQkf9+H56e0m0o+Wk49TIxcOx3hyNU4L5c3cbebiMUkbt6G7hdGT9sFZGjgsxX4XG/jonCcqG8Xu9OieSlxJP4w9OL8q8844BNbrZ7fdqqZBW4EpEdt4pFhSIgAiIgAiIgAt+MwBYRmS8u1yu8prrqx+uwpLTcdd4OXLmmjPb5/uj2BB+7ip0crV+JtCb8GeMk1YvgOciwsITNqpeDr16QnUQkUGhDBERABERABETgGxM4JyK1krSRgETkNz5alJoIiIAIiIAIiAAISERuflMk2IUbEpEhFhWKgAiIgAiIgAh8MwKBiCzXhIcLtd8s85ung+vp7enoG1cxbx6SDIqACIiACIiACIjAnQh4EXknNzIrAiIgAiIgAiIgAiLwnQhIRN74cvZ3GhzKRQREQAREQAREQARmBCQiJSJFQAREQAREQAREQAQ2E5CI3IxspsdVLgIiIAIiIAIiIAI/h4AXke01LbqxZuNtMbqx5uccNspUBERABERABEQgEJH8/O30lr/2DPDgndcblVYhzs/uThZe9rvO79v7Sc7uf3fvzsa7Z+JuS084z7eWu/ujR3mH54qzzbEwvQWnPcEcZseaCEmP+AEKbYiACIiACIiACHxjAmtEZH0b4dv7XUUk67n8xsIsIjvpRm+dcb1ir/b+m65N2xtl6nb/lsLcBO8//JfewZPFa1j45/jspK17leJ+57WvRKTrF30VAREQAREQARH4lgTWiMjDEVqKVhDdaty4lLgkp8hOxmprfr1AzM1Pi4gQkSZhd4c13YBWeTmza2KyskrMt3fz+5RfujgUpr1eRIbNaTl2KWuq1oWkchEQAREQAREQARF4NAKrROTL2+s+/0Syij9etzs+2WrcTAXGaqnawV40h+zLK4uQg1Zzu4jc756Px0O9IJ0EKLsub8E+dCusKAxFZNicel0iEn2qDREQAREQAREQgW9MYJWIxMVliK09rwhmXXXSXmkpEUuSJuDy9WXSWAUlS7G8N5X8eXu13y8mO6OIHK8dhx1jAjdL3vwrybrAWcqzo7xrdzB9vHvOef3pC49/0zplVaBloTRqzmlKRIadokIREAEREAEREIFvRmCtiLQ7bPavRUQWsQV5lUTb319PT79MBe4P+6TbOqHpdORMRP79tT++Hp+ytrOFQ9OU9eOvLDub6autaELgWpx0+Tt/pYVG68uFwt7+SR2ajgybU02JyG92hCgdERABERABERCBkMBqEfn2bkuDx0P9BSGJsyqh9rvDy+/D0/G/l/3hJWnK0KUVjiIy1X85HvL63/73a9ag3eXs6mhmNinIbvmzWw3NetH+pTo5krCwd1cuuJ+rKRE56x2Vi4AIiIAIiIAIfCcCG0Tkv9+Hp6d0G4oJSnruTxVb+93hCBW4L1e3Y1ihiNzV28Dtyvhhq4gcFaS7kxq/47Tg61Mw8w86/+WMhsIWvGnHcotP2Bw1JSKBQhsiIAIiIAIiIALfmMAWEZkvLpPSqteZy2NumrpKkmvp6nO5KFwNlPujmzC1q9jJ0fqVSL7wbXbHOOuPI4tkTM45SIu/L0RJe2ZQUswo5+Z5lJx2tdvJq7z+xgNIqYmACIiACIiACPxMAudEpGTQRgISkT/zQFLWIiACIiACIvDTCEhE3vjd2RKRP+0QUr4iIAIiIAIi8DMJBCKyXtP99TOJXJw1rqfrcvbFDNVQBERABERABETgUQh4EfkocStOERABERABERABERCBTyQgEXnjy9mf2JdyLQIiIAIiIAIiIAIfRkAiUiJSBERABERABERABERgMwGJyM3IPkzgy5EIiIAIiIAIiIAIfFkCXkTaE7nzpz5nMQz93vcg4wXcoXcuXK55vziN0yIiDvLm27f1np7TnnqdHqWZY3aO1vNcX/MyOMv9zjZR894hwWnoaAEyGo4bCJ5fAao7t0ZQKhEBERABEfh4AoGI7B6g7Z4KbkrDXngYTpM3jJ7nzmWzyzXvF6dTV8tB3nzvPbyX9zr2z8V0jmY8x16Y1bwVitHjzDJq3jskBLDgKISMhuMGgseuBeOoow0REAEREAER+AAC50RklRR4PWCO6d4z2Th3zlgs17x3nLOoHrF8jb6Z8Rx7YVbzVmRGjzPLqHnvkBDAgqM1kGEnv7ez+6Pu/n+/sXdti4AIiIAIiMACgWtE5KstU9W1SUx4Nk2mDy66nebU8qGrpa2QLgq3wl15leIs9LBmK6yOTiX73z7OVFh+CsmTek0nB/t8/Gt1xkIkuKte0tLs8/GvdxQ2DzOahdQySgvA/97e7+E9h8Qo5o48zxZP7eSMJSSf9RyafPAICUMKu4NfjIlePj7FXdz6qI7kBUcOcuioKxwOhGRcP+QVAREQAREQgc8ncLmIxOuksUhZfk+ZpJVNlmlOtcIqtlDzz/GQJVqeL/NaC9fE6lE4x4c1uRCO0gRf5CAq8DSMSR17/6UXf2d9ExaGkosdwftCc5dXGBJic5WLwqtUq+YoaV7gPcwoLOQ0W3Zv72N/cc0upJPW/KQRwiFx8CNe3ovguTkKw5HMNdnU2HG8Fza5MAQL8T1GrhIREAEREAER+DACl4tIzGTQOjb51cWYJMXs15P7uoRmKf0+tAr1QnlpbtLN6uf/xrkTu2DZ1QwdnaZzxGnehx90InjTur+Ld0znYWH2i4b5KzvCroXmLZ2Uctjc7BATbgIXN/GejTibYSHHCZ5YhOYIuSYsf+4I4ZA4eA47b58dS8iI26JwwRHqTB2dOxA64/V44TC0LQIiIAIiIAIfQ+DGItL9fiuv6uE6p21klZlW+1r5/nUmDQMK4SzrDFZH3YxbG3IhJvVTYVkxtWptVW8szCGhYf663maQUf9DN7Zsqit9HFiuk1cioYCxK8wo9B5mFBZymtxlo+jnmghprPZxI6SHzMF7JivGEjLy8adFVs7dOWoN39592zxo6yjNUY3EOuMSkSIgAiIgAiLweQQ+QES29UXM1rZkefyvkynn5k60dbNymWX75qjczbh1HZQLMalDrtlUXmMLC7uwa8+tt4nYeCNszhWY2HhVNGy+EDxbxjZQoGTZEa8rL2sdWB6rud6Ea863NO+7ODBV+8LZRE2mxMHDadnoHWEvN0dGQZxOrdZRl+2goX0NHfWFCD4MA4XaEAEREAEREIGPJ3BnEZkmVPwmEum167w2ZZYlQBTaREtKDq2wEdY8zfGjI574cZEaG+maZmrVz9zFUVhYlUqnBnrdUHYtNkcueSMIqTryFVL5bb1nF85mWBjyLFoTv2RIEXJNWB4lUflBJ/2+M/tFFyeldbMRgvXaBrznDNrLYwkZhXFy7s4RGi44gk2rPBwIbDwb0b8iIAIiIAIi8CkE7i4i620f3WXZPDumosPxNFNmDYFnUu5f/xyfsRwYcJnUPM2v+OTmY4lZy8o1XT18qd553Q4zd1jINs3dcAUTQiFsHqQzCalzVGVWV3gj7zObgMlpotB1UDOyCMS1yjRa26qZ7jFCRi9xX1QR7DI9NYcGRReHcYaOuBA8w6Oj/G1zqhQdCBzGQvzaJQIiIAIiIAL3JrBWRN47jk+271YN7euzv9qYCnFT+fmAI5sbmkcrZOedotXnekcY2rg1AYnIDUfBreHLtQiIgAiIABOQiEx3ZNcbtzOatLx0SAtC7QedpXD9tBTaXN/8ypqf6/3K4NV8TkAiks9f2hYBERABEfhEAoGILFfx+p+4fWKIH+O6v/RctGNYuD6eK5uvdxTW/FzvYUg3Lzz9fDD41Ev/N3f3uQaRLK6qf2488i4CIiACIvDDCXgR+cNxKH0REAEREAEREAEREIE1BCQiP/+tQWv6SXVEQAREQAREQARE4EsRkIiUiBQBERABERABERABEdhMQCJyM7Iv9UeAghEBERABERABERCBTyFwlYi0X/rf7v6bD7vttD3bb7gDw2W0PqT1NS/r5vAx3aEp1Fwf0j2AhLFdW2i3nNsbKWd3yiP3G2YEm9cGP7/h+mLL69O82MXHNATk9RmtH97ra16WLII/2xw17x3SmUjOHUdnmt9hJMujCIjAgxIgEdk/FMY94CZMz0musM76wutPrDhHr3Fq09WlInJ0dH3wyzGPHmf1UXNrSNcAmQVz4/Llyc89GvMtac1Lu7hEPtgcM8JN07tdeyDUv7d3lJ+9mTquaa5X/ZG2puPGsL9QyQB5TUaz4Y3xjwRnNVHhyo3R48wgat47JBeAP1EvH0fSiCIgAiKwmsBVItKdqq78ev2JFefoNZGEE5VrOAtpdDSr6Qxe/HX0ODOFmltDugbILJgbl0Nt9C+kzl7Gtxxdn9Fo02XEkO2ZSlmzJv13VjuaqXlNs7w/rFnpX5OmC/tLfR0hr8mIyXM6GP8onNVEhSs3Ro8zg6h575BaAGlpwN4KxpeMFo+j1nb1LKImIiACP5bAKhF5OuXVT1lrsbN8/tBKz/Hp+fj3tS6rtFWZWpIb2OXIEHc6sS42p/OgC6nFUwMdVxmdUzdRNQtdRrv97y6kVq13FAaf5ww0gapowfe+isk4zV34wkAk1WzWNweGIaH+uHEZkH9v7+fTrBkFNbevf4+R55J9utLNey/OCEaazaT20AXpGZw2wlsFWvg87UVfw1S4MatpkT/9+hNp5dHOujSDYzONkHIwFiOTNEenuWQ8tMOTQOCIBAozzGbXZfRTjk06tKOTaj24wj7ap715OIUVVCgCIiAC1xA4LyLdCZ2duV3pZFc04vGpiJ71yzNhc9gpbxlOqsv5RUj4Qx8lCxuhEVfIIbVEqmxi41wTMVuT0wcxpxM620HNP8cDtDUKueZyamFNDokrcNi87XLPu1xhaNOMD2lOMxpqnlpDcq2Jk2PGtoszDD4sDDMKa6YfeKThTcI35Z6mdlpTNFV0PCQoO3eNGwHnjbimmaqOFiVCHGfSZw4Ip4kBdioE+Va/Xus8+4OW1lmU+wZHUZyXZdQi+XbHZusXkt3oQT4ruqHFX83IioHETbQtAiIgAmsIrBOR/Y+9YNed4MI5iSUCn/tgBBtBc5qtrZrNVTZhm98opGWlBUd5wwUfFnJIPKeOjrgmLNvchnN3DX7PkUdLTaV5rZ8DGz22dCY1OSQOvjWkaalQpZXR9UDCNNnLMhDsdQt7bOHsdpdszYstw4Ir7Br2463b1RTPL19urXb5jh/zYt1Rr2snTdPGQA2sBDOp2fo6Gh5IBBsuo1zuCjlm7AoL60gY0nTBpx99QoPi0A5thoU5Tt51cUY8vBu9GjC7QO7hoP2Cx6YFzGeMt3dO1oj1hz8Y8oYZwYmoYuEK2hYBERCBywicF5H5emVeVsHlvOwMZ+T8NTxZnwrph2LTa9n5T2rMScWym0TpdGlzQPpwSOP8sQDFBX82Iz5Zj47C3MdqRWGU2HMCv8x11hMo37+yO1wyjtMhLFyTQ3LWQjsXAwnSDDOKVolq7mkx76TGBhUbhuoL3Tip0+TFGZn9ic02npOXpkWSlLTR2HeH/1pj6xLPhbkh++XtboS0y5pV8706Ji53HgzYFRZmOy7NlAVGZ/He6lhs7RKEP4rf3qeOOEEigwg5KVfINhnyOBq5JoyM1focv9Cx6c91Dpobb4QR9CxriciIDBBpQwRE4DICJCLdycidqtIRaCtrx//gCWfkXDI7WWPy4bYwgo2geb8y5P8EH0IKJob5icMFn8NwhRwSq4rREdeEkbEaz3ZIPN/JCziled8dgSmkNqnJIXHw7Je3EfZCYWgzjI2HCiyHNfH3w2myhP7gGM5uz8zCL1twhWFGrMW5bXL0ilW31Jv0d1Edrt2P/PreYWt+5TXVhGLAUXPaWMbiMsouXCGniV1hYc2d0sRI6zc4VIze0GZYWB218wngIEKUjFqZbfLwHgcD14TlsdpXPjYzh3JM1WFW4LivfR/lOpa1RGREhgeYtkVABC4gQCJycn2KjbbpMx2QOCPnOsHJenEGZctQErkQllmLOO9wigls07kSLjgMV8gZsffREdeEkWCiSqsy43pbu+hvxMraLQrNYC/fOeasQbPO4JocEgfv2uIrwkbJ8swNm2GaCL4s8KQlxrCmubO/WJ6fLpvn5mPs4oxiPYHZ2jwm7Zg6CwrPRFVKwTbqkipvM9i8zXt5u9SM/pAbjWxNE/XRg8a/jrq0ndYakWY4+06w86g742hiYRx1OWVYy1/ZUUsk/9alH0hcE0bCoXiqiY4D53Ako9AM3vDYTCNqJviQ5vSsOGluQfZMkF23MWne1QkHgwpFQAR+KoFORJb53uaTdjK1Eys+dWrsCmvl2ckarZfPtmHzrJCKhdB7LcxnuhZYX87nwVYn2001zxZCqoaOwuDDiar8Fr5CyWbzVJTKDvY8jhx8ntpPpfvX8TEonFERAX1NzsgF37XNurbGY//fCCRMM8worJmD4XnRhbf81RwNfc25X5BRYDP1RacXce8L0NE83QIYYnPpLNU8JyJb2xzDYsch+JZdFg3paZQvGeMszej8aKqXPnmMnUJa5YhuZmcgmzKCcze8m5EKZAxpNhRb2yoNw5EcHnGcSNuOjuLRS6k/yDiuyeO8secBttw8dXQLbOzToflS5bG5SkRABH4egV5E3jx/OyvR77fsK13+u7k7GXxYAt0l4C1ZXNxwYYK8h80Fdw+56+pDW5Afst+3HJtKUARE4NsTuLOItL/Cm4hMf9O3r98erhJcSSC4kqu56osT0KH9xTtI4YmACIjA/QncWUTmR5zgshMJypXyQtWYQLuG1ZC2Hx5wzUfZLpdE6ULwo0S+Kc7v13H5thgahj/9j8Nv2cWbBrkqi4AI/EACdxeRP5CpUhYBERABERABERCBb09AIjJ+B+O373glKAIiIAIiIAIiIALXEJCIlIgUAREQAREQAREQARHYTEAicjOyazS72oqACIiACIiACIjA9yDwICISz1r7qk8IOj3ODc+iWzUyVmdkP9j/7vedjMTaw/noMXhh4di2KxkftTgnP3t2YGfwHje7zUO6u+t7pHMnm3NKn9ZxUaaPe8B2rw6PUvvE0XiPLv5SNrcOm3sEH/YvHC2cfrcGHzoKC+E93BsWhnGGhWFzFW4l4EVke7YtTd6h0bDm5YX5Obd0tycrp9MYdRItdOTjnNu0QV8+9a5Squx8ObP8jGXUPMWDbVc//DpmFFYrz1q/v4hsx1iV6Y1wAuWe5zyL9rblFtUwDsPC2K/1qX8u6QL5C05Y3aPjh1BbVDS6yrijPh1DavC32lx01OLJEoEq8+jF0cGdviqkZHZ9TR/PonAZKaH5JR03yR02z27MnBo96tyzdi6rMPO+3toYpx1ZV0R+fUjT4K2z6ol6cZBMLUStbh/wFXGO3bGUyxWOlsyOlAZH4el3W/Cjl1nJ4H198GGcYeF6m76mhVc+Z8+fvu0s5Qcs70QkP65v+Q0iYc0rC5kymxrfQcd7l+MMbZ4mOXQ5TB2fqtqwBY+6vdyjNoZKTbbJTuPtK46N2OBynOf2GgQ6Rx/3v+AFb1pDyUduhMd8WBhGFQS/SP6CSQXjJ8t9Vl1hSLmQW918eLPfztEwDMIxz9BO4yIfKWxn+YhbX5PjPL99644Lcz8fBjG8YLRssr9c+SrvdopLb8YaJOM1Zq9pu5zsmfd1Uacs23F7bx7wneJ0Yef3gq481YxtN5WMGa0//W5yFFYevYfVwsIwzrAwbL6mMDyHhOfPNdYetw6JSJJE5fW1T7/yixAxXm2G2B1SYZNZ1jGl5hWF/Ymge5tFOuU1xGGcqXlbAhlOjmmOL+Gx8XBUYe40p+0i2g4cEAxMJRH5anjsQ380h81dRn3uMG6x5Q8tR6WBGzmaGIG16UbP01XjQ8LtuuDrLPjKzS/hhL0TFgbBjBeyS29S77hhU990160vcm86yD06C2x2yPQNMWwsbDcYQpsuzsXhzSgGR2VARSM56cU+mIJ6fUjzmhzVwvZshHhKDsjWjvPd0f6qXIgNuwyL+6QjtJXjgD3x3P9K56Xn4++0blH7rp2sUPntfTwQ0oml/G47d0fzghjIAoJc2NinGMxODaZVth70B0jbW7m14GEKweSNjSGNLrikG8bda1pTqP2g5aHS4qSkqLCd0lthjXw2FFtNspmj5ThP1bBUkTsunVWej3/92bt1aHUdT7sVPs9l2a8PaT2Qec0xo1yCXNrXocdDdAEQG2ytC4q6mKQZ2ixX6nIA/WB2cbZoAZkc5b3tX8NSPnyqtMNz0vy0y7q75xnG0LwsBPBQu0hE8qRbIOIQTfILgMKaVxYSNaC3DffZv1o/YbhQnH+Oh+PfcrYdpQ9s1ockp9TSIMahjt4tA6JM8E0Zo0LZoEjSYVxqtsUYC69rHmdEuXsXwyuG2dGY5tj8bImFBJ5DJDdxgRg4eFBiF1aBjlLuNRgJC7EXG26ZYUYeYeSBkU8ZK13MhmI6lfSHDIGF8TgkGlTJTvmbZP3wBgE4spJhKKJa3mgnQR4MOZj1IU1qOl8LX3mE5IERU8pvMahDBX3dpUzMFzzmeWg8CSw34dHianYxpBPU/vd7niBf3l6zzuBRh/GPjfI3TMruBASxsWWk7Lyv/2rWuK8rLvYYWpsNxetDmrjrftPCEFC/nbFpYIQ1mTwC5kL0Ag9FVAht5jDcLsaIXWwTjsLm7YC1IdTJeliLG6Z+XA+Ea66x7OqEMYRphkDWp8k20R3M0CrUE0JZBaOvYZy50P87P1WeWLELblgw8gkwn3WjQ4wbfoNtLyL/JF212x1wvqv9YX9Pl9NZIuVq2mh4+nVxIfTf+GdWGmd0FEWOuHkN+JW7h/9GtPJ0cncKL9e3AVo7nscoW0sD2uQtzu8NTjFuAc+a+4zq6ZtdYNsdtOzI7UKTTRtmJOdbur6lv5TCYsyzADj4PGA8Couh9XWYYFg4eux8IVp3Ru7dYVIxFxRGNm5nEP48/copuDGfh2IKkg4ZBGCrTd3fFZ7ATYZ3cseOpkMx1eQxz5OKpbyYJrCXTlkRPJqEG9xrXUfftuOoOzj3MKRZIUaLq+DDTgcXKudO6W5hSdD8MKgjcwYEBuE9GJ+UJqphw+KsJzoULohjroNtTnYMCdWu2WAC5dw+HJscBoa9FbqalWqOBwEH3ZHO3ji95yN95j1bc3HyV4QXFubmqANWqSQ4h7CRWUhsbQlIv0iRVvva40qco1mc44TLDRFJWFjbnk+Tm5fuWDwnwC94Vl+dMOC9eXv5VDnWL8tS9VAKzp+Lh2Fo8LEKexFpc2Sdwvvj7dSFTYMXBdbXvLKwgra+r/1RULqxEjp6e8+XANosT3+FOJtt2kimeL3aaoJAurrUziM1Qu5gDLhuiFd0PJ64lZ8wIsuo7w4GduR2ocmmDQcHp8tsBAlusjmrzMEXCHkGBYGKLlsIEwwLR48xfDeWeneYVMp5IQ0mHh7ey2wopnS6Q6Ym6GnTnxzF+MymhUqf+fBu6Og4immkqCwkGvOpX7Kjw8spmLz2bwX98R4ecbPga/oe4FDOI6TraLNcAyiu29fNHVf9+txr+dk4F8SWDzv1AiLc7579mYqUevNbR+YMCAy2JmHw3bBpxMqESiMEdrr4z9ts88LakEKbs0J3fkjV7ASePu3YrLhs9NKh4WuiWrVjFjpE2a79KJzJl5NVbeW9R2tO3BxIw8JMHnXQEbwg3QpvC4QPpb+/nng8RI5mOswFH6YZFua8Tru416xw8M7NS3e4On3nupCyo7CwsU39u3CqdDWbTT41lXOgnTDL+TOZDdt+j0ISkZfHV9cAABWuSURBVNYHtEZCPZTODq9NT4Q1ryysoIMuDOaPIE7+vb8bK53NMc46AqwVE3DnkRohdzwc+SGejsaukJu7jHjXsA0X2S/bdLs4sA3bFkzAE+7amXqIbYOX1JaDL6cJh6L/GiYYFo6RdL4QeW8/zR9tZg1nQYyrOnPlGSQt0Y1jqZ6F/SFTA+iGYi4MQgq6A2GM5/HA5vD3T0wjr0Nw79c4M8/yw/ZJmkFIk5pj78xKOM6uowNKV3RcStPsz3OfRYjycLT43qlnUVSuIrIFXwy6BOvXGRAYRDzB+Ox7EzXzhqVfhyvvGi3z3nz1H+cE7qOzDZ2dNV+XbfIIzKBOqjH8s7/UtPHZyBfjfSGiYvKjpnEcxji5OSiFhdkj6iCAZJOm3dSboyPUdyGtApJs5pruLpaZozFOP+b7eRP1Z7mvTJOb33Xu6BwtHkEl8fk5xCHlnvpO2yQiU9/jtNIkYz2dpRm3TG8n0GPNKwtLl4znNQRQezR01KZSOym0v2xsELPNtBcnGqxKWrVhNKTCdtIZOx5OeeQB3bT5kNFoGSVmhP62ZkduF5ps3WCe7nSJXLbaDOtz8JgAsDFePQ8TDAtHd/FJcCCPHjSz9CtvGFwmwOhaTXixwdYUobngoZjHMyrfZHgnI6OjlJ0fyamwhYeU8wYbCdMEurKWk0ZpWNMM5qNyTL9mnZ3yCLEAMPIHSvCesmg/z0cWrTt6Fy076hq0Whnn9GTVXx/E0YTRmK8tGiWkVsMLD4SWhRForbh3WvDV1JqSmQXugtAOyHO/LwAJjISDYSy0Ej9o2VqDU9aunru1NKKBmgieh03YHcyBuwYBwGbi4ONse6nj2KYFQGPAfbWRk3M3CPUgvQOQ3HFPx9fjE6Uwd+TjTJBdYZhmCGR9mmwT3YGNy+cOy7SJmTKMJ6PuNHh8l6FraLDlEWJMzp3uMJYeeqMTkWX93M5V9aScDoBOclVqp07NH/xVGjRPZNfWTN0JXw0rDifqp9Gm9Vn5pKdX5OMztJmP6hJ9eZyNjQ/+1O4ns4UJXJ+qI1ouZCBjc8sryqjlW9NkmxZayuhUCKdmnE5Do4X1JbjuY45S7s47J7XerKvJNtlgg1/T4Zqcu23jUys7L+VrCHksxGDYv+IPx877spf8p1cKqWSUDKKPEtg0B4RDcTIYEAAo0UA6N7wnjshCGckNe0bq+r1PfG1II5BuPNNEVcu5+05egK4b3rfuuDD3HEnK9EycVDOxS6yAqIxQugvQiUg+VbaTLd+dDfipN83g06+X/nhv7lA5Qsp4fdjU76WauTuTOw0kGorJ9dqQclL1HEuuh+l8SK25OAXf72VJ4Qi3mtHx7irng44d4TDkQtjsBiq6IOq4U/NxeHc2c1KTc0joqGt+AZAUsB0O1Pa8o1q/806FY5rlTw4eyZemie7Ii68nt/ap8c9CyrXKv7Vy+EcjjfAqhCJK4TmkeYcLDIlvuuFF5HjGUYkI3IrA6QDDyeVWNhfstL99v+nRu5D7F9yFVf8vGBuH9Chxcsy32obYvZXBa+zgjpCVRrbWXza7/mR1W78LUW11tLU+XF/cEBau2Qi9r++Oa1yr7QUEJCLbzWgX4FOTTQQ++kRgiwH1SpB05CcSyMs/buXpE+OZuX6UOGfxX1duCzBfv48mOZr0v+naz0efrCZ5bTrBcuWbA2HjH7/96N3x8cQ+zKNE5PcUkX6lPS3ih4Xrz7xh8/WFu739SPwjVyLtKKp3NnzYESVHIvCgBLon3dxa09yPiaml+iOcG3r5hJPVjZjfCcgN2V5g6nG744JkH6uJROT3FJGPNQoVrQiIgAiIgAiIwMMRkIiUiBQBERABERABERABEdhMQCJyM7KH+0NBAYuACIiACIiACIjAzQlIREpEioAIiIAIiIAIiIAIbCbwg0TkPZ5e8aVs2u/Lt9xceY/gw79y4Kg9f2u4j3Jr8KGjsBDew71hYRhnWBg2f+jCzT9gz3c0260N7UZ415tfB50bDC7Oh+44BS8CIiACH0+gF5F4Pio9Rpuf58kP+fz4WK/yaKmdeYjuBfbdnHSBBd/kiji3zYhXOPIxL99UODgySfFhInLwvj74MM6wcL3N8zUtYHpYyYffXb5VRJ5G3XjHfTgU745ueRymve6ADeM830dzR87+NabUVgREQAS+PoFORB6f6lqCrS6UbX5iczhhfP0k65ud/rt5qDefM/DSlJuH6gx+oqOPFBPXpBnGGRY6tld9NRH5/IRXkH1xEblFo98d3VzboUdufsDCct64t33nTl9FQARE4HMJdCKSQyl60dRkW8D7CtMAB7l+2z0E/7TcUj8puz5Nfi2hr5kmKipsr0VqhXWZLYnyV1vtsE/D2GpSYc6F4zxVwxoPyIc2bW/+VNf5bU5YOU5PDmsBpNXl+geDz2gjkDm6MaNcglzaVxe8vTrv+fjXowuApHW7lWmGNnmh3f0YwMXZogXkBdViWMoH4RVfy82TLDsen0srEpF1IJ3/0cI4wAJ0OfghzlTTk8+5B/+63s9vjh56c4auxbnMhN8HWH+wkeUaRj6OlCBIehOj/eLjaH9MoiEvis9sxnH26JrB2u+wPHZc4MiRdF8XRpp2iYAIiMDnEVghIutZ287ONKWFJ+uvWejUgPuaYy6iOfUEnvUf1sTef2/vWHjgQqzdprmnaDVUCG3mGNyuNJ2XX7liF9uEo7B5ksLJ+zAhwVrcMEFYD4RrrrHs6oQxhGmGQNanyTbRHczQKpCaWRNnDt7/a8A7jY4KpifIBcrbRhKRL2+v+3zc1SNuIc7WNnVcGPYZdHQCYkrsNPACtTSoxjAGV4guyG8uZqntfHEY6CNrfvokmGaZT1OUTj5IwRwHbHYRhDTYjOOcdLGz71JbDp6PI3bqaOirCIiACHwdArGItFNYPSnzqc3O27X86+RwNhKeQesiRLcsVwrr7I7lQJtj3GJhf/0Oc0b3sgea+NsCSS0MbNY5z8XJXzHbhYWZAOoASCr5xU3yLlcShsTWloDkRZ2KLq32tdu7nKNZnI5/nnqBDpGwNRTWtufT5OblzyEnr/vOZRc90ld8DTdY9IQVlgprDKdj0AjkYbMYp7NmYbtBm5biQp6jdGNKIYHOnQusjuSwoSsMD5nOeLbmXBCfdi6qhUHzfhcO2FzThcTnvbSWb2eJMM5ZFzv76S8cOtXUYEJHHAyOuCCjClm7REAERODTCQQi0s5lPAnZSTx/Di+n7SoXPj30tQFU9cb17SSePm0Sred3O+9Tjr4mqqVTeZkzrLD/JKnN8zFPJ94mJsteoHNzTDBhYU4NdTjTU31Ox3bdFsjbO6Zb2+AUIkdV83kd5oIP0wwLc7Jr0uTmpTtchH3nupAWIDPwfM0ais3tOv8VMZw29q+lsxbjHG2OA4xzR1789yGMhDWx1284hVf1DVxw/a5wcshw/bI9yd3LteraWwBPPmBr5S4kurDQjEziDNHxpYlLgkeo/SmoBVPDVokIiIAIfBECXkTaWXVyJS5P/011PcgZbXmysSXX9BsprH6dJuBQAZSaONHznNQXomt5Pg6lG3sf4+TmmO3CwuwRdRBAsmlvrEaOwTzX9yOHlH2dAZKa55ruLpYxo1mco7IM0wwLa0bn0+TmTZz5v5fautHIc4wTqHmjc9Tj5WrxNo0lW9Y9Hmy9zWk193XuAr3JISEvLkQwXIia2Os3JpGEDbtCStPbdOk4F/XrbHR5a70j16oLaSoi25CAcaaEwjoU6Qa+Gm2pU7+6MGAhm50dcaimDREQARH4IgQ6EWmn1EUF2a4fuRP9x3+1uWG4tj4W9lPICL0TWLbm8dytpVFeqIlFiISr6LPT2d8v+PXXEDGdcwyw2RbzIo9JQxT7PHu5KdB9bcrDINSf6N0BSP3r4vWIe4p5eZIyyrn7OFMFVxim2XDZZFyB14k5MVxKk22iO7Dhfr4204suTstoGHVWh7UpEbAVcFrn5sFQtrmDfh+ensqv/RbiDIxUjyCGDR5LYZxMKUi2Wi5OAb8vDxu6wpOjMyiqzTD3mQ4baYQHbK7mQgpthnFaw6iLrZwX49MtQfgTDr0QOrKQwlPQMMDGHFUiAiIgAp9CoBORNsPxp16TLWXLk189439QGuGJdSh0k0SOzWYFfPqkeLrKqgIV24SXFcxpx/6V197YbJ42xpKZzTDOok6SVn45TVop1JNNLJSiFTuygPNlUHqAX7q+aQILTbibuuYXAEld7+TReUc5zv7O2RJ8r7+bqdy/DCT1BYCsTxPzend3ds29A7IYp2EcRl0RoJaMfbyv6oW7oG2btbb0ZVSrKGmH56KFLnjUHNGlXjO29YNBC56N/OzoHkRk5/1kOQUQFrpjgSk1GtXvmPtUh9UmzUh0wIYhzWxyZcQ5osseW+UKf1Pw7hRkNqMB1rIb81WJCIiACHwUgU5Efr8T09bfp2+tv0zsNJ1gPl6ueVu/C762OtpaH64vbggL12yE3td3xzWu1VYEriEQDt1rDKqtCIiACNyPwDcXkZvA2TpWXTzY1HBW+dFVy82BzEB9TPmjd8fHUJKXTyTwzY64TyQp1yIgAh9DQCLSnkeTLoO264a3Qv+4quVOQG4F9jI7j9sdl+WrVg9E4FsecQ/EX6GKgAhcRkAisj3U8DKCaiUCIiACIiACIiACP5CARKREpAiIgAiIgAiIgAiIwGYCEpGbkf3APzWUsgiIgAiIgAiIgAg4AhKREpEiIAIiIAIiIAIiIAKbCcQisntd7Ec9bcjJW30VAREQAREQAREQARH4sgS8iGzPxaVHVZcHMteHHt8kmdOtsuVz06fq3CQ2GREBERABERABERABEVgm0InI8rKE0wseWNill1Ich9d5Ldtd3suPQwve0KC1TxEQAREQAREQAREQga9NgESkvVwrvXr49wGv9rI1yLQAae/4utVKJBwlNLe0/LVZLwtr7RUBERABERABERCBByJAIrK8xfh5v39mEZmTuaXU+31oerS81ra9LPiB2ClUERABERABERABEfixBDoR+e/t3cRi+jgduUZE8u8pzcZs5TKJyD+2Hrnb7Q4vb696XeyPHX9KXAREQAREQARE4EEJeBH5z9Yjn4+/k8KjX0auEZFrEbjVR1OTWoncfF/9Wtq6xC8CIiACIiACIiACdyAQiMj8fB+nGt3XUMGsXYnsfxP5j69u3yHDMFQVioAIiIAIiIAIiIAIXENgEJF/fz2ly9D2CJ47rUTmH1/Wi93Hp527dH5NPmorAiIgAiIgAiIgAiLwAQRIRJarzPknkU1Btgc65j1V/F0ZHMxKQV5JUs1FQAREQAREQARE4OMJkIjMl5JPUpIWID8+IHkUAREQAREQAREQARH4+gS8iPxzDJ7v8/XTUIQiIAIiIAIiIAIiIAIfScCLyI/0LV8iIAIiIAIiIAIiIAIPSkAiUs/WEQEREAEREAEREAER2ExAInIzsgf9c0Fhi4AIiIAIiIAIiMANCUhESkSKgAiIgAiIgAiIgAhsJiARuRnZDSW8TImACIiACIiACIjAgxLwIvIFr525+HmQ7XmTz8e/myWa+b/Y9U1eeKM36FSM+d1Fm0b2y/6Oj44/PVt0/3vziOKQMLovsLOJgyqLgAiIgAiIwLcnEIhI9/RvPBW8PGv8+N8ylNM8fc0MfQ8RucGmeyVjlVPLKX+VvRZ8leB5uz453v6fpLm9vpI+1lOTmv/e3te869LlzorN7cpfz1YIW+XC60XkNXYWAtMuERABERABEfiBBM6LyAxl7csJTZEcvhBHWxY9HI/PK1c316b5JcWlaaz9IczUFpjTM+TPPgcUNXMnbtV8Z+ufrbAweCQiF+BolwiIgAiIgAh8MIELReTx6fn499VW+OxDqjGJNpdDW8us78LJSgKrYnnlEl/dK3Oql7rG9vYeNndO89c9lt/WXCIfLmSHac68j3FaDO3ifrvOOwL5l98nPvBsNRlyJGHzquGfIYXCYVd+WnBWRO5rzcJz3V8FFOc0zda/Jc3o1ZrcTQO6k5f972DUNe91gPU8W0g5qWRn82XxAiSCr10iIAIiIAIi8AMJXCwid7uqNvLq3Uwi8MoW1vnKLy/r2hgvnpmdXgrg8rpphbRroXnYhVlghbu4cFwkS+qkyC8kEnpHakW+5BRMBvkfhsJOrpmzc1nnqMJCDrhtm9RLjiIRyXaWRSTXhPGzkoszAkMuZDioAPt/jgf8drbVjNBxd6Bm6IgLR49nM0Js2hABERABERABEZgRuFxE4oePnfKwuZ8WJt/eu5szqsSxOR5rTv1a15K1WnOheZin2YS7+UrSqC26koXgXdY1TggdjioEYhH23MpPEodCNoXtppNqkNj1z7qgCdnkqK4EkljP9bkmLDTjIbqabK6PymGa/+oqMoy7DfR+iI67AzUDR5OQ4IvtoFAbIiACIiACIiACmwjcWUTadN5/kpiD1BhjhTiwXU4SVXGw0Hw0uP4GEfvdYH/zb6c2qlIMvE/iHA0u3MViyjh9sPKaJddY6HNk77ydNJ/xnAjoU3a86Dur2fXIqCNrp+SoCpxJv8ci0lVO0jZAl674o4NKVK5tvn8oDIki77qVyj1Y7RIBERABERABEZgT+AAR2S1MdlIjCquTLFW3ldm9fg1kXGQKmmAmj1Ahb4zaoiup+izwXgNzcXbNc4S9vnEB5K+2SjvcAh8W5vpQn0WEpv9BbIVqLDfsUNuCpdfQsD/Gk3fZv31GJCKDfg9FJKeGkAJ0UxE5OApDohESGm8ZUU0VioAIiIAIiIAIzAjcWUTm+0WGy6aBDqszN2REjpgVBi5xLjQP81wpIkezrDYQyVgtXTJuyg9xmt/hevTJJq//jQGjOe8KC7lC2a5KN39dStyUVlONCzUZQuCR1GfKt3CYpTk6auI1hZThJFNeHXIkViGNq9ARbHJICJ7toFAbIiACIiACIiACmwicF5E2SdMnL0rxNIzp3By7NbkkDdlCbh7qMK5mDqv0PAmC8qklYfMwbW9zcmG3tB2C5+ZYjZt5H+Osv2ss4cPCaJZLkHhYGKbZCllE9jIx1yGb7YeS+SI7Fi+btWGhsdtVdX+7A33/yjfukK+msLv7plOHZp2XGKWHMdVepvImTBEkj7rAkXVl+vQhAQLsxBkhNW2IgAiIgAiIgAhMCJwXkT9qlnULfid18sPVxkwxP/SoULc+dPcpeBEQAREQgS9CQCKyf16grd61JbofrjZstW957Xbyp8kXGdyzMH54t86wqFwEREAEREAENhEIRGS5Dvgd1cMqNHRF+Ierje7pOY+pF12P4ycHP3yB2WHRVxEQAREQARG4gIAXkReYUBMREAEREAEREAEREIGfRkAisr+c/S3W237aIFa+IiACIvCIBMp1v/5/j5iIYv6xBP4HfCs1GXRpeO0AAAAASUVORK5CYII=
gavin.zheng 发表于 2024-7-31 16:13
叶老师您好，
从你给我的帖子可以判断是内存泄漏了，但是我用命令：gdb --batch --pid 4757 --ex ...
按你的描述，进程内存一直上升，那是不是到了一定时间就会把内存耗尽引发OOM kill了？
目前有发生过这种情况吗，还是说上升到一定程度就不再涨了？ yejr 发表于 2024-8-1 09:17
按你的描述，进程内存一直上升，那是不是到了一定时间就会把内存耗尽引发OOM kill了？
目前有发生过这种 ...
如果发生OOM，内存全会吃光，应用直接不可用了。 yejr 发表于 2024-8-1 09:17
按你的描述，进程内存一直上升，那是不是到了一定时间就会把内存耗尽引发OOM kill了？
目前有发生过这种 ...
会一直上升知道MySQL被OOM掉。
我按照你发的链接安装jemalloc替代glibc，但是好像不管用。我用的系统是ubuntu 22.04。因为用的是MGR架构，所以现在一般两三个月我就重启下VM。
我们另外一套环境用的是MHA内存倒是一直很稳定。但是MHA环境我没有开启以下参数：
#innodb monitor settings
innodb_monitor_enable = "module_innodb"
innodb_monitor_enable = "module_server"
innodb_monitor_enable = "module_dml"
innodb_monitor_enable = "module_ddl"
innodb_monitor_enable = "module_trx"
innodb_monitor_enable = "module_os"
innodb_monitor_enable = "module_purge"
innodb_monitor_enable = "module_log"
innodb_monitor_enable = "module_lock"
innodb_monitor_enable = "module_buffer"
innodb_monitor_enable = "module_index"
innodb_monitor_enable = "module_ibuf_system"
innodb_monitor_enable = "module_buffer_page"
innodb_monitor_enable = "module_adaptive_hash"
内存缓慢上涨会不会和上面这些参数也有关系？ gavin.zheng 发表于 2024-8-1 16:25
会一直上升知道MySQL被OOM掉。
我按照你发的链接安装jemalloc替代glibc，但是好像不管用。我用的系统是ub ...
我看官方好像不建议在生产环境开启这些监控；
这些监控太多了，是否真的有必要开启？直接用show engine innodb status;是否也能达到相同的效果？
有没有合适的监控软件可以直接读取INNODB_METRICS里面的内容？ gavin.zheng 发表于 2024-8-1 16:25
会一直上升知道MySQL被OOM掉。
我按照你发的链接安装jemalloc替代glibc，但是好像不管用。我用的系统是ub ...
那就把这些额外的先都关掉，并换成GreatSQL 8.0.32-25版本试试看，我们预计下周（2024.8.5）发布GreatSQL 8.0.32-26版本，届时也可以关注测试。 yejr 发表于 2024-8-1 17:47
那就把这些额外的先都关掉，并换成GreatSQL 8.0.32-25版本试试看，我们预计下周（2024.8.5）发布GreatSQL...
谢谢叶老师。换GreatSQL我需要问下我们领导，看看他的意思，到时候我再给您留言。 reddey 发表于 2024-8-1 09:46
如果发生OOM，内存全会吃光，应用直接不可用了。
的确发生过，但是我们用的MGR，所以down了一台也没关系
页:
[1]
2