Help needed: Very strange mysql problem!!
 

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!!

What is your ICQ? I'll try to help : )

38373031

thx ;>

use lowpriority

icq me if you still cant solve it