OldNick Posted 8 September, 2020 Share Posted 8 September, 2020 2 hours ago, Wurzel said: I can't get into the bedroom, but that's down to the wife, I'm not blaming @stevegrant for that one.🤣 Lol not blaming Mr Grant just providing helpful information lol Link to comment Share on other sites More sharing options...
stevegrant Posted 8 September, 2020 Share Posted 8 September, 2020 2 hours ago, Lord Duckhunter said: The lounge does seem to be an issue Wonder if that might be as a result of the huge threads in that forum. In theory it shouldn't make any difference as it should only be looking at the topic itself, not any of the posts inside, but the way some of this site works under the hood, I wouldn't be surprised if there's some horrendous query that's slowing it down Link to comment Share on other sites More sharing options...
Fatboy40 Posted 8 September, 2020 Share Posted 8 September, 2020 On 06/09/2020 at 15:02, stevegrant said: phpBB still exists, but it's pretty basic these days... Basic is good, unless you need embedded advertising etc., less to go wrong and I think it scales quite well 😄 Do you mind if I ask what DB you're running this forum on? Is it one of Amazon's own... https://aws.amazon.com/products/databases/ ... or a different one hosted in a VM on AWS? Link to comment Share on other sites More sharing options...
striker Posted 8 September, 2020 Share Posted 8 September, 2020 On 05/09/2020 at 16:20, aintforever said: It wasn’t working at all for me then I went into notifications settings and turned them all off and now it’s fine. I can start posting crap again now. Yes, this worked for me too. Once I turned off all notifications it runs much faster. I wonder if there is an issue there? Link to comment Share on other sites More sharing options...
Plastic Posted 8 September, 2020 Share Posted 8 September, 2020 (edited) 17 hours ago, stevegrant said: Must admit I'm not 100% sure where I'd isolate any of those issues, tbh. @stevegrant - Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience. Quote C:\Users\xxx>ping www.saintsweb.co.uk Pinging dan1o7ct3u5eb.cloudfront.net [99.86.249.62] with 32 bytes of data: Reply from 99.86.249.62: bytes=32 time=14ms TTL=233 Reply from 99.86.249.62: bytes=32 time=15ms TTL=233 Reply from 99.86.249.62: bytes=32 time=13ms TTL=233 Ping statistics for 99.86.249.62: Packets: Sent = 12, Received = 12, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 13ms, Maximum = 26ms, Average = 15ms C:\Users\xxx>ipconfig -flushdns Windows IP Configuration Successfully flushed the DNS Resolver Cache. C:\Users\xxx>ping www.saintsweb.co.uk Pinging dan1o7ct3u5eb.cloudfront.net [99.86.249.11] with 32 bytes of data: Reply from 99.86.249.11: bytes=32 time=13ms TTL=234 Reply from 99.86.249.11: bytes=32 time=14ms TTL=234 Ping statistics for 99.86.249.11: Packets: Sent = 15, Received = 15, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 13ms, Maximum = 31ms, Average = 15ms Edited 8 September, 2020 by Plastic 1 Link to comment Share on other sites More sharing options...
benjii Posted 8 September, 2020 Share Posted 8 September, 2020 2 minutes ago, Plastic said: @stevegrant - Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience. I was going to say that too. 3 Link to comment Share on other sites More sharing options...
Lord Duckhunter Posted 8 September, 2020 Share Posted 8 September, 2020 2 hours ago, stevegrant said: Wonder if that might be as a result of the huge threads in that forum. In theory it shouldn't make any difference as it should only be looking at the topic itself, not any of the posts inside, but the way some of this site works under the hood, I wouldn't be surprised if there's some horrendous query that's slowing it down Appreciate your hard work, there must be times you wonder if it’s worth it. I haven’t got a clue about these sort of things, but is it worth adding another sub forum, a Lounge mk 2 sort of thing. I’d imagine people will only be interested in saving the Pompey thread, every other topic could be discussed afresh. Link to comment Share on other sites More sharing options...
trousers Posted 8 September, 2020 Share Posted 8 September, 2020 47 minutes ago, Plastic said: @stevegrant - Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience. Beat me to it Link to comment Share on other sites More sharing options...
The Kraken Posted 8 September, 2020 Share Posted 8 September, 2020 Link to comment Share on other sites More sharing options...
stknowle Posted 8 September, 2020 Share Posted 8 September, 2020 2 hours ago, Plastic said: @stevegrant - Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience. Think you’re looking too deeply into it. There’s a gremlin in the system, that’s all. Link to comment Share on other sites More sharing options...
Shroppie Posted 8 September, 2020 Share Posted 8 September, 2020 2 hours ago, Plastic said: Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience. Can't believe it was so simple. 1 Link to comment Share on other sites More sharing options...
Saint Billy Posted 8 September, 2020 Share Posted 8 September, 2020 (edited) I have been unable to get on for a few days now but managed to via the back door method today but still couldn’t access the main board, so I logged out and logged in again and now I can get on the main board with speed, still cannot get into the Lounge though. Would it have anything to do with cookies on our pc’s etc from the old database screwing up the present system?. Btw, I can get on the lounge now, everything really fast. Edited 8 September, 2020 by Saint Billy Link to comment Share on other sites More sharing options...
stevegrant Posted 8 September, 2020 Share Posted 8 September, 2020 7 hours ago, Fatboy40 said: Basic is good, unless you need embedded advertising etc., less to go wrong and I think it scales quite well 😄 Do you mind if I ask what DB you're running this forum on? Is it one of Amazon's own... https://aws.amazon.com/products/databases/ ... or a different one hosted in a VM on AWS? We're using an AWS MariaDB instance - not one of the most powerful ones, but it should be plenty for what this place does. In fact, the day/night of the Man City game during the restart when we set our new record for most people online simultaneously, we were actually on a smaller DB instance than we have now and it held firm. There's no real correlation between traffic and performance. 6 hours ago, Plastic said: @stevegrant - Sorry I'm not a website guy, but I can see where redirection issues may be causing problems. The site address is an alias for your cloudfront load balancer (dan1o7ct3u5eb.cloudfront.net) which has multiple VIPs, I was having a site performance issue so I flushed my DNS and received one of the alternate VIPs (see below) which seemed to resolve the 'waiting for cache' browser issues. Do you have the ability to scale your load balancer back to a single VIP to rule out a routing or DNS timeout issue? It may also be that TTL or similar records on the load balancer need tweaking. As I say, not a website guy so lots of speculation here based on infrastructure experience I don't think I have the option to do that, but will have a poke around to see if it's possible. 1 Link to comment Share on other sites More sharing options...
manzo Posted 9 September, 2020 Share Posted 9 September, 2020 On 06/09/2020 at 19:51, Plastic said: @stevegrant someone mentioned incognito mode / cleared cookies yielded a quicker response and I have to say I’ve seen similar. Although you may have a DB latency issue, I wonder if you may also be caching dynamic load balancer / responding node addresses in-browser which are causing the bad gateway issues. worth a look anyway as I can’t see any reason why high latency DB queries would resolve to a bad gateway response. Is that not more likely that as you're not logged in, it's going to query the database a lot less when you come to the site, as it's not getting the data to show if there are unread posts in each thread, whether you've posted in any threads? From what Steve has said, this just sounds like thoroughly shite software. The lack of database indexes alone is, frankly, unbelievable. That gives me little confidence that the new version of the software will be much better, unless they've got some new people on board who actually have the slightest clue how to design and code a low-to-middling performing website. If the Lounge is still struggling, is it worth attempting to add some database indexes? I know that they can take days to add, but it could solve all the performance issues. Link to comment Share on other sites More sharing options...
Saint Billy Posted 9 September, 2020 Share Posted 9 September, 2020 Struggled again to get on this morning, eventually found an open back door, oh matron!. Link to comment Share on other sites More sharing options...
alehouseboys Posted 9 September, 2020 Share Posted 9 September, 2020 On 05/09/2020 at 22:20, aintforever said: It wasn’t working at all for me then I went into notifications settings and turned them all off and now it’s fine. I can start posting crap again now. 18 hours ago, striker said: Yes, this worked for me too. Once I turned off all notifications it runs much faster. I wonder if there is an issue there? Yep, did this too and now appears to have sorted the getting-in issues.... Link to comment Share on other sites More sharing options...
jasonb Posted 9 September, 2020 Share Posted 9 September, 2020 35 minutes ago, alehouseboys said: Yep, did this too and now appears to have sorted the getting-in issues.... Wow. Turned everything off and the site is blazing fast. I dont need all that fancy stuff anyway. Link to comment Share on other sites More sharing options...
RobM Posted 9 September, 2020 Share Posted 9 September, 2020 I'm finding it very consistent now, but not perfect. The initial access takes circa. 30 seconds, it just sits and waits. Once it loads, everything is flying as you'd hope and expect, even if I leave the site for a short while and come back. It's just that initial connection that's the killer, which makes me believe @Plastic is right, and the subsequent TTL means it has to repeat the process each day. Link to comment Share on other sites More sharing options...
kwsaint Posted 9 September, 2020 Share Posted 9 September, 2020 Found that getting into the site using IE is really slow, but worked perfectly well with Firefox. Then went into IE and switched off notifications. Hey presto worked really well. Thanks everyone. Link to comment Share on other sites More sharing options...
Plastic Posted 9 September, 2020 Share Posted 9 September, 2020 2 hours ago, manzo said: Is that not more likely that as you're not logged in, it's going to query the database a lot less when you come to the site, as it's not getting the data to show if there are unread posts in each thread, whether you've posted in any threads? From what Steve has said, this just sounds like thoroughly shite software. The lack of database indexes alone is, frankly, unbelievable. That gives me little confidence that the new version of the software will be much better, unless they've got some new people on board who actually have the slightest clue how to design and code a low-to-middling performing website. If the Lounge is still struggling, is it worth attempting to add some database indexes? I know that they can take days to add, but it could solve all the performance issues. Good point. The change of responding IP via DNS flush did make a difference to load time in a standard session for me though, so I do think there is some load balancing oddness happening. 1 hour ago, jasonb said: Wow. Turned everything off and the site is blazing fast. I dont need all that fancy stuff anyway. Just done the same, and it seems to have worked for me too, though you do need to turn ALL notifications off. Link to comment Share on other sites More sharing options...
Micky Posted 9 September, 2020 Share Posted 9 September, 2020 How do I 'Turn everything off?' Link to comment Share on other sites More sharing options...
skintsaint Posted 9 September, 2020 Share Posted 9 September, 2020 3 minutes ago, Micky said: How do I 'Turn everything off?' Alt+F4 1 Link to comment Share on other sites More sharing options...
Micky Posted 9 September, 2020 Share Posted 9 September, 2020 1 minute ago, skintsaint said: Alt+F4 That was funny. Ta Link to comment Share on other sites More sharing options...
Plastic Posted 9 September, 2020 Share Posted 9 September, 2020 (edited) 28 minutes ago, Micky said: How do I 'Turn everything off?' Edited 9 September, 2020 by Plastic Link to comment Share on other sites More sharing options...
egg Posted 9 September, 2020 Share Posted 9 September, 2020 42 minutes ago, skintsaint said: Alt+F4 Bastard!! I got back in eventually!! Link to comment Share on other sites More sharing options...
stevegrant Posted 9 September, 2020 Share Posted 9 September, 2020 1 hour ago, Plastic said: Good point. The change of responding IP via DNS flush did make a difference to load time in a standard session for me though, so I do think there is some load balancing oddness happening. The weirdest thing is that the load balancer is effectively just a firewall at the moment because we only need one web server right now, so I would have thought traffic just automatically passes straight through, there's no logic for the load balancer to consider. Auto-scaling is in place if it's needed, as that's just a prudent way of setting things up so I don't need to manually change things when traffic increases significantly, as it does at half-time and full-time during games. 53 minutes ago, skintsaint said: Alt+F4 Link to comment Share on other sites More sharing options...
OldNick Posted 9 September, 2020 Share Posted 9 September, 2020 I fell for that as well. lol Link to comment Share on other sites More sharing options...
Micky Posted 9 September, 2020 Share Posted 9 September, 2020 4 hours ago, Plastic said: Much more helpful, many thanks. Link to comment Share on other sites More sharing options...
S-Clarke Posted 9 September, 2020 Share Posted 9 September, 2020 (edited) This place, for me anyway, is absolutely flawless now. I can get straight on all the time. Tiny slow downs occasionally, but 9/10 I'm able to get in. Posting a reply can sometimes take 10-20 seconds, but that's no drama. The lounge is a weird oddity though as that does time out for me, but I never really went in there anyway! Edited 9 September, 2020 by S-Clarke Link to comment Share on other sites More sharing options...
SaintBobby Posted 10 September, 2020 Share Posted 10 September, 2020 Weirdly brokne for me...i can get on about 20% of the time...80% i get lag and 504s Link to comment Share on other sites More sharing options...
Whitey Grandad Posted 10 September, 2020 Share Posted 10 September, 2020 It was all going so well until yesterday. I can get to the home page quickly but once I click on ‘unread posts’ it’s time to go away and start reading War and Peace. Link to comment Share on other sites More sharing options...
trousers Posted 10 September, 2020 Share Posted 10 September, 2020 Fine for me today and recently 1 Link to comment Share on other sites More sharing options...
Toadhall Saint Posted 10 September, 2020 Share Posted 10 September, 2020 13 minutes ago, trousers said: Fine for me today and recently Same as Link to comment Share on other sites More sharing options...
Saint Keef Posted 10 September, 2020 Share Posted 10 September, 2020 I think this is the 4th or 5th day that I haven't had a problem on here. Thank you to Steve and to anyone else who helped get it sorted. However some of the advice from those who obviously know far more about IT and computers than I, reminded me of just how out of touch I am with these things and baffled me as much as the Chinese graphics/letters/words? on the front of an LD Sports sponsored Saints shirt. I didn't have a clue what they said either. Anyway - the site seems to be working fine and long may it do so. Link to comment Share on other sites More sharing options...
East Kent Saint Posted 10 September, 2020 Share Posted 10 September, 2020 Clearing Safari history allowed fast start up on iPad ! Link to comment Share on other sites More sharing options...
skintsaint Posted 10 September, 2020 Share Posted 10 September, 2020 52 minutes ago, Saint Keef said: Thank you to Steve and to anyone else who helped get it sorted. Yes...looking at other forums it was looking bleak moving on otherwise! Link to comment Share on other sites More sharing options...
Lets B Avenue Posted 10 September, 2020 Share Posted 10 September, 2020 9 hours ago, SaintBobby said: Weirdly brokne for me...i can get on about 20% of the time...80% i get lag and 504s I find that when I get the 504 I refresh the page immediately and it works. Using the "Go to Topic Listing" doesn't often work for me. Link to comment Share on other sites More sharing options...
RobM Posted 10 September, 2020 Share Posted 10 September, 2020 (edited) It has gone backwards for me today. Getting to the main forum index is quick, but it then takes 30seconds to get into a subform. Once that's done, everything is fast other than submitting a post, which takes 10seconds. Edited 10 September, 2020 by RobM Link to comment Share on other sites More sharing options...
SaintsLoyal Posted 11 September, 2020 Share Posted 11 September, 2020 I did find that it was quicker to get on this page, when not being logged in, if that helps the engineers. Link to comment Share on other sites More sharing options...
Wurzel Posted 12 September, 2020 Share Posted 12 September, 2020 Seem to get on every time now. The initial page load seems to hang about 30 secs before any, thing appears but once it's loaded swapping between topics/next page etc as quick as could hope for. Not sure what you've done to it @stevegrant but it's a 👍 from me* *Subject to review after today's match thread gets going 1 Link to comment Share on other sites More sharing options...
S-Clarke Posted 12 September, 2020 Share Posted 12 September, 2020 (edited) Bump to this - absolutely flawless pre and post match for me. Impressive. I had days of not being able to get on here over the last few months, but since last weekend it's been flawless. Nice one Steve on whatever has been changed, as it's a different kettle of fish now. Edited 12 September, 2020 by S-Clarke 1 Link to comment Share on other sites More sharing options...
M271 Posted 14 September, 2020 Share Posted 14 September, 2020 (edited) Slower this morning so far, had my first 504 for 10 days. Speeded up again now, hopefully it was a temporary blip. Edited 14 September, 2020 by M271 Link to comment Share on other sites More sharing options...
badgerx16 Posted 14 September, 2020 Share Posted 14 September, 2020 The Topic Listing page of The Lounge still not loadng. 1 Link to comment Share on other sites More sharing options...
johnnyboy Posted 14 September, 2020 Share Posted 14 September, 2020 Takes me about 30 seconds to get past the forum section but once it loads it’s seems ok ( on safari on iPhone) Link to comment Share on other sites More sharing options...
stevegrant Posted 14 September, 2020 Share Posted 14 September, 2020 I had a load of email notifications this morning from a monitoring system telling me the site was up and down fairly regularly in the space of an hour or so. In all honesty, I've not really done much to have made it more stable over the last week or so, other than starting the re-indexing process which takes at least a week - it's currently 86% of the way through Link to comment Share on other sites More sharing options...
Noodles34 Posted 14 September, 2020 Share Posted 14 September, 2020 I can get on via a pc, basically the old bookmark. However, I cannot get on via my ipad for love nor money. Link to comment Share on other sites More sharing options...
trousers Posted 14 September, 2020 Share Posted 14 September, 2020 Haven't been able to get in at all this morning. Back in now but very slow. Link to comment Share on other sites More sharing options...
trousers Posted 14 September, 2020 Share Posted 14 September, 2020 Haven't been able to get in at all this morning. Back in now but very slow. Link to comment Share on other sites More sharing options...
trousers Posted 14 September, 2020 Share Posted 14 September, 2020 Good to see the double posts back though Link to comment Share on other sites More sharing options...
Toadhall Saint Posted 14 September, 2020 Share Posted 14 September, 2020 2 hours ago, trousers said: Haven't been able to get in at all this morning. Back in now but very slow. As per Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now