我有一台 Ubuntu 服务器版本 20.04.2 LTS。我在其上只安装了 mysql 版本 8.0.25-0ubuntu0.20.04.1
这是一个专用服务器，因此我将 my.cnf 设置如下：
innodb_dedicated_server = 1
skip_name_resolve = 1
key_buffer_size = 16M
myisam-recover-options = BACKUP
max_binlog_size = 100M
该服务器是配置有 10GB RAM、8 个 CPU（2 核、4 个插槽）的 vmware VM。
问题是这样的；mysql 时不时（一天一次或每两天一次）崩溃并显示“内存不足”。例如，刚才我用 free -m 检查了我的可用内存，结果是 130。我想这很可能是正常的，因为 innodb_dedicated_server。我在一个有 350 万行的表上运行了 alter table，然后它就崩溃了。可能是没有足够的内存来执行 alter table 吧？
我该如何优化它？我希望它使用尽可能多的内存，但我不希望它因更改表而崩溃...
有什么帮助吗？谢谢！
编辑-日志文件：
Jul 20 00:08:35 ITMI-PHSE-MYSQL snapd[937]: storehelpers.go:551: cannot refresh: snap has no updates available: "core", "core18", "core20", "lxd"
Jul 20 00:08:35 ITMI-PHSE-MYSQL snapd[937]: autorefresh.go:513: auto-refresh: all snaps are up-to-date
Jul 20 00:09:01 ITMI-PHSE-MYSQL CRON[33080]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 00:17:01 ITMI-PHSE-MYSQL CRON[33096]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 00:39:01 ITMI-PHSE-MYSQL CRON[33125]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 01:09:01 ITMI-PHSE-MYSQL CRON[33159]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 01:17:01 ITMI-PHSE-MYSQL CRON[33175]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 01:38:46 ITMI-PHSE-MYSQL systemd[1]: fwupd.service: Succeeded.
Jul 20 01:39:01 ITMI-PHSE-MYSQL CRON[33216]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 02:09:01 ITMI-PHSE-MYSQL CRON[33255]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 02:17:02 ITMI-PHSE-MYSQL CRON[33269]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 02:39:01 ITMI-PHSE-MYSQL CRON[33293]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 03:09:01 ITMI-PHSE-MYSQL CRON[33327]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 03:10:01 ITMI-PHSE-MYSQL CRON[33330]: (root) CMD (test -e /run/systemd/system || SERVICE_MODE=1 /sbin/e2scrub_all -A -r)
Jul 20 03:17:01 ITMI-PHSE-MYSQL CRON[33341]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 03:31:24 ITMI-PHSE-MYSQL systemd[1]: Starting Ubuntu Advantage APT and MOTD Messages...
Jul 20 03:31:26 ITMI-PHSE-MYSQL systemd[1]: ua-messaging.service: Succeeded.
Jul 20 03:31:26 ITMI-PHSE-MYSQL systemd[1]: Finished Ubuntu Advantage APT and MOTD Messages.
Jul 20 03:39:01 ITMI-PHSE-MYSQL CRON[33388]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 04:09:01 ITMI-PHSE-MYSQL CRON[33423]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 04:17:01 ITMI-PHSE-MYSQL CRON[33436]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 04:39:01 ITMI-PHSE-MYSQL CRON[33459]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 05:09:01 ITMI-PHSE-MYSQL CRON[33496]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 05:17:01 ITMI-PHSE-MYSQL CRON[33506]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 05:39:01 ITMI-PHSE-MYSQL CRON[33532]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 06:09:01 ITMI-PHSE-MYSQL CRON[33568]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 06:10:24 ITMI-PHSE-MYSQL systemd[1]: Starting Daily apt upgrade and clean activities...
Jul 20 06:10:28 ITMI-PHSE-MYSQL systemd[1]: apt-daily-upgrade.service: Succeeded.
Jul 20 06:10:28 ITMI-PHSE-MYSQL systemd[1]: Finished Daily apt upgrade and clean activities.
Jul 20 06:17:01 ITMI-PHSE-MYSQL CRON[33675]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 06:25:01 ITMI-PHSE-MYSQL CRON[33688]: (root) CMD (test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ))
Jul 20 06:39:01 ITMI-PHSE-MYSQL CRON[33782]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 07:09:01 ITMI-PHSE-MYSQL CRON[33826]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 07:17:01 ITMI-PHSE-MYSQL CRON[33842]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 07:39:01 ITMI-PHSE-MYSQL CRON[33868]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 08:09:02 ITMI-PHSE-MYSQL CRON[33940]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 08:17:01 ITMI-PHSE-MYSQL CRON[33961]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 08:39:02 ITMI-PHSE-MYSQL CRON[34011]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 09:09:01 ITMI-PHSE-MYSQL CRON[34089]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 09:17:01 ITMI-PHSE-MYSQL CRON[34132]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 09:17:55 ITMI-PHSE-MYSQL systemd[1]: Started Session 529 of user lorenzo.
Jul 20 09:39:01 ITMI-PHSE-MYSQL CRON[34363]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 09:42:01 ITMI-PHSE-MYSQL CRON[34370]: (root) CMD ( test -x /etc/cron.daily/popularity-contest && /etc/cron.daily/popularity-contest --crond)
Jul 20 10:07:00 ITMI-PHSE-MYSQL systemd[1]: Starting Message of the Day...
Jul 20 10:07:12 ITMI-PHSE-MYSQL 50-motd-news[34482]: * Super-optimized for small spaces - read how we shrank the memory
Jul 20 10:07:12 ITMI-PHSE-MYSQL 50-motd-news[34482]: footprint of MicroK8s to make it the smallest full K8s around.
Jul 20 10:07:12 ITMI-PHSE-MYSQL 50-motd-news[34482]: https://ubuntu.com/blog/microk8s-memory-optimisation
Jul 20 10:07:12 ITMI-PHSE-MYSQL systemd[1]: motd-news.service: Succeeded.
Jul 20 10:07:12 ITMI-PHSE-MYSQL systemd[1]: Finished Message of the Day.
Jul 20 10:09:01 ITMI-PHSE-MYSQL CRON[34503]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 10:17:03 ITMI-PHSE-MYSQL CRON[34525]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Jul 20 10:39:02 ITMI-PHSE-MYSQL CRON[34591]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195446] mysqld invoked oom-killer: gfp_mask=0x100cca(GFP_HIGHUSER_MOVABLE), order=0, oom_score_adj=0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195450] CPU: 2 PID: 34627 Comm: mysqld Not tainted 5.4.0-77-generic #86-Ubuntu
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195451] Hardware name: VMware, Inc. VMware Virtual Platform/440BX Desktop Reference Platform, BIOS 6.00 12/12/2018
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195452] Call Trace:
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195460] dump_stack+0x6d/0x8b
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195464] dump_header+0x4f/0x1eb
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195467] oom_kill_process.cold+0xb/0x10
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195470] out_of_memory.part.0+0x1df/0x3d0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195472] out_of_memory+0x6d/0xd0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195475] __alloc_pages_slowpath+0xd5e/0xe50
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195479] __alloc_pages_nodemask+0x2d0/0x320
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195481] alloc_pages_current+0x87/0xe0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195484] __page_cache_alloc+0x72/0x90
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195486] pagecache_get_page+0xbf/0x300
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195489] filemap_fault+0x6b2/0xa50
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195492] ? unlock_page_memcg+0x12/0x20
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195494] ? page_add_file_rmap+0xff/0x1a0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195497] ? filemap_map_pages+0x24c/0x380
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195500] ext4_filemap_fault+0x32/0x50
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195502] __do_fault+0x3c/0x130
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195505] do_fault+0x24b/0x640
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195507] __handle_mm_fault+0x4c5/0x7a0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195509] handle_mm_fault+0xca/0x200
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195512] do_user_addr_fault+0x1f9/0x450
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195515] __do_page_fault+0x58/0x90
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195517] do_page_fault+0x2c/0xe0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195520] page_fault+0x34/0x40
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195522] RIP: 0033:0x7ffb5f76afff
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195527] Code: Bad RIP value.
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195528] RSP: 002b:00007ffb0c051ea0 EFLAGS: 00010246
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195530] RAX: 00000000000000a0 RBX: 00007ff8ec513020 RCX: 0000000000000000
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195531] RDX: 0000000000000014 RSI: 00007ffb0c051ef0 RDI: 00007ff8ec00e6b0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195532] RBP: 00007ffb0c051ee0 R08: 00007ff8ec00e6b0 R09: 00007ff8ec00e70c
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195533] R10: 00007ff8ec00e70c R11: 00007ffb0c051e58 R12: 00007ff8ec051e40
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195533] R13: 0000000000000014 R14: 00007ffb0c051ef0 R15: 0000000000000014
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195535] Mem-Info:
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] active_anon:2436714 inactive_anon:283 isolated_anon:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] active_file:185 inactive_file:37 isolated_file:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] unevictable:4634 dirty:3 writeback:0 unstable:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] slab_reclaimable:16654 slab_unreclaimable:32409
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] mapped:2438 shmem:696 pagetables:5722 bounce:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195546] free:27493 free_pcp:1798 free_cma:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195549] Node 0 active_anon:9746856kB inactive_anon:1132kB active_file:740kB inactive_file:148kB unevictable:18536kB isolated(anon):0kB isolated(file):0kB mapped:9752kB dirty:12kB writeback:0kB shmem:2784kB shmem_thp: 0kB shmem_pmdmapped: 0kB anon_thp: 0kB writeback_tmp:0kB unstable:0kB all_unreclaimable? no
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195550] Node 0 DMA free:15860kB min:104kB low:128kB high:152kB active_anon:0kB inactive_anon:0kB active_file: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 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195554] lowmem_reserve[]: 0 2911 9861 9861 9861
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195557] Node 0 DMA32 free:47248kB min:19920kB low:24900kB high:29880kB active_anon:2927744kB inactive_anon:92kB active_file:444kB inactive_file:0kB unevictable:0kB writepending:4kB present:3129216kB managed:3063680kB mlocked:0kB kernel_stack:952kB pagetables:5864kB bounce:0kB free_pcp:3104kB local_pcp:296kB free_cma:0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195560] lowmem_reserve[]: 0 0 6949 6949 6949
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195562] Node 0 Normal free:46864kB min:47552kB low:59440kB high:71328kB active_anon:6819112kB inactive_anon:1040kB active_file:480kB inactive_file:740kB unevictable:18536kB writepending:8kB present:7340032kB managed:7124380kB mlocked:18536kB kernel_stack:5784kB pagetables:17024kB bounce:0kB free_pcp:4088kB local_pcp:444kB free_cma:0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195566] lowmem_reserve[]: 0 0 0 0 0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195568] Node 0 DMA: 1*4kB (U) 0*8kB 1*16kB (U) 1*32kB (U) 1*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15860kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195575] Node 0 DMA32: 932*4kB (UE) 697*8kB (UE) 593*16kB (UE) 198*32kB (ME) 210*64kB (UME) 63*128kB (UME) 1*256kB (M) 0*512kB 0*1024kB 0*2048kB 0*4096kB = 46888kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195583] Node 0 Normal: 1338*4kB (UME) 656*8kB (UE) 246*16kB (UE) 128*32kB (UME) 131*64kB (UME) 93*128kB (UME) 14*256kB (UE) 2*512kB (ME) 1*1024kB (M) 1*2048kB (M) 0*4096kB = 46600kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195592] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=1048576kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195593] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195594] 3206 total pagecache pages
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195595] 0 pages in swap cache
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195596] Swap cache stats: add 0, delete 0, find 0/0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195596] Free swap = 0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195597] Total swap = 0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195598] 2621310 pages RAM
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195599] 0 pages HighMem/MovableOnly
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195599] 70318 pages reserved
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195600] 0 pages cma reserved
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195600] 0 pages hwpoisoned
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195601] Tasks state (memory values in pages):
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195602] [ pid ] uid tgid total_vm rss pgtables_bytes swapents oom_score_adj name
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195610] [ 567] 0 567 16228 966 139264 0 -250 systemd-journal
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195618] [ 598] 0 598 5551 1083 73728 0 -1000 systemd-udevd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195620] [ 612] 101 612 4602 820 81920 0 0 systemd-network
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195623] [ 827] 0 827 70052 4498 94208 0 -1000 multipathd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195625] [ 878] 102 878 5972 1328 86016 0 0 systemd-resolve
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195627] [ 879] 100 879 22557 976 77824 0 0 systemd-timesyn
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195629] [ 891] 0 891 11885 823 77824 0 0 VGAuthService
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195630] [ 892] 0 892 40670 402 77824 0 0 vmtoolsd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195632] [ 920] 0 920 59126 490 98304 0 0 accounts-daemon
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195634] [ 923] 0 923 1703 577 45056 0 0 cron
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195635] [ 924] 105 924 1913 817 61440 0 -900 dbus-daemon
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195637] [ 929] 0 929 20492 498 61440 0 0 irqbalance
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195639] [ 931] 0 931 7269 2723 90112 0 0 networkd-dispat
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195640] [ 932] 0 932 8544 1105 106496 0 0 nmbd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195643] [ 935] 103 935 56125 526 81920 0 0 rsyslogd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195645] [ 937] 0 937 455043 3781 360448 0 -900 snapd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195647] [ 947] 0 947 4207 444 69632 0 0 systemd-logind
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195648] [ 951] 0 951 948 500 45056 0 0 atd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195650] [ 964] 0 964 1497 626 49152 0 0 login
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195652] [ 984] 0 984 3044 889 69632 0 -1000 sshd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195654] [ 996] 0 996 26978 2694 110592 0 0 unattended-upgr
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195656] [ 1013] 0 1013 58179 213 86016 0 0 polkitd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195658] [ 1048] 0 1048 12242 1806 135168 0 0 smbd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195665] [ 1063] 0 1063 11686 859 131072 0 0 smbd-notifyd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195666] [ 1064] 0 1064 11688 797 131072 0 0 cleanupd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195668] [ 1090] 0 1090 12238 1058 131072 0 0 lpqd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195670] [ 1355] 1000 1355 4626 653 81920 0 0 systemd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195676] [ 1356] 1000 1356 42217 865 94208 0 0 (sd-pam)
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195682] [ 1361] 1000 1361 2104 926 57344 0 0 bash
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195684] [ 4014] 0 4014 60297 718 102400 0 0 upowerd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195686] [ 20666] 110 20666 4128901 2416524 20922368 0 0 mysqld
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195688] [ 29379] 0 29379 12332 1183 135168 0 0 smbd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195690] [ 34134] 0 34134 3482 849 65536 0 0 sshd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195692] [ 34276] 1000 34276 3515 539 69632 0 0 sshd
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195694] [ 34277] 1000 34277 2102 935 57344 0 0 bash
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195696] [ 34286] 0 34286 2396 706 57344 0 0 sudo
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195698] [ 34289] 0 34289 2096 657 53248 0 0 su
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195699] [ 34290] 0 34290 1809 460 49152 0 0 bash
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195701] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysql.service,task=mysqld,pid=20666,uid=110
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195886] Out of memory: Killed process 20666 (mysqld) total-vm:16515604kB, anon-rss:9666096kB, file-rss:0kB, shmem-rss:0kB, UID:110 pgtables:20432kB oom_score_adj:0
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.658941] oom_reaper: reaped process 20666 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL systemd[1]: mysql.service: Main process exited, code=killed, status=9/KILL
Jul 20 10:40:55 ITMI-PHSE-MYSQL systemd[1]: mysql.service: Failed with result 'signal'.
Jul 20 10:40:55 ITMI-PHSE-MYSQL systemd[1]: mysql.service: Scheduled restart job, restart counter is at 8.
Jul 20 10:40:55 ITMI-PHSE-MYSQL systemd[1]: Stopped MySQL Community Server.
Jul 20 10:40:55 ITMI-PHSE-MYSQL systemd[1]: Starting MySQL Community Server...
Jul 20 10:41:02 ITMI-PHSE-MYSQL systemd[1]: Started MySQL Community Server.
答案1
您可能需要重新考虑错误日志中报告的这种情况 -
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195596] Free swap = 0kB
Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195597] Total swap = 0kB
我建议你的操作系统至少配备 6 GB 的交换空间以避免 OOM。
最好是慢几毫秒或几秒，而不是 OOM 停止。