1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Wordpress Problem Can You Help Me

Discussion in 'Web Design' started by Empire007, Mar 5, 2013.

  1. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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
     
  2. evilclown

    evilclown Senior Member

    Joined:
    Jul 31, 2012
    Messages:
    805
    Likes Received:
    575
    Occupation:
    Party Clown
    Location:
    Clownville
    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.
     
  3. ibmjango

    ibmjango Jr. VIP Jr. VIP

    Joined:
    Jul 3, 2010
    Messages:
    252
    Likes Received:
    74
    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
     
  4. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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
     
  5. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    i use dlvr.it to post on facebook and twitter, not a plugin
     
  6. BHopkins

    BHopkins Moderator Staff Member Moderator Jr. VIP

    Joined:
    Dec 31, 2010
    Messages:
    2,311
    Likes Received:
    1,387
    Gender:
    Male
    Occupation:
    ORM and SEO company owner
    Location:
    California
    Home Page:
    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.
     
  7. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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.
     
  8. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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
     
  9. BHopkins

    BHopkins Moderator Staff Member Moderator Jr. VIP

    Joined:
    Dec 31, 2010
    Messages:
    2,311
    Likes Received:
    1,387
    Gender:
    Male
    Occupation:
    ORM and SEO company owner
    Location:
    California
    Home Page:
    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.
     
  10. jazzc

    jazzc Moderator Staff Member Moderator Jr. VIP

    Joined:
    Jan 27, 2009
    Messages:
    2,468
    Likes Received:
    10,148
    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).
     
  11. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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
     
  12. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    it just came up again, the same problem just came up
     
  13. Empire007

    Empire007 Regular Member

    Joined:
    Jul 22, 2012
    Messages:
    426
    Likes Received:
    67
    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