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.

my sql database and wordpress programmer

Discussion in 'MySQL' started by loannet, Aug 7, 2013.

  1. #1
    Looking for a programmer who can assist with improving the performance of a wordpress based website that is performing extremely slow on the back end.

    We have already tried a new theme, disabled all plug ins, changes hosting providers and none of these helped improve website performance.

    The website is about 6000 pages and has about 6000 unique images, the hosting provider recommended having indexes created to make the tables query faster within the MySQL

    Please send me a pm or post questions here,
    Last edited by a moderator: Aug 21, 2013
    loannet, Aug 7, 2013 IP
  2. aamir777

    aamir777 Member

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #2
    Have you created indexes? if yes then what is performance after creating indexes?

    Regards

    Younas Aamir
    aamir777, Aug 17, 2013 IP
  3. loannet

    loannet Well-Known Member Premium Member

    Messages:
    594
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    105
    #3
    no I have not created indexes, I have not idea how to do this?
    loannet, Aug 19, 2013 IP
  4. aamir777

    aamir777 Member

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #4
    You need to go through all the sql queries in the code, and create indexes on fields which are used after WHERE in queries.
    You should also see the mysql log files and find out the slow queries
    aamir777, Aug 21, 2013 IP
  5. sarahk

    sarahk iTamer Staff

    Messages:
    17,419
    Likes Received:
    1,741
    Best Answers:
    37
    Trophy Points:
    510
    #5
    In general just on the foreign keys - not on all the fields. Usually the database will use one index to run, won't it?
    You can always create complex indexes but I think that may be beyond the skillset of the OP.

    Given that it's wordpress all the indexes should be ok

    Are you on shared hosting? Do any of the other sites on the server have performance issues? Probably not if you have changed hosting.
    Have you used Chrome/Firefox to inspect the page and see if there's any one factor causing the site to run slowly.

    upload_2013-8-22_17-16-14.png
    sarahk, Aug 21, 2013 IP
  6. loannet

    loannet Well-Known Member Premium Member

    Messages:
    594
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    105
    #6
    This is above my technical expertise

    We changed hosting providers to see if this may make a change, no luck

    Here is a list of the troubleshooting we have attempted following various posts and similar threads from wordpress.org help forum

    here are some of the fixes we have tried, the issues is isolated to the add or edit pages portion:

    we have tried disabling all plugins
    changing the theme
    changing the permalink structure
    verified that the php memory allocation is 256m or 512mb
    we ran the smushit photo optimizer to change and altar all of the image files to try and make them small

    added to the wp-config file this, as suggested:
    define('CONCATENATE_SCRIPTS', false );

    uploaded several caching plugins, wpsuper cache, w3cache etc
    uploaded and run several database optimizers

    changed the file permission of the wp-content folder to 755, including recursing into sub directories

    None of these have made a difference
    Last edited by a moderator: Sep 4, 2013
    loannet, Aug 22, 2013 IP
  7. ssrulz1

    ssrulz1 Active Member

    Messages:
    242
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    70
    #7
    Contact Jonathan in Onlinecares. I had a high traffic wordpress site hosted with their VPS. To reduce the resource usage, Jonathan installed Nginx along with some accelerator scripts and configured mysql databases in another server. I noticed a very good difference in the website performance since then.
    ssrulz1, Aug 22, 2013 IP
  8. sarahk

    sarahk iTamer Staff

    Messages:
    17,419
    Likes Received:
    1,741
    Best Answers:
    37
    Trophy Points:
    510
    #8
    You need to look up articles on deleting post revisions. You can do it manually or edit the source code to do it automatically.

    Set the number of revisions to store in the database: either of these are good

    PHP:
    1. define('WP_POST_REVISIONS', false);
    2. define('WP_POST_REVISIONS', no_of_revision);
    Apparently unused themes carry an overhead - get rid of them
    Unused images do too - there's a plugin to identify them.
    sarahk, Sep 4, 2013 IP
    Nigel Lew likes this.
  9. Nigel Lew

    Nigel Lew Notable Member

    Messages:
    3,920
    Likes Received:
    279
    Best Answers:
    16
    Trophy Points:
    245
    #9

    That is totally awesome. That never occurred to me thanks.
    Nigel
    Nigel Lew, Sep 4, 2013 IP
  10. loannet

    loannet Well-Known Member Premium Member

    Messages:
    594
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    105
    #10
    thanks, we are now operating better, found a hosting provider with some skilled database administrators to help us get things running smooth.
    loannet, Sep 5, 2013 IP