Re: Core dumps

Here is a new an interesting thing I just noticed.  I turned on mysql  
query logging to be able to see if any one query in particular was  
causing an issue.

I kept similar to this:
090508  3:09:34	     24 Query       SELECT zone FROM resource_records  
WHERE zone = 'www.a.com'
		     24 Query       SELECT zone FROM resource_records WHERE zone =  
'a.com'
		     24 Query       SELECT zone FROM resource_records WHERE zone =  
'com'

That is the result of one dig:
dig  www.a.com @ns1.example.com SOA

Why is it spitting it up and trying all three?

I can make some pretty cool looking logs with this, which can not be  
nice on the DB, let alone the fact that people could use this to beat  
the heck out of any DLZ db out there...

dig a.b.c.d.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com  
@ns1.example.com SOA

SELECT zone FROM resource_records
	WHERE zone = 'a.b.c.d.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records
	WHERE zone = 'b.c.d.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'c.d.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'd.e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'e.f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'f.g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'g.h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'h.i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'i.j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'j.k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'k.l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'l.m.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'm.n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'n.o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'o.p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone =  
'p.q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'q.r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'r.s.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 's.t.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 't.u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'u.v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'v.w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'w.x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'x.y.z.com'
SELECT zone FROM resource_records WHERE zone = 'y.z.com'
SELECT zone FROM resource_records WHERE zone = 'z.com'
SELECT zone FROM resource_records WHERE zone = 'com'

Suggestions?
-- 
Scott * If you contact me off list replace talklists@ with scott@ *


------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com