On 16/5/62 18:47, Amirouche Boubekki wrote:
Hello,


I am considering using lsm extension for a project. I a did a few benchmark
with the following configuration:

LSM_CONFIG_AUTOFLUSH 1048576
LSM_CONFIG_BLOCK_SIZE 65536
LSM_CONFIG_AUTOWORK 1
LSM_CONFIG_MMAP 0
LSM_CONFIG_MULTIPLE_PROCESS 0

I am trying to load 4.5GB of data. The database errors with BUSY error at
some point.

Also, the memory consumption grows unbound even if I diseabled MMAP.

Here is some stats:

$ ls -larh wt/foob.ar.lsm.sqlite*

-rw-r--r-- 1 amirouche amirouche 618M May 16 13:39 wt/foob.ar.lsm.sqlite-log
-rw-r--r-- 1 amirouche amirouche 468M May 16 13:39 wt/foob.ar.lsm.sqlite

And I attached a memory plot.

opening and closing the database at each transaction help, but still the
memory grows.

What I am doing wrong?

The mailing list has discarded your attachment. But what we need most to try to diagnose the memory leak is the code you are using. If we can actually run it and reproduce the memory leak, so much the better.

Dan.



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to