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

2016-12-21 Thread bodenhalt...@googlemail.com
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/lim

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

2016-12-21 Thread bodenhalt...@googlemail.com
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

[Pdns-users] gmysql modul, queries and tx_isolation

2016-12-21 Thread 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 WH