Description:
|
I have a search script that works really good when there is no traffic to it,
but when you start getting multiple requests it doesn't work at all. I am
getting about 16,500 hits to the script a day (the load is balanced between two
servers), and it will not provide search results anymore unless you are lucky
enough to find a low traffic period. You just sit there until it times-out. To
me it seems like there is a lock on a file and everyone is waiting their turn.
In heavier traffic situations, requests will continue to build until they end up
overloading the MySQL server. I need someone to find the problem here and fix
it.
The logs pretty much always look like this:
Read POST information timed out
client stopped connection before rvputs completed
Also, within admin there is a spot to set how often the stats are calculated. I
would like this option seperated from the rest of the script so that I can run
it as a cron job and not have it burden an unfortunate users experience.
This script can be seen at http://www.globalppc.com
Additional Info (Added 2/1/2005 at 0:16 EST)...If I
let the search timeout, sometimes I will get some errors displayed on the
screen. Generally these point to line 123 of functions.inc.php
I copied that subroutine to http://www.globalppc.com/subroutine.txt
Line 10 of this file is line 123 of functions.inc.php
Additional Info (Added 2/1/2005 at 0:53 EST)...In
looking at some of the MySQL Logs I noticed this under the current locks, which
assures me that this is where the issue lies, but I still don't know what is
causing it.
Current locks:
lock: 91de064: write write_wait read_wait
write : f4d39458 (4118760368:10),
write_wait: 91ccab8 (4113939376:10), 91d8d58 (4117924784:10), f4d1c648
(4114357168:10), f4cd4ba0 (4113869744:10), 91bd7e0 (4118203312:10), 9376730
(4114774960:10), f4e78488 (4118481840:10), 95a7e80 (4117023664:10), 91d2228
(4115192752:10), f50570c0 (4114705328:10), f4cd5638 (4116954032:10), f4d251f0
(4116675504:10), f4e77340 (4119526320:10), f4d46528 (4119665584:10), 931d0a0
(4115471280:10), f4d1db78 (4118690736:10), 9206390 (4116306864:10), 95f1680
(4116167600:10), 91b1cb0 (4116376496:10), 91d1650 (4114148272:10), 95eb468
(4112374704:10), 91b4f98 (4115123120:10), 9214980 (4117994416:10), f4cd8608
(4118133680:10), 91ceb30 (4114078640:10), 930c158 (4116097968:10), f4d45a90
(4116237232:10), 9418a90 (4112513968:10), f4d30ed8 (4117785520:10), f4d37928
(4119317424:10), f4d24230 (4116446128:10), 91eaac0 (4116884400:10), 9257d88
(4120148912:10), 92861e0 (4116605872:10), 9834540 (4113660848:10), f4d40788
(4115540912:10), f4d350d0 (4114496432:10), 92cc150 (4118272944:7), f4d36e90
(4114217904:7), f4d22178 (4114009008:7), f4d23758 (4115889072:7), 9308098
(4112165808:7), 9334828 (4115680176:7), 92550d8 (4114914224:7), f50160b0
(4113730480:7), f4ced0e0 (4119456688:7), 9345800 (4119108528:7), f4d27220
(4115332016:7), 9289170 (4115749808:7), f5221c80 (4119178160:7), 9572fc8
(4118969264:7), f4f3cf30 (4119944112:7), f4d41220 (4114287536:7), f4d3c450
(4118899632:7), f4d19b88 (4117441456:7), f4d1d0e0 (4116814768:7), 9652d78
(4114983856:7), f4d47518 (4117371824:7), 9333b10 (4117580720:7), f4d341a0
(4118064048:7), 95865c8 (4112235440:7), f4efc2c0 (4120079280:7), f4d3b9b8
(4114844592:7), f4cd3b50 (4117715888:7), f4d3d258 (4112444336:7), 9349270
(4112305072:7), f52019f8 (4119735216:7), 93bc658 (4119874480:7), 91c7a08
(4115610544:7), 91fd000 (4114635696:7), f4cec260 (4114566064:7), 97a5f68
(4114426800:7), f4d4d7a0 (4116745136:7), 931c608 (4118621104:7), f4cd60d0
(4117511088:7), f4c60798 (4118551472:7), 91da460 (4115053488:7), 91cd9d0
(4117093296:7), 9429f28 (4111956912:7), 984bf80 (4119595952:7), 96522e0
(4112096176:7), 9213ee8 (4115819440:7), 930a6d0 (4118412208:7), f4d1b878
(4115262384:7), f4d42a18 (4118830000:7), 922da28 (4117302192:7), 97a4a38
(4111887280:7), 91c60d8 (4119038896:7), 95ec140 (4117162928:7), 91bea88
(4115401648:7), 982f820 (4119387056:7), f4cde520 (4115958704:7), f4d4b880
(4118342576:7), f4c5fd00 (4117232560:7), 932c0a0 (4116028336:7), 93c35a0
(4112026544:7), 943b040 (4117855152:7),
read_wait : f4d22cc0 (4113800112:1), 93a2918 (4119804848:1), 95c69f8
(4119247792:1),
Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.
Related Projects:
 GETAFREELANCER.com - need a site like this
Dating Site Redesign
Music Hub- Features And Fixes
Getafreelancer.com : Need site like it
Dating site, gay411.com clone
This project is the proprietary information of .
Click here to remove this project from OUR database.
|
