Re: MonetDB :: Memory Blots Up On High Concurrency

On 17 Jul 2017, at 14:18, Stefano Piani wrote:

Hello, I think that I have faced the same issue. I have a database with a table that contains a few millions of entries. I have been trying to add about ten new entries per second on that table. At the beginning, the database was able to keep the pace with the data but, after a while, the database starts to consume more and more ram and to slow down. In that situation, it also becomes extremely slows to answer to the queries. If I restart the database, everything seems to work fine again.

I am using Ubuntu 16.04 and the monetdb instance is running inside a docker (again with ubuntu 16.04).

This is what I have noticed so far: * It took a while before the problem starts to appear * The bigger the table the sooner the problem appears * The time required for an insertion is more or less the same, the time required for a query increases

Hello Stefano, I was just thinking that the increasing response time of your queries might have been caused by that you insert individual tuples into a table with primary key (that will become slower over time for sure), until I saw this remark of yours. I’ll come back with more information for your issues in your other thread. Regards, Jennie

As soon I can, I will try to prepare a few scripts to check if I can simulate the problem that I have with my application. Then, I will give you a more accurate description of the problem.

Best regards, Stefano

On Sat, Jul 15, 2017 at 7:31 AM, Sharma, Sreejith wrote:

...

Hi,

Does anyone encountered memory blot issue on high concurrency? Also, I don’t see it coming down when idle. When its blots up, it’s slows down the response time.

Regards,

Sreejith

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list