Chris wrote: > I'd see if you can get logging enabled.
I will do that next visit, yes. I was pushed for time - in between 2 other commitments, and wasn't expecting problems. > When the pauses happen try a 'show process list;' and see what else > mysql is doing at the time. Maybe you have a deadlock situation - > client "a" and "b" are trying to access the same table at the same > time and it's conflicting in a strange way. The process list may give > you some further ideas. I didn't think of that, but I did restart MySQL a couple of times, and this was after-hours, so I would be surprised if anyone else was on the system at the time. But I'll do that too, thanks. > Are you using the ip address to connect to the server or a name? I tried both. They were using a FQDN with an internal DNS server, but I switched it to using the IP address. It didn't affect anything. > Can the server resolve the names that are connecting to it? (ie is > reverse dns set up properly). Um. Don't know that one. I'll forward this off to their IT guy and see. Thanks for the quick response :) Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
