[Pdns-users] Couting Domain Queries

[Sherwin Daganato]

On Fri, Feb 20, 2004 at 09:32:07PM -0000, AJ McKee wrote:
> I was just reading through some of the docs here and an idea hit me. Is
> it possible to have PDNS add to a counter table everytime a domain or a
> host is looked up some information, like say date of lookup number of
> lookups sofar etc etc, and if so what would the impact be on
> performance? I am wondering if you could do it in the pdns.conf file
> even using the gmysql=INSERT into DomainUsage ...."?

The answer is SQL trigger. You can do this with PostgreSQL. Head over to 
http://www.postgresql.org/docs/7.4/static/triggers.html for more
information.

HTH