9 {{ upvoteCount | shortNum }}
9 {{ upvoteCount | shortNum }}

How To Optimize MySQL Database

by KingRoyal
7 replies
Anyone have good tips to optimizing a database for Wordpress so that the website speeds up?
#database #mysql #optimize
  • Profile picture of the author jaimegm
    Ideas are ideas, check how WP is reading certain tables and make sure that you have keys for those readings, check if you are storing some kind of garbage and run a process to clean it, frequently, for some process, something that does not change very often, leave it as html code only. (like terms and conditions, about me, etc.)
    Ask you Host, how to optimize, all of this may help.
    {{ DiscussionBoard.errors[8257216].message }}
    • Profile picture of the author Prrmod
      Building Relationships between tables via the method of Normalization is the best optimzation technique as you have to add keys to the tables (Primary Keys and foreign keys) which helps in quick retrieval of the data from the database.
      {{ DiscussionBoard.errors[8270913].message }}
  • Profile picture of the author octalsoftware
    1. Choose a good host
    2. Start with a solid framework/theme
    3. Use an effective caching plugin
    4. Use a content delivery network (CDN)
    5. Optimize images (automatically)
    6. Optimize your homepage to load quickly
    7. Optimize your WordPress database
    8. Disable hotlinking and leeching of your content
    9. Add an expires header to static resources
    10. Adjust Gravatar images
    11. Add LazyLoad to your images
    12. Control the amount of post revisions stored
    13. Turn off pingbacks and trackbacks
    14. Replace PHP with static HTML, when necessary
    15. Use CloudFlare
    Signature
    Hire PHP Developer | Hire Android Developer | PHP Development Company
    {{ DiscussionBoard.errors[8294402].message }}
  • Profile picture of the author petermarker
    You should set up caching, there is no need to serve dynamic content at all times.
    {{ DiscussionBoard.errors[8295388].message }}
  • Profile picture of the author sktthemes
    Hello
    Optimizing the databases of your WordPress blog sounds like it might be a difficult task, but it’s a lot easier than it sounds. In most situations it can be done in just one or two clicks—no need for complicated steps or terminology.
    Check this artical
    How to Optimize Your WordPress Database for Better Performance : @ProBlogger
    Signature
    SKT WordPress Themes
    {{ DiscussionBoard.errors[8313571].message }}
  • Profile picture of the author Ivar1990
    I agree with Petermarker; use a caching solution.
    For Wordpress there are several plugins that you can use.

    It saves you a lot of time from optimizing the Wordpress performance.
    {{ DiscussionBoard.errors[8314359].message }}
  • Profile picture of the author CyberCoder
    If the site is slow, are you sure it is the Database?

    MySQL has an optimization tool in phpMyAdmin, which can be loaded from most hosting accounts through the CPanel. It will show you which tables have overhead and are having issues, and one click to optimize.

    I never use cache, although in theory it is a good idea, it is really only needed on very high traffic sites, and can cause more issues with speed and size which can impact your site negatively.
    {{ DiscussionBoard.errors[8423132].message }}

Trending Topics