SQL queries causing slowdown and outages

DRE

DRE

Well-known member
I had lots of downtime with xFHost.me so I left and when I did I was given a chance to have my site hosted at a VPS for a limited time. During my stay my site went down again and they gave me a list of what MySQL queries were slowing down my server and deleted my site. So I'm off to looking for another host again. I think 8thos will be down for longer period since I will have to find someone to look at this .txt file to see what's causing issues with my database. I don't know who does anything like that so I will have to take some time this weekend to research.
 
Sort by date Sort by votes
Do you have the add-ons for allowing viewers of a forum/thread to be displayed? If I remember correctly SmashBoards had the same issue and it was caused by both of those add-ons (They had about 3000 queries or more at one point due to those two add-ons).
 
Upvote 0 Downvote
Forsaken said:
Do you have the add-ons for allowing viewers of a forum/thread to be displayed? If I remember correctly SmashBoards had the same issue and it was caused by both of those add-ons (They had about 3000 queries or more at one point due to those two add-ons).
Click to expand...
I uninstalled DBTech's addon Users Viewing A Thread addon several months ago. I did notice that the template for that addon was still there so I deleted it yesterday.
 
Upvote 0 Downvote
DRE said:
Disabling addons don't take a long time unless it is a TMS addon. For instance, it may take between a second or two or maybe even 5 to 10 seconds to disable the average addon. If I disable a large addon, maybe around 15 seconds but if it's a TMS addon it varies from 5 seconds to 3 minutes and even after I disabling a TMS addon the effects are still in place. Weird right?
Click to expand...
I didn't see this thread. There's an easy solution to fix this. But I will wait tomorrow so you wake up in the right foot this time :D...
 
Upvote 0 Downvote
... or not:

go to the XenForo options in the admincp. Search for the TMS options. Uncheck "Compile templates on modification save and switch". It will allow you enable/disable your addons very fast BUT, there is a but, each time you install an addon which requires TMS, you will need to manually rebuild your templates in the TMS page.

That's all.
 
Upvote 0 Downvote
So. The site is up. All add-ons enabled.

We have no idea what caused problems previously but it's not even close to causing our VPS any stress...

Colour me confused.... :confused:
 
Upvote 0 Downvote
It just had a grumble and then came back up.

Traffic is quite low right now. I ran all the Cron jobs manually earlier and there was no noticeable problems...

I guess we might have another hour to wait to see if it happens again... indicating a cron problem.
 
Upvote 0 Downvote
Chris Deeming said:
It just had a grumble and then came back up.

Traffic is quite low right now. I ran all the Cron jobs manually earlier and there was no noticeable problems...

I guess we might have another hour to wait to see if it happens again... indicating a cron problem.
Click to expand...
If it helps, my server didn't have any issues until about four hours after it was uploaded - giving the DNS time to propogate, etc.
 
Upvote 0 Downvote
The DNS was updated about 8PM last night so that should be pretty much done with now...

We're closely monitoring it anyway. There must be SOMETHING... but it's just not reared its ugly head yet.

That grumble on the hour may have been a Cron... makes sense I guess.
 
Upvote 0 Downvote
Chris Deeming said:
It just had a grumble and then came back up.

Traffic is quite low right now. I ran all the Cron jobs manually earlier and there was no noticeable problems...

I guess we might have another hour to wait to see if it happens again... indicating a cron problem.
Click to expand...
It was me
http://www.8thos.com/posts/163630/

That shouldn't have worked, but it did..... Check the logs for that time period and see what the bottle neck is.

1 person doing that alone in their browser shouldn't have had such an impact.
 
Upvote 0 Downvote
Chris Deeming said:
The DNS was updated about 8PM last night so that should be pretty much done with now...

We're closely monitoring it anyway. There must be SOMETHING... but it's just not reared its ugly head yet.

That grumble on the hour may have been a Cron... makes sense I guess.
Click to expand...
No idea then. I just basically lifted the site and dumped it on my server - just mirroring the existing setup. Could it be a difference in the way you've got it online? Did you change any files, etc? I'm no server guy, so it could just be a case of you have a far better idea of what you're doing than I do :D Either way, I'm glad it's up and running!
 
Upvote 0 Downvote
Azhria Lilu said:
No idea then. I just basically lifted the site and dumped it on my server - just mirroring the existing setup. Could it be a difference in the way you've got it online? Did you change any files, etc? I'm no server guy, so it could just be a case of you have a far better idea of what you're doing than I do :D Either way, I'm glad it's up and running!
Click to expand...
We were cautious so we disabled listeners in the config first but aside from that nothing changed.

We then enabled listeners in the config and it's all working fine.

The only other difference possibly is we're using nginx and MariaDB.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

Zig
  • Question Question
MG 2.2 Media Gallery causing excessive database load
Replies
0
Views
403
Zig
Zig
H
  • Question Question
These will sound like silly questions, probably...
Replies
5
Views
531
CedricV
CedricV
AndrewSimm
  • Question Question
XF Cloud Question
Replies
2
Views
441
AndrewSimm
AndrewSimm
I
  • Question Question
XF 2.2 Logging Max Connections and IP Address
Replies
1
Views
425
Paul B
Paul B
Black Tiger
  • Solved
XF 2.2 [solved] 403 but no block present?
Replies
5
Views
405
Black Tiger
Black Tiger
Top Bottom