MySQL5.7 high version suspected memory leak

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.