Kitz Forum

Announcements => Site & Forum Discussion => Topic started by: Weaver on August 09, 2018, 05:09:25 PM

Title: slowness - posting
Post by: Weaver on August 09, 2018, 05:09:25 PM
Having problems posting posts - tx to forum.kitz.co.uk is occasionally really slow/unreliable - this could / should be me, but I cannot see it after various tests, no packet loss, ping/traceroute to kitz is ok, speed tests are ok, cqm graphs are ok, all three lines are up.

- answer : it is just Weaver

Anyone else having problems?
Title: Re: uploads - posting
Post by: Deathstar on August 09, 2018, 05:25:46 PM
Yes, I noticed the same earlier. Took around 30 seconds to post.
Title: Re: uploads - posting
Post by: johnson on August 09, 2018, 06:11:29 PM
Can confirm from here too, new posts take 10-15 seconds to go through.
Title: Re: uploads - posting
Post by: underzone on August 09, 2018, 06:25:07 PM
Me too
Title: Re: uploads - posting
Post by: burakkucat on August 09, 2018, 06:35:47 PM
Confirming that I also experienced a similar delay, earlier this afternoon.

Edited to add: And it is still ongoing, for me.  :(
Title: Re: uploads - posting
Post by: roseway on August 09, 2018, 06:50:00 PM
Let's see...

Yes, it's happening here as well.

(although not that second time).

Title: Re: uploads - posting
Post by: banger on August 09, 2018, 10:29:04 PM
Just had a "Server busy" page twice when trying to post this.
Title: Re: uploads - posting
Post by: Weaver on August 09, 2018, 11:37:19 PM
OK some times, certainly, the majority of the time in fact, but at times it has timed out, and at times it has taken a ramp up to a huge TCP retx (I suspect) because there is a progress indicator which gives the impression that it is part way through sending a post. It could be some other kind of L5-7 protocol delay too though, I suppose, if the ui of Safari is giving me the wrong impression.

I don't suppose there is a dns problem, with domain names with a very very short ttl and then they need to be looked up again but there is a problem with that look up because of something wrong somewhere? Total speculation but just one thing that I would want to rule out because they would explain why there are the delays and also why they only happen from time to time. I would need to check the lifetime that comes back in an actual dns A lookup for say forum.kitz.co.uk or kitz.co.uk or whatever.
Title: Re: uploads - posting
Post by: Weaver on August 09, 2018, 11:42:40 PM
just in case:

Quote
forum.kitz.co.uk@8.8.4.4 (Default):
.         252496   IN   NS   a.root-servers.net.
.         252496   IN   NS   b.root-servers.net.
.         252496   IN   NS   c.root-servers.net.
.         252496   IN   NS   d.root-servers.net.
.         252496   IN   NS   e.root-servers.net.
.         252496   IN   NS   f.root-servers.net.
.         252496   IN   NS   g.root-servers.net.
.         252496   IN   NS   h.root-servers.net.
.         252496   IN   NS   i.root-servers.net.
.         252496   IN   NS   j.root-servers.net.
.         252496   IN   NS   k.root-servers.net.
.         252496   IN   NS   l.root-servers.net.
.         252496   IN   NS   m.root-servers.net.
;; Received 228 bytes from 8.8.4.4#53(8.8.4.4) in 6 ms

uk.         172800   IN   NS   nsa.nic.uk.
uk.         172800   IN   NS   nsb.nic.uk.
uk.         172800   IN   NS   nsc.nic.uk.
uk.         172800   IN   NS   nsd.nic.uk.
uk.         172800   IN   NS   dns1.nic.uk.
uk.         172800   IN   NS   dns2.nic.uk.
uk.         172800   IN   NS   dns3.nic.uk.
uk.         172800   IN   NS   dns4.nic.uk.
;; Received 454 bytes from 199.7.83.42#53(199.7.83.42) in 3 ms

kitz.co.uk.      172800   IN   NS   ns2.vidahost.com.
kitz.co.uk.      172800   IN   NS   ns1.vidahost.com.
;; Received 82 bytes from 156.154.100.3#53(156.154.100.3) in 4908 ms

forum.kitz.co.uk.   14400   IN   A   185.24.98.37
;; Received 50 bytes from 91.146.110.188#53(91.146.110.188) in 88 ms
Title: Re: uploads - posting
Post by: kitz on August 10, 2018, 10:22:23 AM
Sorry guys I was out yesterday evening so didn't get to experience this first hand. 
I can't see anything in the forum logs and I've not got any notifications from either of the site-down monitors.   
If it was just posting, then to me it would suggest the forum database? 

It seems ok though now.  Server stats and server load are fine.
Title: Re: uploads - posting
Post by: d2d4j on August 10, 2018, 10:39:26 AM
Hi Kitz

I hope you don't mind, but if you think it may have been a database slowdown, you may want to check database (usually from phpmyadmin from control panel), select all tables and run check, then repair if check found issues, then optimise.

There is one which most do not run but we always do, but needs running from SSH as the mysql may have been updated and schema maybe slightly out.  So you SSH into server and run this command as root or sudo mysql_upgrade -u root -p (you will need to know the mysql password for mysql root user)

I am sorry if I am wrong, but the above does keep the mysql in good order most of the time

Many thanks

John
Title: Re: uploads - posting
Post by: kitz on August 10, 2018, 12:40:36 PM
I'm not certain what it was, but since it didn't appear to be affecting anything else, then the db was the only thing I could think of.

Quote
you may want to check database (usually from phpmyadmin from control panel), select all tables and run check, then repair if check found issues, then optimise

Thank you.  :)
Just run a check and it says that all tables were OK, but I also just ran optimise.   It said most of the tables were up to date, but it did optimise a few - one of them being smf_messages which is the table containing all forum posts and also smf_attachments which is the attachment files.

Will see how it goes.   :fingers:

Re the other, I'm not aware of mysql being updated and although I do have SSH access if I wanted, its not something I usually touch as I leave that side of things to my hosts as I'm scared of breaking something :D   

Title: Re: slowness - posting
Post by: Weaver on August 11, 2018, 04:28:47 AM
Whatever it was, it went away. Database would make a lot of sense. That would be absolutely consistent with what I experienced although guessing as to Safari's exact behaviour, and I should not have used the word 'upload' as there was no evidence that it was TCP.  ???

forum.kitz.co.uk was pingable with no losses and all normal otherwise.
Title: Re: slowness - posting
Post by: Weaver on August 11, 2018, 09:56:35 AM
I think the problem might be back, although not so bad. Slow making a post just now, a few seconds, which is very unusual. But just one time, not repeatable at all.
Title: Re: slowness - posting
Post by: kitz on August 11, 2018, 10:18:54 AM
test

Seems ok here.
Title: Re: slowness - posting
Post by: d2d4j on August 11, 2018, 10:19:19 AM
Hi

It’s working lovely for me so maybe something your end as a blip

Many thanks

John
Title: Re: slowness - posting
Post by: Weaver on August 11, 2018, 10:52:02 AM
Others saw it before. Very unrepeatable last time.