SPliting databse od big WP site

  • janbrokes

    (@janbrokes)


    4 years ago

    Hello,
    I am using wordpress for my site since 2008. site has grown and rignt now I have more than 400 000 posts with MYSQL over2,5GB and its causing 504 error when editing post.

    I run all basic databse celaning and optimizations, but its not helping.

    Is there any way how to split bigest tablet
    post
    post meta

    I thing it coukld help

    Thank you for any ideas

    This is my server coniguration

    Architektura serveru Linux 4.19.0-10-amd64 x86_64
    Web server Apache/2.4.38 (Debian)
    Verze PHP 7.4.9
    PHP SAPI fpm-fcgi
    PHP max input variables 1000
    PHP time limit 90
    PHP memory limit 1024M

Viewing 1 replies (of 1 total)
  • Dion

    (@diondesigns)

    WordPress does not scale well due to the antiquated design of the “meta” tables (_postmeta and _usermeta in particular). You’ll likely need a dedicated server to deal with 200K posts, regardless of the cache plugins/applications you have installed.

    If the large number of posts are actual articles, and not due to your running a forum plugin like bbPress, give some thought to doing one of the following:

    1) Upgrade your server, or use a separate server for MySQL
    2) Delete at least half your posts

    And keep in mind that the more posts you add, the worse the situation will become. That’s why my suggestion would be option (2).

    If you are running a forum plugin, please give serious thought to migrating your site to actual forum software. A good free/GPL option would be phpBB. Most paid options (Xenforo, IPB, etc) are bloated due to their wanting to do everything, but they’re still significantly better than WP forum plugins for large boards.

Viewing 1 replies (of 1 total)
  • The topic ‘SPliting databse od big WP site’ is closed to new replies.