|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
08-13-2003, 11:08 AM
|
#1 |
|
So Fucking Banned
Join Date: May 2003
Location: San Pedro, Costa Rica
Posts: 788
|
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!! |
|
|
|
08-13-2003, 11:12 AM
|
#2 |
|
So Fucking Banned
Join Date: May 2003
Location: San Diaygo, CA
Posts: 384
|
What is your ICQ? I'll try to help : )
|
|
|
|
|
08-13-2003, 11:14 AM
|
#3 |
|
So Fucking Banned
Join Date: May 2003
Location: San Pedro, Costa Rica
Posts: 788
|
38373031
thx ;> |
|
|
|
|
08-13-2003, 11:41 AM
|
#4 | |
|
Confirmed User
Join Date: May 2002
Location: CT
Posts: 5,246
|
Quote:
|
|
|
|
|
|
08-13-2003, 11:41 AM
|
#5 |
|
Confirmed User
Join Date: May 2002
Location: CT
Posts: 5,246
|
icq me if you still cant solve it
|
|
|
|
