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 <power...@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@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
