Possible? Are you sure all connection attempts fail? not just insert attempts?
Server B does some updates/deletes... Chances are this causes some table locks, which makes Server A unable to perform it's inserts until Server B releases the lock. On Wed, 13 Aug 2003, Keith Bussey wrote: > Hi, I am having a very weird problem with one of my database servers. > > Let's take the following setup: > > 10 load-balanced servers (I'll call them ServerA) > 1 admin server (ServerB) > 1 database server (DB1) > > Now ServerA has a function to insert a row into a table on DB1 whenever someone > hits certain pages (for stats collection). There are probably about 1000 inserts > being done per second. > > 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. > > Everytime the script on ServerB runs, all attempts to connect to DB1 from > ServerA fail. This causes major problems like causing server load on ServerA to > rise dramatically. > > I have checked when the script runs, everything on DB1 is normal. Server load, > mysql processes, no locks, etc... > > I also have it logging the connection failures with mysql_error but mysql_error > turns up blank. > > Can anyone try and help me figure out what's going on here!? Why won't it > connect during the period the script runs and why is mysql_error blank? > > Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13 > > Thanks!! > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 > > > > > -- > 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]