Re: [Pdns-users] gmysql modul, queries and tx_isolation

2016-12-21 23:14 GMT+01:00 bodenhalt...@googlemail.com < bodenhalt...@gmail.com>: > > And have you an idea for tx_isolation? > This is solved. FYI: prepared statements are a "known issue" for maxscale: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/limitations-and-known-issues-

Re: [Pdns-users] gmysql modul, queries and tx_isolation

Hi Thomas, 2016-12-21 21:42 GMT+01:00 Thomas Mieslinger : > 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

Re: [Pdns-users] gmysql modul, queries and tx_isolation

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 bodenha

Re: [Pdns-users] PDNS 4 0 0-alpha2 Hit and Miss

Hi David Here is what I have done I upgraded the database but still the same so: I completely removed PDNS Clean installed PDNS-Server PDNS-backend-mysql PowerAdmin I then used Poweradmin to create 2 domain zones (Same domains I provided in the list where it was erroring on one and positive r

[Pdns-users] gmysql modul, queries and tx_isolation

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 WH