Forum Speed

[photon]

Oh hey, I turned on the slow query log at some point in the past. 200MB of slow query log, yay.

But this is helpful, can see what queries are taking so long and what's related to them, so maybe then figure out what's the root cause (i.e. a specific thread, a specific page, etc)

[photon]

I was able to reproduce at least one of the issues.

I'm going to mention the issue, but PLEASE refrain from trying it yourself just out of curiosity.

Under the search dropdown, there's an option to find all thanked posts, this query is taking a very long time to run.

I'm trying to figure out a way to either speed up the query or disable the option entirely without disabling the thanks add-in.

[Vox]

Originally Posted by photon

I was able to reproduce at least one of the issues.

I'm going to mention the issue, but PLEASE refrain from trying it yourself just out of curiosity.

Under the search dropdown, there's an option to find all thanked posts, this query is taking a very long time to run.

I'm trying to figure out a way to either speed up the query or disable the option entirely without disabling the thanks add-in.

Vanity, thy name is . . . CP?

[photon]

Just trying to add an index for # of thanks to the post table so it doesn't have to table scan through 4.5 million rows every time. This will probably slow things down while it creates the index.

[photon]

Just trying to add an index for # of thanks to the post table so it doesn't have to table scan through 4.5 million rows every time. This will probably slow things down while it creates the index.

EDIT: Now that I think about it that's a baaaad idea at this point, it'll try and create a copy of the post table.. I'd have to take the forum offline for who knows how many hours to add that index. Hm...

[photon]

Ok removed the thanked post search, that should get rid of one of the worst offenders.

[photon]

Just had a few more long queries, both were for queries related to the original funny post thread and the original gear grinding thread, might have to move those threads to the moderator area for now.

[Locke]

Originally Posted by photon

Ok removed the thanked post search, that should get rid of one of the worst offenders.

Now how will I know if they love me???? Howwwww???????

[photon]

Moved the original funny picture thread and the gear grinding thread to the moderator area, I don't know if it was users viewing them or Google indexing them.

I guess that's a good indication that we should limit the maximum thread size.

[Vox]

Well, the server resources look much better after Photon's changes. So, nice job Photon.

[Resolute 14]

Originally Posted by photon

Moved the original funny picture thread and the gear grinding thread to the moderator area, I don't know if it was users viewing them or Google indexing them.

I guess that's a good indication that we should limit the maximum thread size.

Does this mean we can now blame the mods every time the forum slows down, since you're the only ones that can view those threads?

[dash_pinched]

I don't know how often this occurs, but on another site powered by vBulletin software, we were instructed to close threads once they hit a 10,000 post total as it had an adverse effect on performance. Just throwing it out there.

[Stealth22]

Thanks for all the hard work, photon. I know from experience, nailing down some of this stuff can be challenging sometimes.

I thought the slowdowns were just my connection, haha.

[photon]

Yeah I've seen the 10,000 post thing on other forums too guess we'll have to keep the same kind of thing.

No worries, debugging stuff like this is something I actually enjoy quite a bit, as much as supporting other people's code sucks in some ways it's like a puzzle, my last job had a component that was the same and digging in to get a 1000% improvement on something by tweaking old (often terrible) code was always rewarding.

[Vox]

Originally Posted by photon

Yeah I've seen the 10,000 post thing on other forums too guess we'll have to keep the same kind of thing.

No worries, debugging stuff like this is something I actually enjoy quite a bit, as much as supporting other people's code sucks in some ways it's like a puzzle, my last job had a component that was the same and digging in to get a 1000% improvement on something by tweaking old (often terrible) code was always rewarding.

Wow, then do I ever have a job for you - you would like it so much you would PAY ME to do it!

[MrMastodonFarm]

since we're trimming the fat, can you remove visitor messages? Remove features people don't use.

[puckluck2]

Forum pretty slow again right now. Is it possible the server is just slow?

[Vox]

I see a huge spike on the DB a couple of minutes after 9:00, which corresponds to your post. A few ripples of high use for the next minute or two, then back down to normal. I'm guessing it was a query of some sort along the lines Photon saw last week. Average resources usage is down quite a bit after his recent changes, however.

[Vox]

Semi-related, but apropos of nothing, anyone want to guess where Tortorella went nuts? Servers held up better than Tortorella from what I could see. No reports of slow down!

[getbak]

The old weather plugin used to slow page loads for me to the point that I had to block it. I was having problems with slow loading again tonight and blocked the new weather plugin and haven't had a slow down since.