Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2012-01-04 Thread Daniel L. Miller
On 12/29/2011 12:55 AM, Fabio Sangiovanni wrote: Hello list, I'm a newbie of pdns and I'm setting up a recursor-only installation as local dns cache for a high load smtp server. I'm using the lua scripting feature as a way to track down MX queries. In particular, the preresolve() function

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2012-01-04 Thread Peter van Dijk
On Jan 5, 2012, at 4:31 , Daniel L. Miller wrote: lock table ; update bigtable set queries = queries + 1 where mxip = parameter ; unlock table This update-query does not have a race-condition. The locks are not necessary :) Kind regards, Peter van Dijk

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2012-01-02 Thread Fabio Sangiovanni
Hi Bert, are you planning to run multiple Lua sessions per thread in the future (in PowerDNS Recursor)? If yes, do you think it will be possible to have a switch for this feature in recursor.conf? I need to make a decision for my company about the use of PowerDNS Recursor in a project and

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-30 Thread Fabio Sangiovanni
Hi Nils, thanks for your reply. Database transactions help in terms of integrity, but they can do nothing about the order of data updates. If 2 threads work independently and execute the same update query on the db, I can't predict with certainty which one will occur first. Fabio Il giorno

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-30 Thread Nils Breunese (Lemonbit)
Fabio Sangiovanni wrote: Database transactions help in terms of integrity, but they can do nothing about the order of data updates. If 2 threads work independently and execute the same update query on the db, I can't predict with certainty which one will occur first. AFAIK no updates are

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-30 Thread Fabio Sangiovanni
Hi, thanks for your reply. Il giorno 30/dic/2011, alle ore 09:43, bert hubert ha scritto: On Thu, Dec 29, 2011 at 08:55:57AM +, Fabio Sangiovanni wrote: am I right thinking this would solve my problem? For now, and for this version of the PowerDNS Recursor, if you set threads to 1, you will

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-30 Thread Fabio Sangiovanni
Ok I'm kind of a newbie here :) My understanding of the problem is: if I have 2 threads, running at the same time, both of them executing the same SQL transaction (made up of more select or update queries), how can I predict which one is executed first? It's just like you said: I'd need the

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-30 Thread Aki Tuomi
On Fri, Dec 30, 2011 at 10:00:50AM +, Fabio Sangiovanni wrote: Ok I'm kind of a newbie here :) My understanding of the problem is: if I have 2 threads, running at the same time, both of them executing the same SQL transaction (made up of more select or update queries), how can I predict

[Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-29 Thread Fabio Sangiovanni
Hello list, I'm a newbie of pdns and I'm setting up a recursor-only installation as local dns cache for a high load smtp server. I'm using the lua scripting feature as a way to track down MX queries. In particular, the preresolve() function relies on luasql to execute queries on a (local)

Re: [Pdns-users] pdns recursor - unthreaded vs threaded operation

2011-12-29 Thread Nils Breunese (Lemonbit)
Fabio Sangiovanni wrote: I'm a newbie of pdns and I'm setting up a recursor-only installation as local dns cache for a high load smtp server. I'm using the lua scripting feature as a way to track down MX queries. In particular, the preresolve() function relies on luasql to execute queries