I have a instance running on mysql-5.7.19. However, I found that it physical memory and virtual memory are both growing slowly. Finally, the mysqld process was killed by Oom-killer.
Ok, speak.
For historical reasons, I upgraded the MySQL database used by network group Zabbix to 5.7.19
Database Restart is a frequent occurrence in recent years. By looking at the log discovery, Oom has occurred.
The monitoring of MySQL also proves that memory usage is increasing, and the process is freed after kill.
Mysqld Daemon Mysqld_safe to pull up the mysqld process again and again.
The system memory usage diagram is as follows
Then, I buglist in the MySQL official website to find the bug about Memery leak.
Several cases of 5.7.22,23
bugs.mysql.com/bug.php?id=91861
bugs.mysql.com/bug.php?id=91710
bugs.mysql.com/bug.php?id=92112
Although there is no conclusive evidence of where the func caused the memory leak. But it did happen.
We've had 5.7.18-19 on the line before, and there's a similar restart. After upgrading the version to 5.7.21, there is no such phenomenon for the time being.
Conclusion:
1, do not recommend the use of 5.7.17-19 because there have been. 5.7.22-23, others have happened.
2, memory usage is too high alarm, in addition to pay attention to the memory usage trend. prevent it from happening.
———— Dba_yix 180827