I'd double check this cronjob script... possible scenario.. kaibash idea if you can prove it's invalid.
"> ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server." running a select on a server with 1000 inserts a second will take alot longer than if the query had a table lock. Also if the query has anything to do with stats, etc, not having a read lock and inserts going on could affect results and result speed. Perhaps it aquires a read lock before running the query? I'd dig thru the code/sql / use show processlist to disprove this theory. On Wed, 13 Aug 2003, Keith Bussey wrote: > That's the problem, when the script runs, I can connect from serverA fine!...but > seems the webpages can't ;/ > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 > > > Quoting [EMAIL PROTECTED]: > > > > > On Wed, 13 Aug 2003, Keith Bussey wrote: > > > > Are you sure all connection attempts fail? not just insert attempts? > > > > > > Yes, i have it write to my log if the sock is empty (mysql_connect > > > fails)...before it gets to the insert > > > > But you mention mysql reports no connection errors... perhaps wait for an > > update, and from ServerA, use mysql client: > > > > mysql --user=asdf --password=asdf --host=DB1 > > > > see if you can get online.. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
