Quoting [EMAIL PROTECTED]: > 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 > 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. ServerB's updates/deletes are on a different database server though (as stated below ;p)...so it shouldn't factor in here at all. > 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]
