Out of curiosity, how many queries/sec are you able to push from each slave? If I may ask.. :)
Atle On Mon, 5 Mar 2007, Ross Vandegrift wrote: > 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]
