[Herddb-dev] Question file storage.

Amit Chavan achavan1 at gmail.com
Wed Jun 12 22:03:02 CEST 2019


Thanks. Followup question. How do I replay the transaction log to recreate
the data?
In order for the data to be replayed on a new server, you will also require
the table metadata(schema)? Is there a command line tool to do that?

On Wed, Jun 12, 2019 at 3:00 AM <herddb-dev-request at lists.herddb.org> wrote:

> Send herddb-dev mailing list submissions to
>         herddb-dev at lists.herddb.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.herddb.org/mailman/listinfo/herddb-dev
> or, via email, send a message with subject or body 'help' to
>         herddb-dev-request at lists.herddb.org
>
> You can reach the person managing the list at
>         herddb-dev-owner at lists.herddb.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of herddb-dev digest..."
>
>
> Today's Topics:
>
>    1. Question file storage. (Amit Chavan)
>    2. Re: Question file storage. (Enrico Olivelli)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 11 Jun 2019 21:19:19 -0700
> From: Amit Chavan <achavan1 at gmail.com>
> To: herddb-dev at lists.herddb.org
> Subject: [Herddb-dev] Question file storage.
> Message-ID:
>         <CADsOBjM-WjEZms1-ddY9RHs=8fy9GkNcXY=bP64sG-bTdsV2=
> Q at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hello,
>
> 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
>
> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table
> *is empty. When does the in-memory data get written to the disk? Is there a
> setting or does it occur during checkpoint ?
>
> Thanks,
> Amit
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.herddb.org/pipermail/herddb-dev/attachments/20190611/49f63e50/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Wed, 12 Jun 2019 08:45:42 +0200
> From: Enrico Olivelli <eolivelli at gmail.com>
> To: Herddb developers <herddb-dev at lists.herddb.org>
> Subject: Re: [Herddb-dev] Question file storage.
> Message-ID:
>         <CACcefgdw2eeLEANSeb=
> x-_A-COF7MhwZoD2cMunSJwzv3RxVSA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Amit,
>
> Il mer 12 giu 2019, 06:20 Amit Chavan <achavan1 at gmail.com> ha scritto:
>
> > Hello,
> >
> > 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
> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table
> > *is empty. When does the in-memory data get written to the disk? Is there
> > a setting or does it occur during checkpoint ?
> >
>
> Data is written to the journal/commit log.
> Data pages are swapped to disk:
> - at checkpoint
> - when the system is out of memory
>
> Enrico
>
> >
> > Thanks,
> > Amit
> > _______________________________________________
> > herddb-dev mailing list
> > herddb-dev at lists.herddb.org
> > http://lists.herddb.org/mailman/listinfo/herddb-dev
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/77148ed2/attachment-0001.html
> >
>
> ------------------------------
>
> _______________________________________________
> herddb-dev mailing list
> herddb-dev at lists.herddb.org
> http://lists.herddb.org/mailman/listinfo/herddb-dev
>
>
> End of herddb-dev Digest, Vol 12, Issue 1
> *****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/e944642b/attachment.html>


More information about the herddb-dev mailing list