之前因为设置innodb_buffer_pool_size参数过小导致,导致数据库读写比较慢,后面调整为总内存80%,数据正常,
后面mysqldump备份的时候,总出现错误,查了 /var/log/messages,原因是因为数据库内存太高,导致备份失败,内存有个 oom监控,专门监视内存过高的进程,发现太高就会杀掉kill
Apr 9 08:56:56 db2 kernel: Out of memory: Kill process 30834 (mysqld) score 625 or sacrifice child
Apr 9 08:56:56 db2 kernel: Killed process 30834 (mysqld) total-vm:155581372kB, anon-rss:139682296kB, file-rss:0kB, shmem-rss:0kB
Apr 9 09:00:02 db2 systemd: Started Session 119815 of user root.