<div dir="auto"><div>Amit,<br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il mer 12 giu 2019, 06:20 Amit Chavan <<a href="mailto:achavan1@gmail.com">achavan1@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hello,<br></div><div><br></div><div>I was playing around with herddb to do some testing today. I create a very simple table ./herddb-cli.sh -q "CREATE TABLE amit(id int primary key, name string)". I see table meta data file, txlog file etc created for this table. I also inserted 2 to 3 rows into this table and I am able to see the txlog being appended by the transaction. What I don't see is the data actually being written to the disk for the table. The directory <b>dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table </b>is empty. When does the in-memory data get written to the disk? Is there a setting or does it occur during checkpoint ?</div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto">Data is written to the journal/commit log.</div><div dir="auto">Data pages are swapped to disk:</div><div dir="auto">- at checkpoint</div><div dir="auto">- when the system is out of memory</div><div dir="auto"><br></div><div dir="auto">Enrico</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><br></div><div>Thanks,</div><div>Amit</div></div>
_______________________________________________<br>
herddb-dev mailing list<br>
<a href="mailto:herddb-dev@lists.herddb.org" target="_blank" rel="noreferrer">herddb-dev@lists.herddb.org</a><br>
<a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
</blockquote></div></div></div>