Re: Memory usage increasing constantly
Posted by: Matteo Porru
Date: June 18, 2014 07:38AM

Rick, I followed your suggestions and reduced the number of partitions to 50.
I added the index as you suggested and asked to slow down a little bit the queries coming from the application.
Now the memory looks constant.
Well I know, the problem is not solved (it may still happen) but at least I'm not triggering it explictly any more.

For your information, I found this unanswered bug that looks very similar to my scenario:
http://bugs.mysql.com/bug.php?id=65074

Maybe it will get fixed and what I saw will never happen in 5.7.
For now, thank you for your precious suggestions

Options: ReplyQuote




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.