Am 22.09.2017 um 10:43 schrieb Aki Tuomi:
> To my inexpert eye it seems that in your original post, 4.1 was fastest
> of the lot, so the database begin/commit + prepare cannot really explain
> this since this has not been removed in 4.1?
Obviously there were some changes - no more BEGIN/COMMIT
Update: I do see that the BEGIN/COMMIT exists in 4.0, but was removed in
Master (4.1pre). That might explain why Master is faster :-)
regards
Klaus
Am 22.09.2017 um 10:35 schrieb Klaus Darilion:
>
>
> Am 21.09.2017 um 20:20 schrieb Aki Tuomi:
>> Statements are supposed to prepared once, not per
On 22.09.2017 11:35, Klaus Darilion wrote:
>
> Am 21.09.2017 um 20:20 schrieb Aki Tuomi:
>> Statements are supposed to prepared once, not per every query.
> Indeed, that is the case, the "prepare" is only done once.
>
> But I see that simple SELECTs are wrapped into transactions. Maybe this
> is
Am 21.09.2017 um 20:20 schrieb Aki Tuomi:
> Statements are supposed to prepared once, not per every query.
Indeed, that is the case, the "prepare" is only done once.
But I see that simple SELECTs are wrapped into transactions. Maybe this
is also a performance penalty:
regards
Klaus
LOG: dur
Hi Bert!
Am 19.09.2017 um 21:18 schrieb bert hubert:
> Can you redo your measurements against 4.1rc1? We fixed a lot in there.
> Would be interesting to know if 4.1 is already better.
Targets: reg-tst1, reg-tst2. (they are identical: 4vCPUs, 8GB RAM, no
other VMs running on this hypervisor)
Tes
On Tue, Sep 19, 2017 at 08:46:18PM +0200, Klaus Darilion wrote:
> Hi!
>
> Setup: PowerDNS with gqgsql backend, several 100.000 zones (type=NATIVE)
> on a 4 CPU VM with 8GB Ram
Klaus,
Can you redo your measurements against 4.1rc1? We fixed a lot in there.
Would be interesting to know if 4.1 is al
Hi!
Setup: PowerDNS with gqgsql backend, several 100.000 zones (type=NATIVE)
on a 4 CPU VM with 8GB Ram
cache-ttl=120
negquery-cache-ttl=120
query-cache-ttl=240
distributor-threads=8
receiver-threads=1
I am running 2 tests with dnsperf:
1. query the SOA of every authoritative zone: every zone wi