MySQL Forums
Forum List  »  InnoDB clusters

Re: MySQL 5.7.18 and memory ...
Posted by: Peter Brawley
Date: September 11, 2017 08:14PM

From https://bugs.mysql.com/bug.php?id=84003 ...

"After digging around some more I finally found the cause: Linux' Transparent Huge Pages (THP) combined with system memory allocator (doesn't matter which, malloc, jemalloc, etc.) cause mysqld RSS to increase without bound.

"It may be due to our long lived connections, thousands of prepared statements on those connections, and the inability of memory allocator to clean up huge pages in a timely manner.

"Regardless, disabling THP allows the allocator to eventually return memory to the OS. Basically, MySQL memory usage now falls within a normal range given system load."

Is it relevant to your case?

Options: ReplyQuote


Subject
Views
Written By
Posted
1117
September 11, 2017 12:44PM
909
September 11, 2017 02:01PM
701
September 13, 2017 07:43AM
2538
September 26, 2017 02:41AM
Re: MySQL 5.7.18 and memory ...
1239
September 11, 2017 08:14PM
911
September 13, 2017 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.