Wordpress Problem Can You Help Me

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013

• #1

I need to reduce the number of queries running on my wordpress blog by using application-level caching, combining queries or taking advantage of nested queries wherever i can on my blog. I need you too condense the amount of queries your script uses by optimizing your SQL usage.

This is what my host said to me, can anyone explain and maybe show me how to do it

 

evilclown

Senior Member

Jul 31, 2012

875

611

• Mar 5, 2013

• #2

LOL sorry to laugh, but to put it in lame terms - turn some plugins off. You are having a tremendous amount of queries. Install WP-Cache cache some content.

 

ibmjango

Senior Member

Jul 3, 2010

805

316

• Mar 5, 2013

• #3

you are using auto content posting plugin, which use cron jobs..thats why lots of posting request going on server, may be you have taken your hosting account from reseller thats why thy have limited resources...so there are 2 solutions
1. if you have some funds then get dedicated hosting...
2. check your current hosting package details and upgrade with one which give more resource.
if you wish you can share your plugin names privately, i might look into that for you, and help you accordingly...from external view we can give only above solution..
hope it help you.
Jango

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013
• Thread Starter Thread Starter

• #4

these are the plugins i have running on my blog, which one do you think is not useful

Antispam Extra
GD Star Rating
IntenseDebate
Jetpack by WordPress.com
Latest News Ticker
Mobile Smart
nrelate Most Popular
nrelate Related Content
oEmbed HTML5 Audio
Quick Cache
ShareThis
Spider Video Player
Wordpress Tiniest Super Cache
WP-Polls
WP MashSocial Wigdet
WP Widget Cache

am using quick cache already, and its pretty fast, is there need to change it

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013
• Thread Starter Thread Starter

• #5

i use dlvr.it to post on facebook and twitter, not a plugin

 

BHopkins

Elite Member

Dec 31, 2010

2,609

1,753

• Mar 5, 2013

• #6

Why do you have 3 caching plugins? I would ask your host specifically what they want you to do. You might have outgrown that host and it might be time to move to a better host.

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013
• Thread Starter Thread Starter

• #7

i just moved to ipage shared hosting with 100TB bandwidth, i just chat with them and this is what they said. They said they cant help in this part

"The maximum number of concurrent MySQL connections per user is 10.The maximum number of database queries per user is 75000/hr. If this becomes an issue for you, you may be able to reduce the number of queries you are running by using application-level caching, combining queries or taking advantage of nested queries wherever you can. As a temporary fix for this issue you can delete and recreate your user however this error will still come back if you do not condense the amount of queries your script uses by optimizing your SQL usage.

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013
• Thread Starter Thread Starter

• #8

i use only widget cache and quick cache, should i remove widget cache from my plugins,

What happens is that when they are lots of people on my website at a particular time, the site re-directs to the install.php page on wordpress, because i reached the query limit set for me

 

BHopkins

Elite Member

Dec 31, 2010

2,609

1,753

• Mar 5, 2013

• #9

Sounds like if you get a few people on your site at the same time you'll violate their terms. Like I said, time to move to a better host. I use Hostgator.

 

jazzc

Elite Member

Jan 27, 2009

2,964

14,717

• Mar 5, 2013

• #10

Install WP TotalCache, disable the rest.

In the settings, make it cache the database query on the disk. Make sure you turn the preview mode off and have the cache expire say after 1 day (adjust depending on your content).

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 5, 2013
• Thread Starter Thread Starter

• #11

i googled it and it showed me w3 total cache, so i installed it, and did exactly what you said above. time to wait and see. ipage and hostgator has the same rules, just that hostgator actually offers to help you as there customer

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 7, 2013
• Thread Starter Thread Starter

• #12

it just came up again, the same problem just came up

 

Empire007

Power Member

Jul 22, 2012

519

85

• Mar 8, 2013
• Thread Starter Thread Starter

• #13

looking at these stats what do you think i should do, should i get a dedicated server or ????

"Based on Alexa.com findings, xxxxxx.com has a global traffic rank of 92,*** and belongs to the top 100,000 most popular websites in the world. xxxxxx.com also reaches roughly 114,626 unique users each month and has 428 backlinks according to Alexa."

am confused, my site would redirect to www.xxxxx.com/wp-admin/install.php, dont really know what to do here