Hi Norbert,

please take a look at the database tables and you will immediately understand that pdns is looking up records to build dns answers.

You see '?' because pdns 4.0.0+ uses prepared statements, and thats the way mysql logs them.

Cheers

Thomas

Am 21.12.2016 um 11:48 schrieb bodenhalt...@googlemail.com:
Hi,

i have some questions about the gmysql module and some of the queries.

1. I see 20 queries every second like:
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records
WHERE disabled=0 and type=? and name=?
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records
WHERE disabled=0 and type=? and name=? and domain_id=?

Can you help me to understand these queries? Or is it a Bug?

2. Why is "SET SESSION tx_isolation='READ-COMMITTED'" used? I would like
to understand this, is there a way to disable these, without recompile?


Thank you and best regards,

Norbert


_______________________________________________
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

Reply via email to