Our Community is 940,000 Strong. Join Us.


Progress in pinpointing the issue


igor@af
09-20-2003, 12:02 PM
After more than 40 cumulative hours of work by both professional server techs and myself, we have been able to finally pinpoint the problem. It appears to reside with a faulty mysql query that is initially executed for every page by every user while they are browsing the message board. On the current setup of running everything on one server, this query takes
0.015040993690491 seconds
keep in mind that this is with dozens if not a hundred concurrent users accessing the message board at the same time.

However, this exact same query takes
1.5099580287933 seconds
to execute on the new database server when there is absolutely no one except for myself accessing the database.

This is most likely why the server choked whenever we tried to switch to using the remote database.

I am hoping to have the second server running without issues by the end of today. Wish us luck!

ales
09-20-2003, 12:06 PM
Good luck, our firendly admin!

badassgremlin
09-20-2003, 08:36 PM
well i guess you gotta fight for your right to party.......good luck man. :thumbsup:

Import_Tuner
09-21-2003, 02:30 PM
Hey
I used to run a decent website with a forum and also had a mySQL database and when I first set it up it was hell :disappoin but then I got there and im sure you will too. Thanks for trying to get us all the best service, keep it up friendly admin! :evillol:

YogsVR4
09-22-2003, 10:54 AM
Gotta say I am not a big fan of mySQL yet. Iíve spent to much time in MSSQL, Oracle and Iíve spent to much time in MSSQL, Oracle and Interbase then mySQL. Open source is ok, but it does have its limitations and support issues that you donít get with the others.

Hope everything works out tuning the server. Looking forward to the better and faster AF :smile:













Never pay again for live sex! (http://showmewebcam.com/?p=1) | Hot girls doing naughty stuff for free! (http://showmewebcam.com/?p=3) | Chat for free! (http://showmewebcam.com/?p=5)

TexasF355F1
09-22-2003, 09:11 PM
Good luck Igor. And take all the time you need, I see no need to rush perfection.

igor@af
09-22-2003, 10:17 PM
UPDATE:

The theory on how to fully resolve the issue has been perfected and all that is left now is to execute it. PHP will need to be recompiled with some special options and the coding required for the change should be done sometime tomorrow.

badassgremlin
09-23-2003, 05:19 PM
Yay For A $7,000 Server! Igor You Da Man! :)

Add your comment to this topic!