Tom Collins wrote:
I have plenty of logging, the querys are in one log, and the errors are in other. The query log is not timestamped consistantly, IE not every record. Makes determining a cause tough. I can see only what DB was accessed and by what user, pass, IP.On Oct 19, 2004, at 8:14 PM, Charles Sprickman wrote:
The one thing that kind of grabbed people's interest was the flood of "connection dropped" messages that mysql will log if I enable the "log warnings" option. On other mysql installations I can leave this on and I just see the occasional error. If I point vpopmail at a db with the logging enabled, it just scrolls errors like mad.
Is there any way to find out what program was responsible for creating the connection that was dropped? Can you add additional logging to find out what queries are made on the dropped connections before they get dropped? If there's a pattern, we might be able to track down the offending program and fix it.
I've been trying to get better logging, the mysql list, and forums have not responded. I'm hitting a dead end as far as getting more information.
DAve
-- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
