[Pdns-users] test driving LMDB backend

[Bart Mortelmans]

Dear Gert,

I'm indeed using InnoDB. I didn't do much optimization to the MySQL. 
Only had this:

innodb_buffer_pool_size=128M

which is actually default. But on a 1G machine, there isn't much room 
for improvement either.
I didn't change InnoDB flush log settings. I wouldn't expect this to 
make much of a difference when we're mostly reading and not writing?

Regards,
Bart Mortelmans




Op 6/05/19 om 10:49 schreef Gert van Dijk:
> (just wanted to comment on this, slightly unrelated part)
>
> On Mon, May 6, 2019 at 10:02 AM Bart Mortelmans <powerdns at bart.bim.be> wrote:
>> I actually found out because systemd was restarting the service every
>> couple of minutes. Turns out that I should have put "Type=simple" in the
>> .service-file instead of "Type=notify".
> Type=notify should really work. It activates a mechanism that systemd
> will talk to the
> daemon over a socket about its state (ready, shutting down, etc.),
> rather than systemd
> assuming that if a process is running that's it's actually ready.
> Support for that has been
> in PowerDNS Authoritative since 4.0 with 6988eae [1] it appears to me.
> I could only find
> this bug report about that it does not work with chroot settings [2].
> I'd suggest to report it
> as a bug if you did not enable chroot.
>
> More on topic with your tests; please include more details about your
> MySQL installation
> too. It's rather incomparable if you don't specify all (complex) MySQL
> settings. InnoDB?
> InnoDB pool size? InnoDB flush log settings? Pool warmed up or not?
> Same machine?
> Version? etc. etc. All potentially hugely important for the performance.
> Other than that, really nice to see LMDB in action. :-)
>
> [1]: https://github.com/PowerDNS/pdns/commit/6988eae995cf47d024a974ecf5dda77b4284ee6b
> [2]: https://github.com/PowerDNS/pdns/issues/4179
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users