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
_
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 reli
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 every
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
> pre
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 whole
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
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 a
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 really only get 1 simultaneous Lua session.
However, this is not true in other parts of P
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 30
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 querie
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) mysql
11 matches
Mail list logo
