On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote:
> Pdns?
Close! bind-dlz
> Anyway, did you enable the slow query logging? That still might give
> you an idea if something is running slow. But I also forgot to ask
> earlier, what is running slow, the inserts or the selects during the
> inserts?
I've been trying to determine if there's a way to enable slow query
logging at runtime. I've made the changes to the config file, but
restarting the database for this stuff is a little dicey and with the
stakes being DNS, I'd rather be conservative!
"set long_query_time=1;" doesnt' seem to have created the slow query
file, so I'm guessing this means a restart?
--
Ross Vandegrift
[EMAIL PROTECTED]
"The good Christian should beware of mathematicians, and all those who
make empty prophecies. The danger already exists that the mathematicians
have made a covenant with the devil to darken the spirit and to confine
man in the bonds of Hell."
--St. Augustine, De Genesi ad Litteram, Book II, xviii, 37
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
