登录
注册
开源
企业版
高校版
搜索
帮助中心
使用条款
关于我们
开源
企业版
高校版
私有云
模力方舟
登录
注册
代码拉取完成，页面将自动刷新
捐赠
捐赠前请先登录
取消
前往登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
Watch
不关注
关注所有动态
仅关注版本发行动态
关注但不提醒动态
125
Star
1
Fork
61
src-openEuler
/
mysql
代码
Issues
8
Pull Requests
0
Wiki
统计
流水线
服务
JavaDoc
PHPDoc
质量分析
Jenkins for Gitee
腾讯云托管
腾讯云 Serverless
悬镜安全
阿里云 SAE
Codeblitz
SBOM
我知道了，不再自动展开
更新失败，请稍后重试！
移除标识
内容风险标识
本任务被
标识为内容中包含有代码安全 Bug 、隐私泄露等敏感信息，仓库外成员不可访问
OpenEuler 20.03 部署MySQL 8.0.28 MGR集群之后出现内存泄露导致oom
待办的
#IAG3HM
缺陷
athlonxpgzw
创建于
2024-07-29 09:32
**【标题描述】能够简要描述问题：说明什么场景下，做了什么操作，出现什么问题（尽量使用正向表达方式）** 在kvm虚拟机部署三节点MySQL mgr集群场景下，出现内存泄露，主从节点均出现泄露情况。最终导致oom。 **一、缺陷信息** **内核信息：** Linux 4.19.90-2211.2.0.0176.oe1.x86_64 #1 SMP Wed Nov 9 11:00:21 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux **缺陷归属组件：** mysql-server **缺陷归属的版本：** mysql-server-8.0.28-4.oe2003sp4.x86_64 **缺陷简述：** 在kvm虚拟机部署三节点MySQL mgr集群场景下，出现内存泄露，主从节点均出现泄露情况。最终导致oom。 **【环境信息】** 硬件信息 - 虚拟机场景 4 vCPU、8GB内存、120GB磁盘 软件信息 - OS版本及分支信息 BigCloud Enterprise Linux For Euler release 21.10 (LTS-SP2)，基于openEuler 20.03 LTS - 内核信息 4.19.90-2211.2.0.0176.oe1.x86_64 - 发现问题的组件版本信息 mysql-server-8.0.28-4.oe2003sp4.x86_64 glibc-2.28-79.oe1.x86_64 网络信息 VPC内二层组网 **【问题复现步骤】**，请描述具体的操作步骤 数据库集群正常运行即出现内存泄露。 **【实际结果】**，请描述出问题的结果和影响 MySQL实例被oom killed **【其他相关附件信息】** **dmesg信息** ： [351914.748721] lowmem_reserve[]: 0 0 4958 4958 4958 [351914.748723] Node 0 Normal free:74716kB min:74964kB low:93704kB high:112444kB active_anon:4753156kB inactive_anon:131944kB active_file:184kB inactive_file:7812kB unevictable:0kB writepending:0kB present:5242880kB managed:5084440kB mlocked:0kB kernel_stack:4192kB pagetables:12140kB bounce:0kB free_pcp:1116kB local_pcp:248kB free_cma:0kB [351914.748726] lowmem_reserve[]: 0 0 0 0 0 [351914.748728] Node 0 DMA: 1*4kB (U) 0*8kB 0*16kB 1*32kB (U) 2*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15908kB [351914.748735] Node 0 DMA32: 150*4kB (UM) 561*8kB (UM) 495*16kB (UME) 177*32kB (UME) 78*64kB (UME) 41*128kB (UME) 25*256kB (UME) 14*512kB (UME) 15*1024kB (UM) 0*2048kB 0*4096kB = 57840kB [351914.748742] Node 0 Normal: 1073*4kB (UME) 682*8kB (UE) 764*16kB (UME) 421*32kB (UME) 199*64kB (UME) 75*128kB (UME) 23*256kB (UME) 10*512kB (UME) 6*1024kB(UE) 0*2048kB 0*4096kB = 74932kB [351914.748750] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB [351914.748751] 102373 total pagecache pages [351914.748752] 0 pages in swap cache [351914.748754] Swap cache stats: add 0, delete 0, find 0/0 [351914.748754] Free swap = 0kB [351914.748755] Total swap = 0kB [351914.748756] 2097014 pages RAM [351914.748756] 0 pages HighMem/MovableOnly [351914.748757] 187095 pages reserved [351914.748757] 0 pages hwpoisoned [351914.748758] Tasks state (memory values in pages): [351914.748758] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name [351914.748765] [ 448] 0 448 13790 4062 135168 0 -250 systemd-journal [351914.748768] [ 470] 0 470 7561 415 81920 0 -1000 systemd-udevd [351914.748770] [ 475] 0 475 4630 172 65536 0 -1000 auditd [351914.748773] [ 489] 192 489 4685 236 77824 0 0 systemd-network [351914.748775] [ 534] 81 534 1871 230 57344 0 -900 dbus-daemon [351914.748777] [ 535] 0 535 134333 715 151552 0 0 NetworkManager [351914.748779] [ 536] 0 536 19004 17 53248 0 0 gapd [351914.748781] [ 575] 1002 575 181583 3420 126976 0 0 node_exporter [351914.748783] [ 576] 996 576 676178 1006 208896 0 0 polkitd [351914.748785] [ 578] 0 578 77986 717 106496 0 0 rngd [351914.748787] [ 603] 995 603 19663 70 53248 0 0 chronyd [351914.748789] [ 620] 0 620 4582 256 69632 0 0 systemd-logind [351914.748794] [ 623] 0 623 20006 78 57344 0 -500 irqbalance [351914.748797] [ 708] 0 708 2982 227 65536 0 -1000 sshd [351914.748800] [ 716] 0 716 117708 3251 151552 0 0 tuned [351914.748801] [ 718] 0 718 53654 92 61440 0 0 crond [351914.748803] [ 769] 0 769 2184 335 57344 0 0 dhclient [351914.748805] [ 802] 0 802 131790 4921 380928 0 0 rsyslogd [351914.748807] [ 1103] 0 1103 53124 28 49152 0 0 agetty [351914.748811] [ 201415] 0 201415 53214 27 53248 0 0 agetty [351914.748813] [ 289175] 1003 289175 4992 351 77824 0 0 systemd [351914.748815] [ 289177] 1003 289177 45221 745 110592 0 0 (sd-pam) [351914.748818] [ 297874] 1011 297874 2382587 1715356 14303232 0 0 mysqld [351914.748820] [ 300277] 0 300277 53442 69 53248 0 0 sh [351914.748822] [ 647240] 0 647240 53423 100 49152 0 0 screen [351914.748825] [ 647241] 0 647241 53761 368 65536 0 0 bash [351914.748827] [ 647529] 0 647529 352446 7368 331776 0 0 sysbench [351914.748829] [ 650523] 0 650523 53475 90 61440 0 0 sh [351914.748832] [ 661443] 0 661443 3389 316 69632 0 0 sshd [351914.748834] [ 661445] 1003 661445 3454 393 69632 0 0 sshd [351914.748836] [ 661446] 1003 661446 53727 340 61440 0 0 bash [351914.748838] [ 661618] 0 661618 580 25 40960 0 0 sshpass [351914.748840] [ 661619] 0 661619 54760 196 69632 0 0 ssh [351914.748842] [ 661621] 0 661621 3314 312 69632 0 0 sshd [351914.748844] [ 661818] 0 661818 53093 16 57344 0 0 sleep [351914.748845] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysqld-3316.service,task=mysqld,pid=297874,uid=1011 [351914.748857] Out of memory: Kill process 297874 (mysqld) score 899 or sacrifice child [351914.750580] Killed process 297874 (mysqld) total-vm:9530348kB, anon-rss:6861424kB, file-rss:0kB, shmem-rss:0kB [351914.810159] oom_reaper: reaped process 297874 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB **/var/log/message** Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748292] ib_io_wr-7 invoked oom-killer: gfp_mask=0x6200ca(GFP_HIGHUSER_MOVABLE), order=0, oom_score_adj=0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748299] CPU: 2 PID: 297900 Comm: ib_io_wr-7 Kdump: loaded Not tainted 4.19.90-2211.2.0.0176.oe1.x86_64 #1 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748301] Hardware name: QingCloud E3, BIOS rel-1.13.0-48-gd9c812dda519-prebuilt.qemu.org 04/01/2014 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748302] Call Trace: Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748334] dump_stack+0x66/0x8b Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748340] dump_header+0x54/0x31c Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748348] ? do_try_to_free_pages+0x2d8/0x370 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748351] ? ___ratelimit+0x8f/0x100 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748352] oom_kill_process+0x259/0x280 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748355] out_of_memory+0x117/0x520 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748358] __alloc_pages_slowpath+0x991/0xd90 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748361] __alloc_pages_nodemask+0x2a8/0x2d0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748366] filemap_fault+0x35e/0x8a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748370] ? enqueue_task_fair+0xaa/0xb10 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748375] ? _raw_spin_lock+0x1d/0x20 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748380] ? alloc_set_pte+0x39d/0x450 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748382] ? _cond_resched+0x15/0x40 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748597] __xfs_filemap_fault+0x72/0x200 [xfs] Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748615] __do_fault+0x33/0x110 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748618] do_fault+0x12e/0x490 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748621] __handle_mm_fault+0x613/0x690 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748623] handle_mm_fault+0xc4/0x200 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748629] __do_page_fault+0x2ba/0x4d0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748635] ? __audit_syscall_exit+0x228/0x290 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748637] do_page_fault+0x31/0x130 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748640] ? async_page_fault+0x8/0x30 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748642] async_page_fault+0x1e/0x30 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748649] RIP: 0033:0x7fa317d6a310 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748659] Code: Bad RIP value. Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748660] RSP: 002b:00007fa1dcdd3948 EFLAGS: 00010202 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748665] RAX: 0000000000000000 RBX: 00007fa22c0dd268 RCX: 000055fcff299f28 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748666] RDX: 0000000000000001 RSI: 0000000000000000 RDI: 00007fa22c0dd3a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748668] RBP: 00007fa1dcdd3a10 R08: 0000000000001635 R09: 0000000000000006 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748669] R10: 00007fa30031b890 R11: 0000000000000206 R12: 00007fa22c0dd3a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748670] R13: 0000000000000006 R14: 00007fa22c0dd3a0 R15: 0000000000000000 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748694] Mem-Info: Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748704] active_anon:1795706 inactive_anon:43223 isolated_anon:0#012 active_file:90 inactive_file:3110 isola ted_file:51#012 unevictable:0 dirty:0 writeback:0 unstable:0#012 slab_reclaimable:4902 slab_unreclaimable:7005#012 mapped:4212 shmem:99031 pagetables:4080 bounce:0#012 free:36963 free_pcp:439 free_cma:0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748711] Node 0 active_anon:7182824kB inactive_anon:172892kB active_file:360kB inactive_file:12440kB unevictable:0kB isolated(anon):0kB isolated(file):204kB mapped:16848kB dirty:0kB writeback:0kB shmem:396124kB shmem_thp: 0kB shmem_pmdmapped: 0kB anon_thp: 6557696kB writeback_tmp:0kB unstable:0kB all_unreclaimable? no Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748712] Node 0 DMA free:15908kB min:232kB low:288kB high:344kB active_anon:0kB inactive_anon:0kB active_fil e:0kB inactive_file:0kB unevictable:0kB writepending:0kB present:15992kB managed:15908kB mlocked:0kB kernel_stack:0kB pagetables:0kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748716] lowmem_reserve[]: 0 2454 7413 7413 7413 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748718] Node 0 DMA32 free:57228kB min:37440kB low:46800kB high:56160kB active_anon:2429668kB inactive_anon:40948kB active_file:176kB inactive_file:5312kB unevictable:0kB writepending:0kB present:3129184kB managed:2539328kB mlocked:0kB kernel_stack:32kB pagetables:4180kB bounce:0kB free_pcp:640kB local_pcp:248kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748721] lowmem_reserve[]: 0 0 4958 4958 4958 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748723] Node 0 Normal free:74716kB min:74964kB low:93704kB high:112444kB active_anon:4753156kB inactive_anon:131944kB active_file:184kB inactive_file:7812kB unevictable:0kB writepending:0kB present:5242880kB managed:5084440kB mlocked:0kB kernel_stack:4192kB pagetables:12140kB bounce:0kB free_pcp:1116kB local_pcp:248kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748726] lowmem_reserve[]: 0 0 0 0 0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748728] Node 0 DMA: 1*4kB (U) 0*8kB 0*16kB 1*32kB (U) 2*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15908kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748735] Node 0 DMA32: 150*4kB (UM) 561*8kB (UM) 495*16kB (UME) 177*32kB (UME) 78*64kB (UME) 41*128kB (UME)25*256kB (UME) 14*512kB (UME) 15*1024kB (UM) 0*2048kB 0*4096kB = 57840kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748742] Node 0 Normal: 1073*4kB (UME) 682*8kB (UE) 764*16kB (UME) 421*32kB (UME) 199*64kB (UME) 75*128kB (UME) 23*256kB (UME) 10*512kB (UME) 6*1024kB (UE) 0*2048kB 0*4096kB = 74932kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748750] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748751] 102373 total pagecache pages Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748752] 0 pages in swap cache Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748754] Swap cache stats: add 0, delete 0, find 0/0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748754] Free swap = 0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748755] Total swap = 0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748756] 2097014 pages RAM Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748756] 0 pages HighMem/MovableOnly Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748757] 187095 pages reserved Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748757] 0 pages hwpoisoned Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748758] Tasks state (memory values in pages): Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748758] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748765] [ 448] 0 448 13790 4062 135168 0 -250 systemd-journal Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748768] [ 470] 0 470 7561 415 81920 0 -1000 systemd-udevd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748770] [ 475] 0 475 4630 172 65536 0 -1000 auditd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748773] [ 489] 192 489 4685 236 77824 0 0 systemd-network Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748775] [ 534] 81 534 1871 230 57344 0 -900 dbus-daemon Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748777] [ 535] 0 535 134333 715 151552 0 0 NetworkManager Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748779] [ 536] 0 536 19004 17 53248 0 0 gapd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748781] [ 575] 1002 575 181583 3420 126976 0 0 node_exporter Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748783] [ 576] 996 576 676178 1006 208896 0 0 polkitd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748785] [ 578] 0 578 77986 717 106496 0 0 rngd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748787] [ 603] 995 603 19663 70 53248 0 0 chronyd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748789] [ 620] 0 620 4582 256 69632 0 0 systemd-logind Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748794] [ 623] 0 623 20006 78 57344 0 -500 irqbalance Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748797] [ 708] 0 708 2982 227 65536 0 -1000 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748800] [ 716] 0 716 117708 3251 151552 0 0 tuned Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748801] [ 718] 0 718 53654 92 61440 0 0 crond Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748803] [ 769] 0 769 2184 335 57344 0 0 dhclient Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748805] [ 802] 0 802 131790 4921 380928 0 0 rsyslogd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748807] [ 1103] 0 1103 53124 28 49152 0 0 agetty Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748811] [ 201415] 0 201415 53214 27 53248 0 0 agetty Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748813] [ 289175] 1003 289175 4992 351 77824 0 0 systemd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748815] [ 289177] 1003 289177 45221 745 110592 0 0 (sd-pam) Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748818] [ 297874] 1011 297874 2382587 1715356 14303232 0 0 mysqld Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748820] [ 300277] 0 300277 53442 69 53248 0 0 sh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748822] [ 647240] 0 647240 53423 100 49152 0 0 screen Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748825] [ 647241] 0 647241 53761 368 65536 0 0 bash Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748827] [ 647529] 0 647529 352446 7368 331776 0 0 sysbench Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748829] [ 650523] 0 650523 53475 90 61440 0 0 sh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748832] [ 661443] 0 661443 3389 316 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748834] [ 661445] 1003 661445 3454 393 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748836] [ 661446] 1003 661446 53727 340 61440 0 0 bash Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748838] [ 661618] 0 661618 580 25 40960 0 0 sshpass Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748840] [ 661619] 0 661619 54760 196 69632 0 0 ssh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748842] [ 661621] 0 661621 3314 312 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748844] [ 661818] 0 661818 53093 16 57344 0 0 sleep Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748845] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysqld-3316.service,task=mysqld,pid=297874,uid=1011 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748857] Out of memory: Kill process 297874 (mysqld) score 899 or sacrifice child Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.750580] Killed process 297874 (mysqld) total-vm:9530348kB, anon-rss:6861424kB, file-rss:0kB, shmem-rss:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.810159] oom_reaper: reaped process 297874 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Main process exited, code=killed, status=9/KILL Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Failed with result 'signal'. **oom之后的mysqld服务状态** # systemctl status mysqld-3316 ● mysqld-3316.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld-3316.service; disabled; vendor preset: disabled) Active: failed (Result: signal) since Fri 2024-07-26 11:09:39 CST; 41min ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 297874 ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my-3316.cnf (code=killed, signal=KILL) Main PID: 297874 (code=killed, signal=KILL) Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Main process exited, code=killed, status=9/KILL Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Failed with result 'signal'. **oom发生之后系统内存的信息** ： # free total used free shared buff/cache available Mem: 7639676 170340 6873624 396136 595712 6769084 Swap: 0 0 0 **数据库配置：** 版本：MySQL 8.0.28-4 架构：innodb cluster **MySQL数据库配置文件内容** ： [mysql] auto-rehash socket =/app/mysql/data/3316/tmp/mysql-3316.sock # /tmp/mysql.sock [mysqld] ####: from template 128G max_connections = 200 binlog_expire_logs_seconds = 86400 table_open_cache = 8000 table_definition_cache = 8000 table_open_cache_instances = 64 thread_cache_size = 3000 innodb_log_buffer_size = 32M innodb_log_file_size = 2G innodb_buffer_pool_instances =8 innodb_log_files_in_group = 3 innodb_max_undo_log_size = 4G innodb_buffer_pool_size=4G thread_stack = 512K external-locking = FALSE tmp_table_size = 96M max_heap_table_size = 96M ####: for global user =mcs-mysql server_id =52249 # 1 #basedir =/usr/local/mysql-8.0.28-linux-glibc2.12-x86_64 # /usr/local/mysql/ datadir =/app/mysql/data/3316/data # /usr/local/mysql/data/ max_prepared_stmt_count =1048576 # 16382 open_files_limit =102000 # 65536 port =3316 # 3306 mysqlx_port =33160 # 33060 mysqlx_socket = /app/mysql/data/3316/tmp/mysql-3316x.sock admin_address =127.0.0.1 admin_port =33162 # 33062 socket =/app/mysql/data/3316/tmp/mysql-3316.sock # /tmp/mysql.sock skip_name_resolve =1 # 0 super_read_only =OFF # OFF sql_require_primary_key =OFF # OFF cte_max_recursion_depth =1000 # 1000 log_timestamps =system # UTC lower_case_table_names =1 # 0 auto_increment_increment =1 # 1 auto_increment_offset =1 # 1 lock_wait_timeout =31536000 # ! event_scheduler =OFF # ON auto_generate_certs =ON # ON big_tables =OFF # OFF join_buffer_size =16M # 0.25M activate_all_roles_on_login =ON # OFF end_markers_in_json =OFF # OFF tmpdir =/app/mysql/data/3316/tmp/ autocommit =ON # ON sort_buffer_size =16M # 262144(256k) back_log = 1024 max_connect_errors = 10000000000000 innodb_undo_tablespaces = 95 ############### slow_query_log_file = /app/mysql/data/3316/log/slow.log log_error = /app/mysql/data/3316/log/error.log log_bin = /app/mysql/data/3316/binlog/mybinlog log_bin_index = /app/mysql/data/3316/binlog/mybinlog.index ################# ####: for net max_allowed_packet =1G # 64M bind_address =* # * interactive_timeout =28800 # 28800 wait_timeout = 28800 ####: for logs log_output =FILE # FILE ## -- general log general_log =OFF # OFF general_log_file =general.log # $(hotname).log ## -- error log log_statements_unsafe_for_binlog =ON # ! for error 1592 ## -- slow log long_query_time =2.0 # 10.000000 log_queries_not_using_indexes =OFF # OFF log_slow_admin_statements =OFF # OFF log_slow_slave_statements =1 # OFF slow_query_log =ON # OFF #slow_query_log_file =slow.log # slow.log ####: for binlog binlog_checksum =NONE # CRC32 log_bin_trust_function_creators =ON # OFF binlog_direct_non_transactional_updates =OFF # OFF binlog_error_action =ABORT_SERVER # ABORT_SERVER | IGNORE_ERROR binlog_format =ROW # ROW | STATEMENT | MIXED max_binlog_stmt_cache_size =1G # 18446744073709547520 max_binlog_cache_size =2G # 18446744073709547520(1G) max_binlog_size =1G binlog_order_commits =ON # ON binlog_row_image =FULL # FULL | MINIMAL | NOBLOB binlog_row_metadata =MINIMAL # MINIMAL | FULL binlog_rows_query_log_events =ON # OFF log_slave_updates =ON # ON binlog_stmt_cache_size =32k # 32768(32k) sync_binlog =1 # 1 | 0 | N binlog_group_commit_sync_delay =500 # 0 binlog_group_commit_sync_no_delay_count =10 # 0 binlog_cache_size =4M # 32768(32k) binlog_transaction_dependency_history_size =25000 # 25000 binlog_transaction_dependency_tracking =WRITESET # COMMIT_ORDER | WRITESET | WRITESET_SESSION relay_log_recovery = 1 relay-log-purge = 1 key_buffer_size = 32M read_buffer_size = 8M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G explicit_defaults_for_timestamp = 1 transaction_isolation = REPEATABLE-READ #myisam_repair_threads = 1 # some var for MySQL 8 log_error_verbosity = 3 innodb_print_ddl_logs = 1 ####: for replication ## -- replication master master_info_repository =table # TABLE | FILE sync_master_info =10000 # 10000 # ##rpl_semi_sync_master_timeout =1000 # 1000(1 second) plugin_load_add =semisync_master.so plugin_load_add =group_replication.so ##rpl_semi_sync_master_enabled =1 # 0 ## -- replication slave relay_log_info_repository =table # file skip_slave_start =0 # 0 slave_parallel_type =logical_clock # database | LOGICAL_CLOCK slave_parallel_workers =4 # 0 slave_max_allowed_packet =1073741824 # 1073741824 slave_load_tmpdir =/app/mysql/data/3316/tmp # /tmp/ sync_relay_log =10000 # 10000 sync_relay_log_info =10000 # 10000 plugin_load_add =semisync_slave.so # ##rpl_semi_sync_slave_enabled =1 # 0 slave-preserve-commit-order =ON # ####: for gtid binlog_gtid_simple_recovery =ON # ON enforce_gtid_consistency =ON # ON gtid_executed_compression_period =1000 # 1000 gtid_mode =ON # OFF ####: for storage engine default_storage_engine =innodb # InnoDB default_tmp_storage_engine =innodb # InnoDB internal_tmp_mem_storage_engine =TempTable # TempTable ####: for innodb ## disk I/O and file space management innodb_data_home_dir =/app/mysql/data/3316/data # ./ innodb_data_file_path =ibdata1:1G:autoextend # ibdata1:12M:autoextend innodb_page_size =16k # 16384(16k) innodb_default_row_format =dynamic # dynamic | compact | redundant innodb_log_group_home_dir =/app/mysql/data/3316/data # ./ innodb_redo_log_encrypt =OFF # OFF innodb_online_alter_log_max_size =4G # 134217728(128M) innodb_undo_directory =/app/mysql/data/3316/undolog # ./ innodb_undo_log_encrypt =OFF # OFF innodb_undo_log_truncate =ON # ON innodb_rollback_on_timeout =1 # OFF innodb_rollback_segments =128 # 128 [1~128] innodb_log_checksums =ON # ON innodb_checksum_algorithm =crc32 # crc32 innodb_log_compressed_pages =ON # ON innodb_doublewrite =ON # ON ! do not disable it please. innodb_commit_concurrency =0 # 0 ## configuring innodb readonly innodb_read_only =OFF # OFF ## configuring innodb dedicated server innodb_dedicated_server =OFF # OFF ! related to mysql auto config please donot chanage ## configuring innodb buffer pool size and instances innodb_buffer_pool_chunk_size =128M # 134217728(128M) ## making the buffer pool scan resistant innodb_old_blocks_pct =37 # 37 innodb_old_blocks_time =1000 # 1000 ## configuring innodb buffer pool prefetching(read ahead) innodb_random_read_ahead =off # OFF innodb_read_ahead_threshold =56 # 56 ## configuring innodb buffer pool flushing innodb_max_dirty_pages_pct_lwm =20 # 10 innodb_max_dirty_pages_pct =60 # 90 ## fine-tuning innodb buffer pool flushing innodb_flush_neighbors =0 # off | on (off for ssd ,on for hdd) innodb_lru_scan_depth =4000 # 1024 ## tuning for sharp checkpoint innodb_adaptive_flushing =ON # ON innodb_adaptive_flushing_lwm =10 # 10 innodb_flushing_avg_loops =30 # 30(a heih value means adaptive flushing is slow) ## saving and restoring the buffer pool state innodb_buffer_pool_dump_pct =50 # 50 innodb_buffer_pool_dump_at_shutdown =ON # ON innodb_buffer_pool_load_at_startup =ON # ON innodb_buffer_pool_filename =ib_buffer_pool # ib_buffer_pool innodb_stats_persistent =ON # ON innodb_stats_on_metadata =ON # OFF innodb_stats_method =nulls_equal # nulls_equal innodb_stats_auto_recalc =ON # ON innodb_stats_include_delete_marked =ON # ON innodb_stats_persistent_sample_pages=20 # 20 innodb_stats_transient_sample_pages =8 # 8 innodb_status_output =OFF # OFF innodb_status_output_locks =1 # OFF innodb_buffer_pool_dump_now =OFF # OFF innodb_buffer_pool_load_abort =OFF # OFF innodb_buffer_pool_load_now =OFF # OFF ## configuring thread concurrency for innodb innodb_thread_concurrency =0 # 0 #? if innodb_thread_concurrency is 0, the value of innodb_thread_sleep_delay is ignored; #? so default the next 3 are ignored. innodb_concurrency_tickets =5000 # 5000 innodb_thread_sleep_delay =15000 # 10000 ( 1/100 s) innodb_adaptive_max_sleep_delay =150000 # 150000 (15/100 s) ## configuring the number of background innoDB i/o threads #? if you see more than 64 × innodb_read_io_threads pending read requests in #? SHOW ENGINE INNODB STATUS output, you might improve performance #? by increasing the value of innodb_read_io_threads. innodb_read_io_threads =8 # 4 innodb_write_io_threads =8 # 4 ## using asynchronous i/o on linux #? 1):perform read-ahead and write requests for data file pages. #? 2):Too many I/O write requests dispatched to the operating system for parallel processing could, #? in some cases, result in I/O read starvation innodb_use_native_aio =ON # ON ## configuring the innodb master thread i/o rate innodb_flush_sync =OFF # ON #? To adhere to the limit on InnoDB background I/O activity defined by the innodb_io_capacity setting, #? disable innodb_flush_sync. innodb_io_capacity =8000 # 200 innodb_io_capacity_max =10000 # 2000 ## configuring spin lock polling innodb_spin_wait_delay =6 # 6 ## configuring innoDB purge scheduling innodb_purge_threads =4 # 4 innodb_purge_batch_size =300 # 300(300 undo log page) innodb_purge_rseg_truncate_frequency=128 # 128 ## -- Lock & Wait innodb_deadlock_detect =ON # ON innodb_autoinc_lock_mode =2 # 0 | 1 | 2 innodb_print_all_deadlocks =ON # OFF innodb_lock_wait_timeout =50 # 50 innodb_table_locks =ON # ON innodb_sync_array_size =1 # 1 innodb_sync_spin_loops =30 # 30 ## innodb others innodb_print_ddl_logs =OFF # OFF innodb_replication_delay =0 # 0 innodb_cmp_per_index_enabled =OFF # ! do not enable it please. innodb_disable_sort_file_cache =OFF # OFF innodb_numa_interleave =OFF # OFF innodb_strict_mode =ON # ON innodb_sort_buffer_size =1M # 1M(global and only for full-text search) innodb_fast_shutdown =1 # 0 | 1 | 2 innodb_force_load_corrupted =OFF # OFF innodb_force_recovery =0 # 0 | 1 | 2 | 3 | 4 | 5 | 6 innodb_temp_tablespaces_dir =/app/mysql/data/3316/tmp/#innodb_temp/ # ./#innodb_temp/ innodb_tmpdir =/app/mysql/data/3316/tmp # ! the sort file temp dir of alter table opration innodb_temp_data_file_path =ibtmp1:2048M:autoextend # ibtmp1:12M:autoextend ! stores rollback segments for changes made to user-created temporary tables. innodb_page_cleaners =4 # 1 ## adaptive hash index innodb_adaptive_hash_index =ON # ON innodb_adaptive_hash_index_parts =8 # 8 ## -- Flush & Io innodb_flush_log_at_timeout =1 # 1 innodb_flush_log_at_trx_commit =1 # 1 | 0 | 2 innodb_flush_method =O_DIRECT # fsync | o_direct innodb_fsync_threshold =0 # 0 ~ 2**64-1 innodb_change_buffer_max_size =25 # 25 innodb_change_buffering =all # all | none | inserts | deletes | changes | purges ####: others div_precision_increment =4 # 4 eq_range_index_dive_limit =200 # 200 explicit_defaults_for_timestamp =ON # ON group_concat_max_len =1024 # 1024 flush =OFF # OFF flush_time =0 # 0 automatic_sp_privileges =ON # ON innodb_fill_factor =90 # 100 innodb_file_per_table =ON # ON innodb_autoextend_increment =64 # 64 innodb_open_files =64000 # 4000 ####: for authentication caching_sha2_password_auto_generate_rsa_keys =ON # ON caching_sha2_password_private_key_path =private_key.pem # private_key.pem caching_sha2_password_public_key_path =public_key.pem # public_key.pem default_authentication_plugin =caching_sha2_password # caching_sha2_password default_password_lifetime =0 # 0 disconnect_on_expired_password =ON # ON ####: for character character_set_server =utf8mb4 # utf8mb4 collation_server =utf8mb4_0900_ai_ci # utf8mb4_0900_ai_ci #### for performance_schema performance_schema =on # on performance_schema_instrument = '%memory%=on' performance_schema_instrument = '%lock%=on' 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" ############## ####: for mysql group replication loose-group_replication_recovery_get_public_key =ON loose-group_replication_recovery_retry_count =10 # 10 loose-group_replication_recovery_reconnect_interval =60 # 60 loose-group_replication_allow_local_disjoint_gtids_join =off # off loose-group_replication_allow_local_lower_version_join =off # off loose-transaction_write_set_extraction =XXHASH64 # off loose-group_replication_group_name=9eac328b-0d8e-4edb-a6b2-cbde736bda15 loose-group_replication_start_on_boot =off # off loose-group_replication_bootstrap_group =off # off loose-group_replication_single_primary_mode =on # on loose-group_replication_enforce_update_everywhere_checks =off loose-group_replication_gtid_assignment_block_size =1000000 # 1000000 loose-group_replication_poll_spin_loops =0 # 0 loose-group_replication_compression_threshold =1024 # 1000000 loose-group_replication_flow_control_mode =QUOTA # QUOTA loose-group_replication_flow_control_applier_threshold =25000 # 25000 loose-group_replication_flow_control_certifier_threshold =25000 # 25000 loose-group_replication_flow_control_hold_percent =10 # 10 loose-group_replication_flow_control_max_commit_quota =0 # 0 loose-group_replication_flow_control_member_quota_percent=0 # 0 loose-group_replication_flow_control_min_quota =0 # 0 loose-group_replication_flow_control_min_recovery_quota =0 # 0 loose-group_replication_flow_control_period =1 # 1 loose-group_replication_flow_control_release_percent =50 # 50 loose-group_replication_transaction_size_limit =0 # 0 loose-group_replication_local_address ="10.176.52.249:13316" report_host ="10.176.52.249" loose-group_replication_group_seeds ="10.176.52.249:13316,10.176.52.250:13316,10.176.52.251:13316" loose-group_replication_ip_whitelist ="10.176.52.249,10.176.52.250,10.176.52.251" ####: for writeset transaction_write_set_extraction = XXHASH64 [client] port=3316 socket=/app/mysql/data/3316/tmp/mysql-3316.sock **缺陷详情参考链接：** **缺陷分析指导链接：** https：xxx
**【标题描述】能够简要描述问题：说明什么场景下，做了什么操作，出现什么问题（尽量使用正向表达方式）** 在kvm虚拟机部署三节点MySQL mgr集群场景下，出现内存泄露，主从节点均出现泄露情况。最终导致oom。 **一、缺陷信息** **内核信息：** Linux 4.19.90-2211.2.0.0176.oe1.x86_64 #1 SMP Wed Nov 9 11:00:21 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux **缺陷归属组件：** mysql-server **缺陷归属的版本：** mysql-server-8.0.28-4.oe2003sp4.x86_64 **缺陷简述：** 在kvm虚拟机部署三节点MySQL mgr集群场景下，出现内存泄露，主从节点均出现泄露情况。最终导致oom。 **【环境信息】** 硬件信息 - 虚拟机场景 4 vCPU、8GB内存、120GB磁盘 软件信息 - OS版本及分支信息 BigCloud Enterprise Linux For Euler release 21.10 (LTS-SP2)，基于openEuler 20.03 LTS - 内核信息 4.19.90-2211.2.0.0176.oe1.x86_64 - 发现问题的组件版本信息 mysql-server-8.0.28-4.oe2003sp4.x86_64 glibc-2.28-79.oe1.x86_64 网络信息 VPC内二层组网 **【问题复现步骤】**，请描述具体的操作步骤 数据库集群正常运行即出现内存泄露。 **【实际结果】**，请描述出问题的结果和影响 MySQL实例被oom killed **【其他相关附件信息】** **dmesg信息** ： [351914.748721] lowmem_reserve[]: 0 0 4958 4958 4958 [351914.748723] Node 0 Normal free:74716kB min:74964kB low:93704kB high:112444kB active_anon:4753156kB inactive_anon:131944kB active_file:184kB inactive_file:7812kB unevictable:0kB writepending:0kB present:5242880kB managed:5084440kB mlocked:0kB kernel_stack:4192kB pagetables:12140kB bounce:0kB free_pcp:1116kB local_pcp:248kB free_cma:0kB [351914.748726] lowmem_reserve[]: 0 0 0 0 0 [351914.748728] Node 0 DMA: 1*4kB (U) 0*8kB 0*16kB 1*32kB (U) 2*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15908kB [351914.748735] Node 0 DMA32: 150*4kB (UM) 561*8kB (UM) 495*16kB (UME) 177*32kB (UME) 78*64kB (UME) 41*128kB (UME) 25*256kB (UME) 14*512kB (UME) 15*1024kB (UM) 0*2048kB 0*4096kB = 57840kB [351914.748742] Node 0 Normal: 1073*4kB (UME) 682*8kB (UE) 764*16kB (UME) 421*32kB (UME) 199*64kB (UME) 75*128kB (UME) 23*256kB (UME) 10*512kB (UME) 6*1024kB(UE) 0*2048kB 0*4096kB = 74932kB [351914.748750] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB [351914.748751] 102373 total pagecache pages [351914.748752] 0 pages in swap cache [351914.748754] Swap cache stats: add 0, delete 0, find 0/0 [351914.748754] Free swap = 0kB [351914.748755] Total swap = 0kB [351914.748756] 2097014 pages RAM [351914.748756] 0 pages HighMem/MovableOnly [351914.748757] 187095 pages reserved [351914.748757] 0 pages hwpoisoned [351914.748758] Tasks state (memory values in pages): [351914.748758] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name [351914.748765] [ 448] 0 448 13790 4062 135168 0 -250 systemd-journal [351914.748768] [ 470] 0 470 7561 415 81920 0 -1000 systemd-udevd [351914.748770] [ 475] 0 475 4630 172 65536 0 -1000 auditd [351914.748773] [ 489] 192 489 4685 236 77824 0 0 systemd-network [351914.748775] [ 534] 81 534 1871 230 57344 0 -900 dbus-daemon [351914.748777] [ 535] 0 535 134333 715 151552 0 0 NetworkManager [351914.748779] [ 536] 0 536 19004 17 53248 0 0 gapd [351914.748781] [ 575] 1002 575 181583 3420 126976 0 0 node_exporter [351914.748783] [ 576] 996 576 676178 1006 208896 0 0 polkitd [351914.748785] [ 578] 0 578 77986 717 106496 0 0 rngd [351914.748787] [ 603] 995 603 19663 70 53248 0 0 chronyd [351914.748789] [ 620] 0 620 4582 256 69632 0 0 systemd-logind [351914.748794] [ 623] 0 623 20006 78 57344 0 -500 irqbalance [351914.748797] [ 708] 0 708 2982 227 65536 0 -1000 sshd [351914.748800] [ 716] 0 716 117708 3251 151552 0 0 tuned [351914.748801] [ 718] 0 718 53654 92 61440 0 0 crond [351914.748803] [ 769] 0 769 2184 335 57344 0 0 dhclient [351914.748805] [ 802] 0 802 131790 4921 380928 0 0 rsyslogd [351914.748807] [ 1103] 0 1103 53124 28 49152 0 0 agetty [351914.748811] [ 201415] 0 201415 53214 27 53248 0 0 agetty [351914.748813] [ 289175] 1003 289175 4992 351 77824 0 0 systemd [351914.748815] [ 289177] 1003 289177 45221 745 110592 0 0 (sd-pam) [351914.748818] [ 297874] 1011 297874 2382587 1715356 14303232 0 0 mysqld [351914.748820] [ 300277] 0 300277 53442 69 53248 0 0 sh [351914.748822] [ 647240] 0 647240 53423 100 49152 0 0 screen [351914.748825] [ 647241] 0 647241 53761 368 65536 0 0 bash [351914.748827] [ 647529] 0 647529 352446 7368 331776 0 0 sysbench [351914.748829] [ 650523] 0 650523 53475 90 61440 0 0 sh [351914.748832] [ 661443] 0 661443 3389 316 69632 0 0 sshd [351914.748834] [ 661445] 1003 661445 3454 393 69632 0 0 sshd [351914.748836] [ 661446] 1003 661446 53727 340 61440 0 0 bash [351914.748838] [ 661618] 0 661618 580 25 40960 0 0 sshpass [351914.748840] [ 661619] 0 661619 54760 196 69632 0 0 ssh [351914.748842] [ 661621] 0 661621 3314 312 69632 0 0 sshd [351914.748844] [ 661818] 0 661818 53093 16 57344 0 0 sleep [351914.748845] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysqld-3316.service,task=mysqld,pid=297874,uid=1011 [351914.748857] Out of memory: Kill process 297874 (mysqld) score 899 or sacrifice child [351914.750580] Killed process 297874 (mysqld) total-vm:9530348kB, anon-rss:6861424kB, file-rss:0kB, shmem-rss:0kB [351914.810159] oom_reaper: reaped process 297874 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB **/var/log/message** Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748292] ib_io_wr-7 invoked oom-killer: gfp_mask=0x6200ca(GFP_HIGHUSER_MOVABLE), order=0, oom_score_adj=0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748299] CPU: 2 PID: 297900 Comm: ib_io_wr-7 Kdump: loaded Not tainted 4.19.90-2211.2.0.0176.oe1.x86_64 #1 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748301] Hardware name: QingCloud E3, BIOS rel-1.13.0-48-gd9c812dda519-prebuilt.qemu.org 04/01/2014 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748302] Call Trace: Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748334] dump_stack+0x66/0x8b Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748340] dump_header+0x54/0x31c Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748348] ? do_try_to_free_pages+0x2d8/0x370 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748351] ? ___ratelimit+0x8f/0x100 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748352] oom_kill_process+0x259/0x280 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748355] out_of_memory+0x117/0x520 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748358] __alloc_pages_slowpath+0x991/0xd90 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748361] __alloc_pages_nodemask+0x2a8/0x2d0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748366] filemap_fault+0x35e/0x8a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748370] ? enqueue_task_fair+0xaa/0xb10 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748375] ? _raw_spin_lock+0x1d/0x20 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748380] ? alloc_set_pte+0x39d/0x450 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748382] ? _cond_resched+0x15/0x40 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748597] __xfs_filemap_fault+0x72/0x200 [xfs] Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748615] __do_fault+0x33/0x110 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748618] do_fault+0x12e/0x490 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748621] __handle_mm_fault+0x613/0x690 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748623] handle_mm_fault+0xc4/0x200 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748629] __do_page_fault+0x2ba/0x4d0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748635] ? __audit_syscall_exit+0x228/0x290 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748637] do_page_fault+0x31/0x130 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748640] ? async_page_fault+0x8/0x30 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748642] async_page_fault+0x1e/0x30 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748649] RIP: 0033:0x7fa317d6a310 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748659] Code: Bad RIP value. Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748660] RSP: 002b:00007fa1dcdd3948 EFLAGS: 00010202 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748665] RAX: 0000000000000000 RBX: 00007fa22c0dd268 RCX: 000055fcff299f28 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748666] RDX: 0000000000000001 RSI: 0000000000000000 RDI: 00007fa22c0dd3a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748668] RBP: 00007fa1dcdd3a10 R08: 0000000000001635 R09: 0000000000000006 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748669] R10: 00007fa30031b890 R11: 0000000000000206 R12: 00007fa22c0dd3a0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748670] R13: 0000000000000006 R14: 00007fa22c0dd3a0 R15: 0000000000000000 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748694] Mem-Info: Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748704] active_anon:1795706 inactive_anon:43223 isolated_anon:0#012 active_file:90 inactive_file:3110 isola ted_file:51#012 unevictable:0 dirty:0 writeback:0 unstable:0#012 slab_reclaimable:4902 slab_unreclaimable:7005#012 mapped:4212 shmem:99031 pagetables:4080 bounce:0#012 free:36963 free_pcp:439 free_cma:0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748711] Node 0 active_anon:7182824kB inactive_anon:172892kB active_file:360kB inactive_file:12440kB unevictable:0kB isolated(anon):0kB isolated(file):204kB mapped:16848kB dirty:0kB writeback:0kB shmem:396124kB shmem_thp: 0kB shmem_pmdmapped: 0kB anon_thp: 6557696kB writeback_tmp:0kB unstable:0kB all_unreclaimable? no Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748712] Node 0 DMA free:15908kB min:232kB low:288kB high:344kB active_anon:0kB inactive_anon:0kB active_fil e:0kB inactive_file:0kB unevictable:0kB writepending:0kB present:15992kB managed:15908kB mlocked:0kB kernel_stack:0kB pagetables:0kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748716] lowmem_reserve[]: 0 2454 7413 7413 7413 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748718] Node 0 DMA32 free:57228kB min:37440kB low:46800kB high:56160kB active_anon:2429668kB inactive_anon:40948kB active_file:176kB inactive_file:5312kB unevictable:0kB writepending:0kB present:3129184kB managed:2539328kB mlocked:0kB kernel_stack:32kB pagetables:4180kB bounce:0kB free_pcp:640kB local_pcp:248kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748721] lowmem_reserve[]: 0 0 4958 4958 4958 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748723] Node 0 Normal free:74716kB min:74964kB low:93704kB high:112444kB active_anon:4753156kB inactive_anon:131944kB active_file:184kB inactive_file:7812kB unevictable:0kB writepending:0kB present:5242880kB managed:5084440kB mlocked:0kB kernel_stack:4192kB pagetables:12140kB bounce:0kB free_pcp:1116kB local_pcp:248kB free_cma:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748726] lowmem_reserve[]: 0 0 0 0 0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748728] Node 0 DMA: 1*4kB (U) 0*8kB 0*16kB 1*32kB (U) 2*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15908kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748735] Node 0 DMA32: 150*4kB (UM) 561*8kB (UM) 495*16kB (UME) 177*32kB (UME) 78*64kB (UME) 41*128kB (UME)25*256kB (UME) 14*512kB (UME) 15*1024kB (UM) 0*2048kB 0*4096kB = 57840kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748742] Node 0 Normal: 1073*4kB (UME) 682*8kB (UE) 764*16kB (UME) 421*32kB (UME) 199*64kB (UME) 75*128kB (UME) 23*256kB (UME) 10*512kB (UME) 6*1024kB (UE) 0*2048kB 0*4096kB = 74932kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748750] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748751] 102373 total pagecache pages Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748752] 0 pages in swap cache Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748754] Swap cache stats: add 0, delete 0, find 0/0 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748754] Free swap = 0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748755] Total swap = 0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748756] 2097014 pages RAM Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748756] 0 pages HighMem/MovableOnly Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748757] 187095 pages reserved Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748757] 0 pages hwpoisoned Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748758] Tasks state (memory values in pages): Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748758] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748765] [ 448] 0 448 13790 4062 135168 0 -250 systemd-journal Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748768] [ 470] 0 470 7561 415 81920 0 -1000 systemd-udevd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748770] [ 475] 0 475 4630 172 65536 0 -1000 auditd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748773] [ 489] 192 489 4685 236 77824 0 0 systemd-network Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748775] [ 534] 81 534 1871 230 57344 0 -900 dbus-daemon Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748777] [ 535] 0 535 134333 715 151552 0 0 NetworkManager Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748779] [ 536] 0 536 19004 17 53248 0 0 gapd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748781] [ 575] 1002 575 181583 3420 126976 0 0 node_exporter Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748783] [ 576] 996 576 676178 1006 208896 0 0 polkitd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748785] [ 578] 0 578 77986 717 106496 0 0 rngd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748787] [ 603] 995 603 19663 70 53248 0 0 chronyd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748789] [ 620] 0 620 4582 256 69632 0 0 systemd-logind Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748794] [ 623] 0 623 20006 78 57344 0 -500 irqbalance Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748797] [ 708] 0 708 2982 227 65536 0 -1000 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748800] [ 716] 0 716 117708 3251 151552 0 0 tuned Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748801] [ 718] 0 718 53654 92 61440 0 0 crond Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748803] [ 769] 0 769 2184 335 57344 0 0 dhclient Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748805] [ 802] 0 802 131790 4921 380928 0 0 rsyslogd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748807] [ 1103] 0 1103 53124 28 49152 0 0 agetty Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748811] [ 201415] 0 201415 53214 27 53248 0 0 agetty Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748813] [ 289175] 1003 289175 4992 351 77824 0 0 systemd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748815] [ 289177] 1003 289177 45221 745 110592 0 0 (sd-pam) Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748818] [ 297874] 1011 297874 2382587 1715356 14303232 0 0 mysqld Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748820] [ 300277] 0 300277 53442 69 53248 0 0 sh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748822] [ 647240] 0 647240 53423 100 49152 0 0 screen Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748825] [ 647241] 0 647241 53761 368 65536 0 0 bash Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748827] [ 647529] 0 647529 352446 7368 331776 0 0 sysbench Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748829] [ 650523] 0 650523 53475 90 61440 0 0 sh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748832] [ 661443] 0 661443 3389 316 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748834] [ 661445] 1003 661445 3454 393 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748836] [ 661446] 1003 661446 53727 340 61440 0 0 bash Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748838] [ 661618] 0 661618 580 25 40960 0 0 sshpass Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748840] [ 661619] 0 661619 54760 196 69632 0 0 ssh Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748842] [ 661621] 0 661621 3314 312 69632 0 0 sshd Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748844] [ 661818] 0 661818 53093 16 57344 0 0 sleep Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748845] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysqld-3316.service,task=mysqld,pid=297874,uid=1011 Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.748857] Out of memory: Kill process 297874 (mysqld) score 899 or sacrifice child Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.750580] Killed process 297874 (mysqld) total-vm:9530348kB, anon-rss:6861424kB, file-rss:0kB, shmem-rss:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 kernel: [351914.810159] oom_reaper: reaped process 297874 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Main process exited, code=killed, status=9/KILL Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Failed with result 'signal'. **oom之后的mysqld服务状态** # systemctl status mysqld-3316 ● mysqld-3316.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld-3316.service; disabled; vendor preset: disabled) Active: failed (Result: signal) since Fri 2024-07-26 11:09:39 CST; 41min ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 297874 ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my-3316.cnf (code=killed, signal=KILL) Main PID: 297874 (code=killed, signal=KILL) Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Main process exited, code=killed, status=9/KILL Jul 26 11:09:39 ZZCXCSCSY176X52249 systemd[1]: mysqld-3316.service: Failed with result 'signal'. **oom发生之后系统内存的信息** ： # free total used free shared buff/cache available Mem: 7639676 170340 6873624 396136 595712 6769084 Swap: 0 0 0 **数据库配置：** 版本：MySQL 8.0.28-4 架构：innodb cluster **MySQL数据库配置文件内容** ： [mysql] auto-rehash socket =/app/mysql/data/3316/tmp/mysql-3316.sock # /tmp/mysql.sock [mysqld] ####: from template 128G max_connections = 200 binlog_expire_logs_seconds = 86400 table_open_cache = 8000 table_definition_cache = 8000 table_open_cache_instances = 64 thread_cache_size = 3000 innodb_log_buffer_size = 32M innodb_log_file_size = 2G innodb_buffer_pool_instances =8 innodb_log_files_in_group = 3 innodb_max_undo_log_size = 4G innodb_buffer_pool_size=4G thread_stack = 512K external-locking = FALSE tmp_table_size = 96M max_heap_table_size = 96M ####: for global user =mcs-mysql server_id =52249 # 1 #basedir =/usr/local/mysql-8.0.28-linux-glibc2.12-x86_64 # /usr/local/mysql/ datadir =/app/mysql/data/3316/data # /usr/local/mysql/data/ max_prepared_stmt_count =1048576 # 16382 open_files_limit =102000 # 65536 port =3316 # 3306 mysqlx_port =33160 # 33060 mysqlx_socket = /app/mysql/data/3316/tmp/mysql-3316x.sock admin_address =127.0.0.1 admin_port =33162 # 33062 socket =/app/mysql/data/3316/tmp/mysql-3316.sock # /tmp/mysql.sock skip_name_resolve =1 # 0 super_read_only =OFF # OFF sql_require_primary_key =OFF # OFF cte_max_recursion_depth =1000 # 1000 log_timestamps =system # UTC lower_case_table_names =1 # 0 auto_increment_increment =1 # 1 auto_increment_offset =1 # 1 lock_wait_timeout =31536000 # ! event_scheduler =OFF # ON auto_generate_certs =ON # ON big_tables =OFF # OFF join_buffer_size =16M # 0.25M activate_all_roles_on_login =ON # OFF end_markers_in_json =OFF # OFF tmpdir =/app/mysql/data/3316/tmp/ autocommit =ON # ON sort_buffer_size =16M # 262144(256k) back_log = 1024 max_connect_errors = 10000000000000 innodb_undo_tablespaces = 95 ############### slow_query_log_file = /app/mysql/data/3316/log/slow.log log_error = /app/mysql/data/3316/log/error.log log_bin = /app/mysql/data/3316/binlog/mybinlog log_bin_index = /app/mysql/data/3316/binlog/mybinlog.index ################# ####: for net max_allowed_packet =1G # 64M bind_address =* # * interactive_timeout =28800 # 28800 wait_timeout = 28800 ####: for logs log_output =FILE # FILE ## -- general log general_log =OFF # OFF general_log_file =general.log # $(hotname).log ## -- error log log_statements_unsafe_for_binlog =ON # ! for error 1592 ## -- slow log long_query_time =2.0 # 10.000000 log_queries_not_using_indexes =OFF # OFF log_slow_admin_statements =OFF # OFF log_slow_slave_statements =1 # OFF slow_query_log =ON # OFF #slow_query_log_file =slow.log # slow.log ####: for binlog binlog_checksum =NONE # CRC32 log_bin_trust_function_creators =ON # OFF binlog_direct_non_transactional_updates =OFF # OFF binlog_error_action =ABORT_SERVER # ABORT_SERVER | IGNORE_ERROR binlog_format =ROW # ROW | STATEMENT | MIXED max_binlog_stmt_cache_size =1G # 18446744073709547520 max_binlog_cache_size =2G # 18446744073709547520(1G) max_binlog_size =1G binlog_order_commits =ON # ON binlog_row_image =FULL # FULL | MINIMAL | NOBLOB binlog_row_metadata =MINIMAL # MINIMAL | FULL binlog_rows_query_log_events =ON # OFF log_slave_updates =ON # ON binlog_stmt_cache_size =32k # 32768(32k) sync_binlog =1 # 1 | 0 | N binlog_group_commit_sync_delay =500 # 0 binlog_group_commit_sync_no_delay_count =10 # 0 binlog_cache_size =4M # 32768(32k) binlog_transaction_dependency_history_size =25000 # 25000 binlog_transaction_dependency_tracking =WRITESET # COMMIT_ORDER | WRITESET | WRITESET_SESSION relay_log_recovery = 1 relay-log-purge = 1 key_buffer_size = 32M read_buffer_size = 8M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 10G explicit_defaults_for_timestamp = 1 transaction_isolation = REPEATABLE-READ #myisam_repair_threads = 1 # some var for MySQL 8 log_error_verbosity = 3 innodb_print_ddl_logs = 1 ####: for replication ## -- replication master master_info_repository =table # TABLE | FILE sync_master_info =10000 # 10000 # ##rpl_semi_sync_master_timeout =1000 # 1000(1 second) plugin_load_add =semisync_master.so plugin_load_add =group_replication.so ##rpl_semi_sync_master_enabled =1 # 0 ## -- replication slave relay_log_info_repository =table # file skip_slave_start =0 # 0 slave_parallel_type =logical_clock # database | LOGICAL_CLOCK slave_parallel_workers =4 # 0 slave_max_allowed_packet =1073741824 # 1073741824 slave_load_tmpdir =/app/mysql/data/3316/tmp # /tmp/ sync_relay_log =10000 # 10000 sync_relay_log_info =10000 # 10000 plugin_load_add =semisync_slave.so # ##rpl_semi_sync_slave_enabled =1 # 0 slave-preserve-commit-order =ON # ####: for gtid binlog_gtid_simple_recovery =ON # ON enforce_gtid_consistency =ON # ON gtid_executed_compression_period =1000 # 1000 gtid_mode =ON # OFF ####: for storage engine default_storage_engine =innodb # InnoDB default_tmp_storage_engine =innodb # InnoDB internal_tmp_mem_storage_engine =TempTable # TempTable ####: for innodb ## disk I/O and file space management innodb_data_home_dir =/app/mysql/data/3316/data # ./ innodb_data_file_path =ibdata1:1G:autoextend # ibdata1:12M:autoextend innodb_page_size =16k # 16384(16k) innodb_default_row_format =dynamic # dynamic | compact | redundant innodb_log_group_home_dir =/app/mysql/data/3316/data # ./ innodb_redo_log_encrypt =OFF # OFF innodb_online_alter_log_max_size =4G # 134217728(128M) innodb_undo_directory =/app/mysql/data/3316/undolog # ./ innodb_undo_log_encrypt =OFF # OFF innodb_undo_log_truncate =ON # ON innodb_rollback_on_timeout =1 # OFF innodb_rollback_segments =128 # 128 [1~128] innodb_log_checksums =ON # ON innodb_checksum_algorithm =crc32 # crc32 innodb_log_compressed_pages =ON # ON innodb_doublewrite =ON # ON ! do not disable it please. innodb_commit_concurrency =0 # 0 ## configuring innodb readonly innodb_read_only =OFF # OFF ## configuring innodb dedicated server innodb_dedicated_server =OFF # OFF ! related to mysql auto config please donot chanage ## configuring innodb buffer pool size and instances innodb_buffer_pool_chunk_size =128M # 134217728(128M) ## making the buffer pool scan resistant innodb_old_blocks_pct =37 # 37 innodb_old_blocks_time =1000 # 1000 ## configuring innodb buffer pool prefetching(read ahead) innodb_random_read_ahead =off # OFF innodb_read_ahead_threshold =56 # 56 ## configuring innodb buffer pool flushing innodb_max_dirty_pages_pct_lwm =20 # 10 innodb_max_dirty_pages_pct =60 # 90 ## fine-tuning innodb buffer pool flushing innodb_flush_neighbors =0 # off | on (off for ssd ,on for hdd) innodb_lru_scan_depth =4000 # 1024 ## tuning for sharp checkpoint innodb_adaptive_flushing =ON # ON innodb_adaptive_flushing_lwm =10 # 10 innodb_flushing_avg_loops =30 # 30(a heih value means adaptive flushing is slow) ## saving and restoring the buffer pool state innodb_buffer_pool_dump_pct =50 # 50 innodb_buffer_pool_dump_at_shutdown =ON # ON innodb_buffer_pool_load_at_startup =ON # ON innodb_buffer_pool_filename =ib_buffer_pool # ib_buffer_pool innodb_stats_persistent =ON # ON innodb_stats_on_metadata =ON # OFF innodb_stats_method =nulls_equal # nulls_equal innodb_stats_auto_recalc =ON # ON innodb_stats_include_delete_marked =ON # ON innodb_stats_persistent_sample_pages=20 # 20 innodb_stats_transient_sample_pages =8 # 8 innodb_status_output =OFF # OFF innodb_status_output_locks =1 # OFF innodb_buffer_pool_dump_now =OFF # OFF innodb_buffer_pool_load_abort =OFF # OFF innodb_buffer_pool_load_now =OFF # OFF ## configuring thread concurrency for innodb innodb_thread_concurrency =0 # 0 #? if innodb_thread_concurrency is 0, the value of innodb_thread_sleep_delay is ignored; #? so default the next 3 are ignored. innodb_concurrency_tickets =5000 # 5000 innodb_thread_sleep_delay =15000 # 10000 ( 1/100 s) innodb_adaptive_max_sleep_delay =150000 # 150000 (15/100 s) ## configuring the number of background innoDB i/o threads #? if you see more than 64 × innodb_read_io_threads pending read requests in #? SHOW ENGINE INNODB STATUS output, you might improve performance #? by increasing the value of innodb_read_io_threads. innodb_read_io_threads =8 # 4 innodb_write_io_threads =8 # 4 ## using asynchronous i/o on linux #? 1):perform read-ahead and write requests for data file pages. #? 2):Too many I/O write requests dispatched to the operating system for parallel processing could, #? in some cases, result in I/O read starvation innodb_use_native_aio =ON # ON ## configuring the innodb master thread i/o rate innodb_flush_sync =OFF # ON #? To adhere to the limit on InnoDB background I/O activity defined by the innodb_io_capacity setting, #? disable innodb_flush_sync. innodb_io_capacity =8000 # 200 innodb_io_capacity_max =10000 # 2000 ## configuring spin lock polling innodb_spin_wait_delay =6 # 6 ## configuring innoDB purge scheduling innodb_purge_threads =4 # 4 innodb_purge_batch_size =300 # 300(300 undo log page) innodb_purge_rseg_truncate_frequency=128 # 128 ## -- Lock & Wait innodb_deadlock_detect =ON # ON innodb_autoinc_lock_mode =2 # 0 | 1 | 2 innodb_print_all_deadlocks =ON # OFF innodb_lock_wait_timeout =50 # 50 innodb_table_locks =ON # ON innodb_sync_array_size =1 # 1 innodb_sync_spin_loops =30 # 30 ## innodb others innodb_print_ddl_logs =OFF # OFF innodb_replication_delay =0 # 0 innodb_cmp_per_index_enabled =OFF # ! do not enable it please. innodb_disable_sort_file_cache =OFF # OFF innodb_numa_interleave =OFF # OFF innodb_strict_mode =ON # ON innodb_sort_buffer_size =1M # 1M(global and only for full-text search) innodb_fast_shutdown =1 # 0 | 1 | 2 innodb_force_load_corrupted =OFF # OFF innodb_force_recovery =0 # 0 | 1 | 2 | 3 | 4 | 5 | 6 innodb_temp_tablespaces_dir =/app/mysql/data/3316/tmp/#innodb_temp/ # ./#innodb_temp/ innodb_tmpdir =/app/mysql/data/3316/tmp # ! the sort file temp dir of alter table opration innodb_temp_data_file_path =ibtmp1:2048M:autoextend # ibtmp1:12M:autoextend ! stores rollback segments for changes made to user-created temporary tables. innodb_page_cleaners =4 # 1 ## adaptive hash index innodb_adaptive_hash_index =ON # ON innodb_adaptive_hash_index_parts =8 # 8 ## -- Flush & Io innodb_flush_log_at_timeout =1 # 1 innodb_flush_log_at_trx_commit =1 # 1 | 0 | 2 innodb_flush_method =O_DIRECT # fsync | o_direct innodb_fsync_threshold =0 # 0 ~ 2**64-1 innodb_change_buffer_max_size =25 # 25 innodb_change_buffering =all # all | none | inserts | deletes | changes | purges ####: others div_precision_increment =4 # 4 eq_range_index_dive_limit =200 # 200 explicit_defaults_for_timestamp =ON # ON group_concat_max_len =1024 # 1024 flush =OFF # OFF flush_time =0 # 0 automatic_sp_privileges =ON # ON innodb_fill_factor =90 # 100 innodb_file_per_table =ON # ON innodb_autoextend_increment =64 # 64 innodb_open_files =64000 # 4000 ####: for authentication caching_sha2_password_auto_generate_rsa_keys =ON # ON caching_sha2_password_private_key_path =private_key.pem # private_key.pem caching_sha2_password_public_key_path =public_key.pem # public_key.pem default_authentication_plugin =caching_sha2_password # caching_sha2_password default_password_lifetime =0 # 0 disconnect_on_expired_password =ON # ON ####: for character character_set_server =utf8mb4 # utf8mb4 collation_server =utf8mb4_0900_ai_ci # utf8mb4_0900_ai_ci #### for performance_schema performance_schema =on # on performance_schema_instrument = '%memory%=on' performance_schema_instrument = '%lock%=on' 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" ############## ####: for mysql group replication loose-group_replication_recovery_get_public_key =ON loose-group_replication_recovery_retry_count =10 # 10 loose-group_replication_recovery_reconnect_interval =60 # 60 loose-group_replication_allow_local_disjoint_gtids_join =off # off loose-group_replication_allow_local_lower_version_join =off # off loose-transaction_write_set_extraction =XXHASH64 # off loose-group_replication_group_name=9eac328b-0d8e-4edb-a6b2-cbde736bda15 loose-group_replication_start_on_boot =off # off loose-group_replication_bootstrap_group =off # off loose-group_replication_single_primary_mode =on # on loose-group_replication_enforce_update_everywhere_checks =off loose-group_replication_gtid_assignment_block_size =1000000 # 1000000 loose-group_replication_poll_spin_loops =0 # 0 loose-group_replication_compression_threshold =1024 # 1000000 loose-group_replication_flow_control_mode =QUOTA # QUOTA loose-group_replication_flow_control_applier_threshold =25000 # 25000 loose-group_replication_flow_control_certifier_threshold =25000 # 25000 loose-group_replication_flow_control_hold_percent =10 # 10 loose-group_replication_flow_control_max_commit_quota =0 # 0 loose-group_replication_flow_control_member_quota_percent=0 # 0 loose-group_replication_flow_control_min_quota =0 # 0 loose-group_replication_flow_control_min_recovery_quota =0 # 0 loose-group_replication_flow_control_period =1 # 1 loose-group_replication_flow_control_release_percent =50 # 50 loose-group_replication_transaction_size_limit =0 # 0 loose-group_replication_local_address ="10.176.52.249:13316" report_host ="10.176.52.249" loose-group_replication_group_seeds ="10.176.52.249:13316,10.176.52.250:13316,10.176.52.251:13316" loose-group_replication_ip_whitelist ="10.176.52.249,10.176.52.250,10.176.52.251" ####: for writeset transaction_write_set_extraction = XXHASH64 [client] port=3316 socket=/app/mysql/data/3316/tmp/mysql-3316.sock **缺陷详情参考链接：** **缺陷分析指导链接：** https：xxx
评论 (
1
)
登录
后才可以发表评论
状态
待办的
待办的
已挂起
修复中
已确认
已完成
已验收
已取消
负责人
未设置
标签
sig/Others
未设置
项目
未立项任务
未立项任务
里程碑
未关联里程碑
未关联里程碑
Pull Requests
未关联
未关联
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
未关联
分支 (26)
标签 (46)
master
openEuler-22.03-LTS-SP3
openEuler-22.03-LTS-SP4
openEuler-20.03-LTS-SP4
openEuler-24.03-LTS-SP1
openEuler-24.03-LTS-SP2
openEuler-24.03-LTS
openEuler-24.03-LTS-Next
openEuler-25.09
openEuler-25.03
openEuler-22.03-LTS-SP1
openEuler-24.09
openEuler-20.03-LTS-SP1
openEuler-22.03-LTS-Next
openEuler-22.03-LTS
openEuler-22.03-LTS-SP2
openEuler-20.03-LTS-SP3
openEuler-23.09
openEuler-23.03
openEuler-22.09
openEuler-20.03-LTS
openEuler-20.03-LTS-Next
openEuler-21.09
openEuler-20.03-LTS-SP2
openEuler-21.03
openEuler-20.09
openEuler-25.09-release
openEuler-22.03-LTS-SP4-update-20250829
openEuler-24.03-LTS-update-20250829
openEuler-20.03-LTS-SP4-update-20250829
openEuler-24.03-LTS-SP1-update-20250829
openEuler-24.03-LTS-SP2-update-20250829
openEuler-24.03-LTS-SP2-release
openEuler-24.03-LTS-update-20250425
openEuler-22.03-LTS-SP3-update-20250425
openEuler-24.03-LTS-SP1-update-20250425
openEuler-24.03-LTS-SP1-update-20250428
openEuler-22.03-LTS-SP4-update-20250425
openEuler-20.03-LTS-SP4-update-20250425
openEuler-25.03-release
openEuler-24.03-LTS-update-20250208
openEuler-20.03-LTS-SP4-update-20250208
openEuler-22.03-LTS-SP3-update-20250208
openEuler-22.03-LTS-SP4-update-20250208
openEuler-24.03-LTS-SP1-update-20250208
openEuler-24.03-LTS-SP1-release
openEuler-22.03-LTS-SP4-update-before-20241025
openEuler-20.03-LTS-SP4-update-20241025
openEuler-22.03-LTS-SP4-update-20241025
openEuler-22.03-LTS-SP1-update-20241025
openEuler-22.03-LTS-SP3-update-20241025
openEuler-24.03-LTS-update-20241025
openEuler-22.03-LTS-SP4-release
openEuler-24.09-release
openEuler-24.03-LTS-release
openEuler-22.03-LTS-SP3-release
openEuler-23.09-rc5
openEuler-22.03-LTS-SP1-release
openEuler-22.09-release
openEuler-22.09-rc5
openEuler-22.09-20220829
openEuler-22.03-LTS-20220331
openEuler-22.03-LTS-round5
openEuler-22.03-LTS-round3
openEuler-22.03-LTS-round2
openEuler-22.03-LTS-round1
openEuler-20.03-LTS-SP3-release
openEuler-20.03-LTS-SP2-20210624
openEuler-21.03-20210330
openEuler-20.09-20200929
openEuler-20.03-LTS-20200606
openEuler-20.03-LTS-tag
开始日期 - 截止日期
-
置顶选项
不置顶
置顶等级：高
置顶等级：中
置顶等级：低
优先级
不指定
严重
主要
次要
不重要
预计工期
（小时）
参与者（1）
1
https://gitee.com/src-openeuler/mysql.git
git@gitee.com:src-openeuler/mysql.git
src-openeuler
mysql
mysql
点此查找更多帮助
搜索帮助
Git 命令在线学习
如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号，请先登录后再操作。
立即登录
没有帐号，去注册
