Support » Fixing WordPress » Custom type posts, taxonomy or…? Large DB problem

  • I have a large DB, near 2 million entries, site is working slow and freez sometimes when new entries added.
    Is there any way I can reduce DB load?
    I was thinking of split some content into custom post types or custom taxonomies but not sure what to do.

    Any good advice is appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Are you on a VPS or shared hosting provider?

    You should be able to optimize your MySQL configuration on your server if you are on a VPS or dedicated server. Otherwise, you would have to contact your host to see if they can help optimize this for you.

    Thread Starter xrundel1

    (@xrundel1)

    I’m on VPS and I use some optimization plugins but it doesn’t help a lot. DB is really big and near 500-700 entries added daily.

    I don’t know how to optimize it on server, will look for tutorial.

    You’ll likely need to optimize your /etc/my.cnf file based on your website usage. There are a few free scripts out there that will grab your actual usage (mySQL should be running for at least 24 hours to get reliable data), and then suggest some tweaks to /etc/my.cnf for you.

    Please reference

    https://launchpad.net/mysql-tuning-primer
    http://mysqltuner.com/

    NOTE: Reference the warnings shown on the sites! If you are not comfortable with any of the above, your VPS provider may be able to assist you also if management is included with your package.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Custom type posts, taxonomy or…? Large DB problem’ is closed to new replies.