Forum Performance Issues

[Jillsy]

Hey Swaggers,

We have done some maintenance to the forum and the database. Yes there has been some of the larger off topic threads removed but we will have to live with that.

Not sure if we have had a win yet but will know in the next day or so.

Thank you for your patience during this time.

[speewa158]

Jiiisy The larger off topic stuff that wasdropped must have been about 250 of my posts  back to 5800 again . Such is life  As long as we get our speed of post back its all good . Keep up the good work 

[cruisindub]

My wife thought I was getting romantic when I went to bed early.

Was in a mood as a notice came up saying myswag would be offline for the rest of the night.
First early night I have had since ages........




On a serious note, not sure if its happening to anyone else or or if your aware of it, all posts now are reading 'new' unread posts and revert back to the original post.

Otherwise all is good.

[baldheadedgit]

All i worry about is being able to read the post's,, and at the moment (4.53AM) its all working good,,,



BHG

[Signature035]

Thanks....   I have had issues for the passt 3 days or so accessiong some thrteads.... looks good now

[Hairs]

The Buffalo effect 
Cheers Guys.

[griz066]

Speed is awesome but i have 7 pages of posts with new replies.........I could just be very popular i guess

[Brett]

On a serious note, not sure if its happening to anyone else or or if your aware of it, all posts now are reading 'new' unread posts and revert back to the original post.

Otherwise all is good.

This maybe from us emptying the topic log in the database. Over 1.5 million entries and 1/3 of the database total size.

On the index page you should be able to Mark All Topics Read. From then on any NEW icons will take you to the latest post.

Let me know if there is any other issues. I still have some more tweaking to do this afternoon.


Sent from my iPhone using Tapatalk

[Matto]

Thanks very much for sorting this guys (and gals). I realise it's not your full time job, and that any time spent fixing things here eats into your personal time. It's much appreciated by me, and by all the other members as well I'm sure.

Cheers!
Matto

[Tjupurula]

What a relief, I thought I was having serious problems with my satellite dish again.  I am still slow, but that is normal on Activ8 Rural, whish is whom I go through for my internet.
It is now 1800 hours in WA, and it is taking me up to 5 minutes to get the forum open, if I do not get some kind of SMF Connection Failed message on the screen....What is happening ?
Regards
Tjupurula

[MDS69]

Jiiisy The larger off topic stuff that wasdropped must have been about 250 of my posts  back to 5800 again . Such is life  As long as we get our speed of post back its all good . Keep up the good work 

Good on ya speewa, take one for the team

[cruisindub]

Thanks!
Hope I don't sound thick by asking where the index page is?

Like Matto, appreciate the time required.

[Bird]

I say removing the post count thing from under peoples names may help to....

[WilSurf]

Get rid of the electrical forum, that will speed up everything.



(hiding now)

[Bookleaf]

At 1710 Adelaide time, found accessing the system slow to log in.
The slow to load all unread.
Looked at one thread from the last post first.  When I went to go back to page 1, got a time-out error.  Got again on an other thread. 
Ok now to red and post this.

Will mark all posts read and see if still exists later tonight.

[rodw]

Still seeing SMF errors during the day here. Getting very tiring.

[nick_4x4]

Ive worked on smf for a few years now and notice the same issues you guys are having everywhere, mostly its the database size causing issues, try talking to your host about allowing a larger limit on the database connections to speed up loading times.

If you are getting 40-50 k views a day then that will kill any bandwidth you may have, google is horrible at bandwidth burning, there is a lot of options in the back end of the system for SMF for where google and other search engines can poke around in, setting limits on what forums they are allowed to see will slow down the amount of hits.

Worth a try is something  you may have already done, Optimise tables in the database, clear site cache and run any security updates.

Nick

[sooty]

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

[speewa158]

S   t   i   l   l       r    e    a    l    l    y         s     l     o       w






                                                                            

[toeball]

I say removing the post count thing from under peoples names may help to....

I don't understand the fascination with the post count .........

Am I a soft floor camper yet???

Should post whores be forced dress (in)appropriately in get togethers?

[timneva]

Ive worked on smf for a few years now and notice the same issues you guys are having everywhere, mostly its the database size causing issues, try talking to your host about allowing a larger limit on the database connections to speed up loading times.

If you are getting 40-50 k views a day then that will kill any bandwidth you may have, google is horrible at bandwidth burning, there is a lot of options in the back end of the system for SMF for where google and other search engines can poke around in, setting limits on what forums they are allowed to see will slow down the amount of hits.

Worth a try is something  you may have already done, Optimise tables in the database, clear site cache and run any security updates.

Nick

I'm still getting the error quite a bit and good suggestions I think Nick.
Given it seems to be intermittent, I'd guess its on the database server side too, possibly maxconnections but might also be worthwhile checking what the load averages of yours server are too as simply changing the maximum connections may cause it to consume further unnecessary resources on the server which can in turn lead to more instability. Agree with Nick that implementing any caching or db load reducing measures you can to have it run as efficiently as possible would help. Easier said than done :-)

Good luck guys and thanks for such a great site.

Cheers,
Tim

[ozbogwam]

All sorts of issues trying to login with Tapatalk, good luck trying to sort it all out

[bobnrob]

How's about everyone stay away till next Monday giving 'em time to get it fixed...

Slinking away now before a size 10 boot finds my head 

[fuji]

Worse then ever

[Tjupurula]

How's about everyone stay away till next Monday giving 'em time to get it fixed...

Slinking away now before a size 10 boot finds my head 

I am a size 15 boot Bob, and I confess a MySwag addict...