[Fixed!] Slowness r...
 
Notifications
Clear all

[Fixed!] Slowness recently

(@teebling)
Noble Member

Hey guys. Super short on time here - I have a big list of things I need to do for the site tomorrow afternoon which is the only time I’ll get inbetween the mad studying.

There’s definitely a slowdown on all viewtopic.php pages after patch 1.9 - could anyone savvy here help me save some time by web inspecting the page load and posting results here with a view to identifying what the offending script/element is that is causing this slowdown? I’d do it myself ofc but don’t have access to my computer right now etc.

I have a feeling its some external script or perhaps a server performance issue with dreamhost but just a guess.

Sorry guys for not seeing this straight away - hope to fix asap and that it hasnt been too annoying.

Edit: think it's fixed!

Quote
Topic starter Posted : 28/04/2019 4:30 am
(@forsakenone)
Estimable Member

Not too worry. BC is epic even when it's slow 😘

ReplyQuote
Posted : 28/04/2019 4:34 am
(@kchlangendin)
Estimable Member

Let me check it

ReplyQuote
Posted : 28/04/2019 4:51 am
(@kchlangendin)
Estimable Member

So after a minor investigation even to barren's zhevra its clear the slowliness causes server-side problem ttbf delay, i've checked every issues that takes more than 3000 ms. The most longest took me almost 19000 ms. First googled link might help.

ReplyQuote
Posted : 28/04/2019 5:05 am
(@nymis)
Reputable Member

Yup, it's the TTFB. Longest took me 12.3s.

ReplyQuote
Posted : 28/04/2019 5:30 am
(@uncle-ganus-mcanus)
Estimable Member

By the https://classic.wowhead.com/spell=25185/itch of https://classic.wowhead.com/npc=2669/sheri-zipstitch , I say ! It's too many https://classic.wowhead.com/spell=16142/cadaver-worms like Nymbus crawling around here combined with https://classic.wowhead.com/item=5272/insane-scribbles from the likes of Iron Schnitzler !! Not even Barrens can hold so much https://classic.wowhead.com/object=242521/disturbed-dirt at once !!!

ReplyQuote
Posted : 28/04/2019 9:07 am
(@executive)
Eminent Member

Just refreshing this page with an inspector window open, all scripts/resources seem to take a standard amount of time, except for viewtopic.php itself, which is stuck in 'waiting for server' for 2369ms. Everything else takes less than 200ms for the entire load, viewtopic.php is 2446ms for the entire load. It's either something with the server or something the php itself.

Looking at the flame chart, there's no outright problems with DOM rendering or JS execution. You'll need to debug the PHP, which we can't do on our side.

EDIT: Posting this was a 10155ms 'waiting', again no DOM/JS execution issues. I think something in the PHP is just hammering your server.

EDIT2: Now that I think about it, some of your questions in the 'Help getting Blizzard API working' concern me. You aren't making API calls in the PHP, are you?

ReplyQuote
Posted : 28/04/2019 10:29 am
(@teebling)
Noble Member

No not using viewtopic.php for that at all. Will have to debug php message this when im back tomorrow. Thanks for the help so far boys.

ReplyQuote
Topic starter Posted : 28/04/2019 11:14 am
(@escalotes)
Estimable Member

Nothing to add, just chiming in to confirm recent slowness from both my work VPN and home network.

ReplyQuote
Posted : 28/04/2019 5:56 pm
(@teebling)
Noble Member

Hey I had a more detailed look at this issue today. Getting loads of errors like this in my server log and most of them are about viewtopic.php:
[Mon Apr 29 09:59:44 2019] [warn] [client xxx.xxx.xx.xxx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: https://barrens.chat/viewtopic.php?f=3&t=1314&p=8953
[Mon Apr 29 09:59:44 2019] [error] [client xxx.xxx.xx.xxx] Premature end of script headers: posting.php, referer: https://barrens.chat/viewtopic.php?f=3&t=1314&p=8953

I've contacted my hosts about it as I believe that their FastCGI server config might be to blame or has gone through some changes which are still cached server-side or something like that. I'd reset apache or whatever if I had access but I don't because I'm on a shared plan.

Seeing some really high latency and it's before even making the request. Something definitely getting hung up on:

I just don't know what the issue is because debug messages show nothing out of the ordinary and the only indication that something is wrong (aside from the obvious latency) is the errors.

I went back through my changelogs for 1.9 and rolled back new stuff I put in, then tested, but doesn't seem to have made a difference. So yeah, will update you guys when my hosts get back to me.

Soooo sorry about this.

ReplyQuote
Topic starter Posted : 29/04/2019 10:13 am
(@teebling)
Noble Member

Update, think I may have improved the situation - has anyone else noticed it speed up a little bit?

I sometimes still get 1-2 seconds latency which isn't good but it's better than before I think?

Edit: think it's fixed!

ReplyQuote
Topic starter Posted : 30/04/2019 2:31 am
(@jalapeno)
Eminent Member

Def better now yes!

ReplyQuote
Posted : 30/04/2019 2:41 am
(@defuzed)
Trusted Member

It is indeed a lot faster than before, think yesterday I had a delay of 15 seconds +, but now it seems to be 1-3 seconds.

ReplyQuote
Posted : 30/04/2019 2:51 am
(@ironbrutzler)
Reputable Member

Jep opening new threads is now way better

ReplyQuote
Posted : 30/04/2019 3:03 am
(@nymis)
Reputable Member

teebling Could you tell us what was wrong on the backend side of things? I'm just learning to work with backend in PHP at work right now and I'd be curious to hear about it. :lol:

ReplyQuote
Posted : 30/04/2019 3:24 am
(@teebling)
Noble Member

@teebling Could you tell us what was wrong on the backend side of things? I'm just learning to work with backend in PHP at work right now and I'd be curious to hear about it. :lol:

To tell you the truth mate I have no idea.

I did a few things backend and any one of them could have fixed the issue:

  • Changed PHP version to 7.1 CGI, killed off PHP processes, changed PHP version back to original 7.2 FastCGI, killed off PHP processes

  • Re-uploaded my phprc file to the default one provided

  • Checked permissions on viewtopic.php were correct

  • Disabled this weird 'extra security' thing that dreamhost were offering me, don't know what it did anyway

  • That's all I could do back end - I don't run the server myself (shared hosting) so my options were pretty limited. If I had control over the server itself I would have made sure that memory limits set correctly, restarted Apache etc. etc.

    ReplyQuote
    Topic starter Posted : 30/04/2019 3:43 am
    (@escalotes)
    Estimable Member

    Way to go teebling!

    ?

    ReplyQuote
    Posted : 30/04/2019 9:09 am
    (@executive)
    Eminent Member

    Disabled this weird 'extra security' thing that dreamhost were offering me, don't know what it did anyway

    Somewhere a sysadmin is screaming and doens't know why.

    ReplyQuote
    Posted : 30/04/2019 3:21 pm