[Pdns-users] very much MySQL QUERY ?

[Andreas Sokov]

Hi, Pdns-users.

Tell me please & and explain what my problems ?
i see in mysql.log many SELECTs - can i do not such load mysql server ?

log following :

060826 22:10:33  155131 Query       select content,ttl,prio,type,domain_id,name from records where name='65.22.124.193.combined.njabl.org'
         155131 Query       select content,ttl,prio,type,domain_id,name from records where name='*.22.124.193.combined.njabl.org'
         155131 Query       select content,ttl,prio,type,domain_id,name from records where name='*.124.193.combined.njabl.org'
         155131 Query       select content,ttl,prio,type,domain_id,name from records where name='*.193.combined.njabl.org'
         155131 Query       select content,ttl,prio,type,domain_id,name from records where name='*.combined.njabl.org'
         155131 Query       select content,ttl,prio,type,domain_id,name from records where name='*.njabl.org'
060826 22:10:35  155150 Query       select content,ttl,prio,type,domain_id,name from records where name='65.22.124.193.dnsbl.sorbs.org'
         155150 Query       select content,ttl,prio,type,domain_id,name from records where name='*.22.124.193.dnsbl.sorbs.org'
         155150 Query       select content,ttl,prio,type,domain_id,name from records where name='*.124.193.dnsbl.sorbs.org'
         155150 Query       select content,ttl,prio,type,domain_id,name from records where name='*.193.dnsbl.sorbs.org'
         155150 Query       select content,ttl,prio,type,domain_id,name from records where name='*.dnsbl.sorbs.org'
         155150 Query       select content,ttl,prio,type,domain_id,name from records where name='*.sorbs.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='65.22.124.193.opm.blitzed.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='*.22.124.193.opm.blitzed.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='*.124.193.opm.blitzed.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='*.193.opm.blitzed.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='*.opm.blitzed.org'
         155166 Query       select content,ttl,prio,type,domain_id,name from records where name='*.blitzed.org'
         155136 Query       select content,ttl,prio,type,domain_id,name from records where name='ns1.regmaster.net'
         155136 Query       select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='ns1.regmaster.net'
         155136 Query       select content,ttl,prio,type,domain_id,name from records where type='SOA' and name='regmaster.net'


         
-- 
 Best Regards, Andreas                          
 Sunday, August 27, 2006 1:24:48 AM

 "Do not hesitate to ask me"
 ICQ UIN 177624
 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation
 http://HOST-LUX.RU      - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month
 http://Reg-Master.net   - Register`s Master of Domains
 http://Web-Media.Ru     - Web Design studio.

 http://VEHICLE.RU       - à âòîìîáèëè íà çà êà ç èç ÑØÀ