As anyone who has tried knows, setting debug=1 in the aolserver
configuration fills up your hard drive with a torrent of data of which
only a tiny fraction is useful for debuging. Most of this spew is
internal logging of the query dispatcher but it's in other places as
well. however, there is some bits of useful information about the
currently running query in the haystack: is it in a tcl library or a
www page? what's the query's full name, etc.
I've hacked the most of the files that contribute to this. I didn't
remove any of the logging calls, but rather added a few simple procs
so that if you want all the QD, XML parsing, SC or APM
debugging turned on you just change a string from "QDDebug" to
"Debug", for example. I didn't change the warning messages like "No
fullquery for foo.."
I've cleaned the restart spew to 3 lines perparsed file.
Each query is now prefaced with a line like:
[13/Aug/2002:20:33:47][20836.4101][-conn1-] Debug: db_qd_get_fullname:
following query in file: packages.acs-tcl.tcl.acs-permissions-procs
proc: permission::permission_p
that tells you exactly where it is and what it's called. you still get
the query output 4 times, but that's in the driver, i believe. I'd
like to see each query twice, with and without bind vars. Hint, hint
DanW :)
If there are no objections to this, i'll be committing these changes
tomorrow.