关于内存溢出:故障分析-MySQL-耗尽主机内存一例分析
作者:付祥 现居珠海,次要负责 Oracle、MySQL、mongoDB 和 Redis 保护工作。 本文起源:原创投稿 *爱可生开源社区出品,原创内容未经受权不得随便应用,转载请分割小编并注明起源。 异常现象开发人员反馈,有一台服务器内存简直被 MySQL 耗尽了,执行 top 命令,输入如下: 这台机器是个测试环境,MySQL 是开发本人装置的,数据库版本 5.6.51 ,机器总内存32G,MySQL 占了29G。 剖析过程查看 MySQL 启动工夫发现1个星期前才启动,猜想之前因为主机内存耗尽触发了 OOM ,查看 MySQL 谬误日志,发现每隔10几天,MySQL 就异样敞开一次: 2022-02-24 03:03:42 20981 [Note] InnoDB: Database was not shutdown normally!2022-03-13 02:31:40 4134 [Note] InnoDB: Database was not shutdown normally!2022-03-31 02:31:08 6846 [Note] InnoDB: Database was not shutdown normally!2022-04-12 02:31:41 1159 [Note] InnoDB: Database was not shutdown normally!2022-04-23 04:41:51 6773 [Note] InnoDB: Database was not shutdown normally!2022-05-04 02:31:52 2499 [Note] InnoDB: Database was not shutdown normally!2022-05-13 04:56:06 23010 [Note] InnoDB: Database was not shutdown normally!2022-05-30 02:31:33 3244 [Note] InnoDB: Database was not shutdown normally!查看操作系统日志,进一步验证了 MySQL 耗尽主机内存,触发 OOM : ...