SQL queries causing slowdown and outages

[DRE]

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.

 

[Sheldon]

I think the only way to resolve these issues is by installing stewart's meme's #crazyadvice

Those highly sophisticated images may be what is causing it.

 

[DRE]

I have approximately 110 addons installed.

3 Styles.

No other languages.

 

[Andy.N]

I have approximately 110 addons installed.

3 Styles.

No other languages.

Only 110 addons?

 

[Chris D]

We'll isolate the cause DRE, don't worry.

We'll report the findings here when we do.

 

[Andy.N]

I used to hunt for addons that cause high queries by turning on debug and look at the debug pages. Help out a lot.

 

[DRE]

Only 110 addons?

Yeah. Like Mike said, he told me I had too many addons installed that may have been causing issues so I uninstalled 8 addons.

 

[Shelley]

We'll isolate the cause DRE, don't worry.

We'll report the findings here when we do.

Have you tried attaching a nuclear powered reactor to stabilize the site chris, perhaps it's lack of power getting through to the server to run those 110 add-ons?

 

[Syndol]

Yeah. Like Mike said, he told me I had too many addons installed that may have been causing issues so I uninstalled 8 addons.

The wrong 8
Did you run the search?

 

[Andy.N]

Yeah. Like Mike said, he told me I had too many addons installed that may have been causing issues so I uninstalled 8 addons.

110 is a bit extreme for any site. I don't think digitalpoint has that many
You only needs one badly coded addon to cause the mess. Hunting them down among the 110 is just much more work.

 

[jmurrayhead]

I don't really think it's a matter of how many addons you have installed, rather, a matter of how efficient the queries are. Typically, when I develop something, I will cache frequent queries so that subsequent calls will pull from the cache rather than the database. What I saw from the txt file looked dreadful. Unless I'm not seeing the full picture, that is an AWFUL lot of LEFT JOINS, which can be quite inefficient in themselves.

 

[Shelley]

110 is a bit extreme for any site. I don't think digitalpoint has that many
You only needs one badly coded addon to cause the mess. Hunting them down among the 110 is just much more work.

Yeah, I would have suggested disabling the add-ons one by one but hell, you would still be there for the remainder of the year doing this tedious task.

edit: I'm quite interested though now what is causing it. look forward in seeing what is the cause if you find the issue. @Chris

 

[DRE]

The wrong 8
Did you run the search?

I'm in the process of sending my site to Chris since I don't know how to find out what's causing the issue.

 

[Biker]

I have approximately 110 addons installed.

I don't feel so bad about my 7 then.

 

[DRE]

110 is a bit extreme for any site. I don't think digitalpoint has that many
You only needs one badly coded addon to cause the mess. Hunting them down among the 110 is just much more work.

I've had way more addons, styles and languages installed when I was on URLJet and MDDHosting shared hosting and never had any of these issues. This all started sometime after moving to xFHost.me So I'm thinking it may have been an addon I installed after switching over to xFHost.me.

 

[Lisa]

I'm still amazed at you having 110 addons installed! LOL

 

[Mike Edge]

Yeah, I would have suggested disabling the add-ons one by one but hell, you would still be there for the remainder of the year doing this tedious task.

edit: I'm quite interested though now what is causing it. look forward in seeing what is the cause if you find the issue. @Chris

I'm disappointed no 110!?! sign yet

 

[Sheldon]

I've had way more addons, styles and languages installed when I was on URLJet and MDDHosting shared hosting and never had any of these issues. This all started sometime after moving to xFHost.me So I'm thinking it may have been an addon I installed after switching over to xFHost.me.

Any ideas what add-ons they were?

Its what, a 2 week timeframe, with 3 days possible to upload?

 

[Syndol]

I'm disappointed no 110!?! sign yet

For a sec there I thought you were talking about a medal:
"110 add-ons and my site is still up "

 

[Shelley]

I'm still amazed at you having 110 addons installed! LOL

You know, I had to double check I read that figure correctly. I thought, nah that can't be right and looked several more times.

I can just envision the server thinking "oh no dre is coming back to install another add-on i can't cope with this"

 

[Biker]

For a sec there I thought you were talking about a medal:
"110 add-ons and my site is still up "

But the site WASN'T up!