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

Hi, 2016-12-22 9:09 GMT+01:00 Thomas Mieslinger : > > Why is there a reason to use a product like maxscale? A single pdns with a > single mysql should be able to do 1M qps on reasonable hardware. > I use the pdns api for dns updates and i have "a lot of" updates (in peak ~3000) per hour and it g

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

Am 22.12.2016 um 07:24 schrieb bodenhalt...@googlemail.com: 2016-12-21 23:14 GMT+01:00 bodenhalt...@googlemail.com mailto:bodenhalt...@gmail.com>>: And have you an idea for tx_isolation? This is solved. FYI: prepared statements are a "known issue" for

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

[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