server performance issues thread

Posted: Tue Jan 18, 2011 10:04 am

SSSSSH, It might hear you. peeper

Posted: Tue Jan 18, 2011 11:34 am

About it , Frank ... LOL

Posted: Fri Jan 21, 2011 12:00 am

Am I the only one who keeps having their replies go to site not available? It's been going on for about three days now. I post, submit, site not available, back to index or other topic, reload, select

Posted: Fri Jan 21, 2011 12:06 am

When that happens, I usually find that if I just go back two times to the page where I originally hit the reply button, then hit the refresh button on the browser, that the post is usually there on the thread, it just never came back up afterwards.

When the server response gets crappy, it's the back and forth transactions like hitting the submit button to a "Post a reply" page or "Edit post" page that start messing up first.

Posted: Fri Jan 21, 2011 12:18 am

Ya it has my post and I have been doing like you said. I may just notice it more since I have a post almost every day Wink

Posted: Fri Jan 21, 2011 6:43 am

I was having trouble with all web pages for a while last night. I think my ISP was screwing around with the system. Rolling Eyes

Posted: Tue Mar 01, 2011 10:57 am

Site is wacked out today

Posted: Tue Mar 01, 2011 11:17 am

I'm having no problems , Frank .

Posted: Tue Mar 01, 2011 7:02 pm

Just didn't like me this morning I guess. Ate two of my posts even though I know all the tricks to get them to stay. Was getting an error message after all of them or wouldn't let me change topics. I just gave up and did other important Frank stuff

Posted: Tue Mar 01, 2011 9:22 pm

Didn't see it, I was busy from 4am - 2pm Confused

Posted: Tue Mar 22, 2011 6:26 pm

Did anyone have troubles with extremely slow page loads this morning other than me? Rolling Eyes

Posted: Tue Mar 22, 2011 6:29 pm

your pages loaded? Rolling Eyes

Posted: Tue Mar 22, 2011 6:54 pm

This morning was, and now is, way better than yesterday was for server performance to here Wink

Posted: Tue Mar 22, 2011 7:53 pm

early am yesterday was fast about 2am

Posted: Mon Apr 04, 2011 11:20 am

The server is often slow to me and it seems slow from my work today. And I have a blazing fast connection.
The first "code" block is a traceroute and it looks like a few of the cox routers in South Dakota is taking its sweet time... but nothing unusual.

Code:

traceroute to www.cb750.com (216.104.161.203), 30 hops max, 60 byte packets


 1  156.26.2.5 (156.26.2.5)  0.933 ms  1.142 ms  1.642 ms


 2  156.26.248.241 (156.26.248.241)  0.801 ms  0.799 ms  0.785 ms


 3  kr-wsu-jh-ve600.kanren.net (164.113.216.65)  0.678 ms  0.680 ms  0.680 ms


 4  wsip-68-106-191-225.ks.ok.cox.net (68.106.191.225)  0.864 ms  0.896 ms  1.135 ms


 5  70.183.71.77 (70.183.71.77)  0.772 ms  0.790 ms  0.789 ms


 6  kscydsrj01-ae2.rd.ks.cox.net (70.183.71.101)  7.803 ms  17.215 ms  7.795 ms


 7  70.183.71.61 (70.183.71.61)  7.802 ms  7.798 ms  7.785 ms


 8  elcndsrj01-ae0.0.rd.sd.cox.net (68.1.1.251)  48.821 ms  48.836 ms  48.879 ms


 9  elcniesa01-get030201.sd.sd.cox.net (68.6.8.165)  50.991 ms  51.035 ms elcniesa01-get030200.sd.sd.cox.net (68.6.8.213)  51.009 ms


10  wsip-98-173-158-171.sd.sd.cox.net (98.173.158.171)  60.501 ms  60.529 ms  60.531 ms


11  ftp.cannadx.com (216.104.161.203)  59.787 ms  59.743 ms  60.039 ms

Below is a sample of time and wget...(web get) It took 19 seconds to pull down the page, Thats not as slow as I have seen it... but its not exactly fast.

Code:




 time wget -v www.cb750c.com


--2011-04-04 09:31:05--  http://www.cb750c.com/


Resolving www.cb750c.com... 216.39.62.189, 216.39.62.190, 216.39.62.191


Connecting to www.cb750c.com|216.39.62.189|:80... connected.


HTTP request sent, awaiting response... 200 OK


Length: unspecified [text/html]


Saving to: `index.html'





    [ <=>                                                                                       ] 1,284       --.-K/s   in 0s      





2011-04-04 09:31:09 (85.4 MB/s) - `index.html' saved [1284]





real   0m19.763s


user   0m0.000s


sys   0m0.010s

If the admins don't mind I can perl up a check script and perhaps get you some metrics, just on hitting the main page. Does anyone have commandline access to this box? Has anyone investigated the php tuning options? It may be that php doesn't have the resources it needs to run as fast as it could. BTW if this box is windows, I'll be able to help but it will take me a bit longer, it's not what I do all day. Unlike unix/linux, which is my bread and butter.
Let me know, I'd like to help.

BTW, NukeSentinel blocked my "usual" IP 156.26.2.17 probably due to traceroute and wget (which can be used for harvesting but I was just trying to get some quick metrics) could someone realease this IP when they get a chance?
Thanks,

Posted: Mon Apr 04, 2011 12:15 pm

Ok Its my experience that the site is slow before you browse to the Forums section. At this point there the site should be doing very little in the way of sql connections, except NukeSentinel(tm) 2.5.08 might be checking IP addresses.
This may be a place to start looking for a problem. Whoever has access may want to check for the following line in the nukesentinel.php script

Code:

$checkrow = $db->sql_numrows($db->sql_query("SELECT * FROM `".$prefix."_nsnst_ip2country`"));

it may be possible improve performance by replacing the above line with

Code:

$checkrow = $db->sql_numrows($db->sql_query("SELECT * FROM `".$prefix."_nsnst_ip2country` LIMIT 0,1"));

Here's a link I found on the subject, if you have already been down this road, sorry for the duplication, and if not I hope this helps.
http://www.ravenphpscripts.com/posts12658-view-next.html

Posted: Mon Apr 04, 2011 9:59 pm

We think it's actually the webserver, not the database server, causing the sporatic performance issue. Yahoo has been contacted for us about the issue.

The reason we think so, is that we can't access the maintenance tools either, that don't even need the database server to access the login screen.

Posted: Mon Apr 04, 2011 11:09 pm

I'll give the checkrow edit a try. Thanks! Reminds me I need to update the ip2country list, too.

Gene, the majority of issues are accessing the SQL server. Now, it may be the poor server or our poor config but probably is a combo of both.