Re: Memory usage increasing constantly
> 2000 partitions each
That, itself, is a source of performance problems. In many situations, all 2000 PARTITIONs have to be opened. This takes a lot of time. And it may stress the table cache, etc. Recommend no more than 50 PARITIONs per table.
> I cannot eliminate partitioning in production
Let's discuss the details. There are a few ways PARTITIONing is a benefit; there are many ways in which it is not. What do you expect to benefit? Please provide SHOW CREATE TABLE. And some of the important queries.
> but I have a huge memory consumption per connection (500 MB each connection?)
Yikes!
Subject
Written By
Posted
Re: Memory usage increasing constantly
May 28, 2014 07:31PM
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.