1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Wordpress database issue

Discussion in 'Programming' started by mattriz, Mar 18, 2017.

  1. #1
    Hi. We have a site that has a problem with the Wordpress child theme and as a result, is putting a lot of pressure on the database, the Select is at 98%. There are too many dependancies on the database, like the code even when the site is not used is pinging the database. The site is stable for around 30 minutes then it crashes as a result of this. We need the database dependancies to be lower than 50% at all times. We need this work done asap, please are there any experts (not time wasters) that can resolve this fast?

    Thanks
    SEMrush
    Matt
     
    mattriz, Mar 18, 2017 IP
    SEMrush
  2. mattriz

    mattriz Well-Known Member

    Messages:
    344
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    125
    #2
    Here's a pic of the Database.
     

    Attached Files:

    mattriz, Mar 18, 2017 IP
  3. sarahk

    sarahk iTamer Staff

    Messages:
    22,619
    Likes Received:
    3,022
    Best Answers:
    75
    Trophy Points:
    615
    #3
    You have a few choices

    • get a new theme
    • debug the existing theme to identify the problem query and make appropriate changes - either DIY, or hire someone
     
    sarahk, Mar 18, 2017 IP
  4. prateeksha

    prateeksha Well-Known Member

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    106
    #4
    Hi Matt, check the Slow Query log and see which select are taking so much time....
    1. Install a wordpress plugin called p2p. you can check the time taken for each plugins or theme and it will also give you statistics...
    2. Generally Themes do not call the database so often, because there is no data stored by them...it is mostly settings they save... i think it is a bad plugin....... the other alternative is disabling plugins one by one to know which plugin is creating an issue
    3. Another alternative is to add a Caching plugin......it will cache your database queuries
    4. Do you have a translator plugin?...check that first
     
    prateeksha, Mar 19, 2017 IP
  5. matt_62

    matt_62 Notable Member

    Messages:
    1,749
    Likes Received:
    456
    Best Answers:
    13
    Trophy Points:
    245
    #5
    I am wondering if someone is exploiting a vulnerability that is inside of the theme, or a plugin that you use. Especially if it is a free to use theme, found online and installed manually, I would not continue to use the theme.

    Change the theme, then I would have wordfence scan your site for security issues.

    On another note, from experience, poorly coded article script plugins for wordpress also tend to overload the sql server.
    If switching the theme does not resolve the problem, then disable plugins, one by one, until you find the culprit.

    I know you want to hire someone to fix it. But IMHO, it might be better to pay for a solid solution that works from the start, then paying someone to muck around trying to patch the titanic.
     
    matt_62, Mar 19, 2017 IP
  6. wpcycle

    wpcycle Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #6
    Have you tried switching to the Twenty Seventeen theme, and waiting the 30 minute interval to see if the issue still happens? That would easily prove it was the theme.
    If that works, do you have a recent copy of the theme from the developer to compare your version to theirs?
    Also, are there any specific functions this website performs? Any special plugins? Have you tried deactivating the plugins and waiting the 30 minute interval?
     
    wpcycle, Mar 20, 2017 IP