Support » Fixing WordPress » 120'000 posts, 218'000 tags

  • Hi guys, I have this blog with that amount of data running on a dedicated server. It was the merge of about one hudred of blogs, this is the reason of those high numbers, tags especially.

    Among the plugins I have WP Super Cache, and I think it’s doing its job fine.

    While monitoring MySQL slow queries and system memory, I find that under certain circumstances the consumed ram grows until it fills all the available memory, at this point what happens is epic, “Error estabilishing an error connection” from the frontend and backend, queries that took 100+ seconds to complete and reboot is needed.

    An example of a slow query is:

    # Query_time: 194  Lock_time: 0  Rows_sent: 1  Rows_examined: 50238
    FROM wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    WHERE 1=1
    AND ( wp_term_relationships.term_taxonomy_id IN (7,24,25,26,27,28,29,30,31,32,33,34,35,36,37) )
    AND wp_posts.post_type = 'post'
    AND (wp_posts.post_status = 'publish')
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, 1;

    Now I’m going to upgrade the system with 4GB more of ram, I hope 8GB will be enough, but what it concerns me is if teorethically WordPress can handle so many posts and tags.

Viewing 2 replies - 1 through 2 (of 2 total)
  • WordPress definitely can handle all those posts and tags. You just need to ask your hosting provider for solutions and I am sure they will be able to assist you.

    With 8GB instead of 4GB no sign of crashes, memory consumption varies from 4GB to 6GB for now.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘120'000 posts, 218'000 tags’ is closed to new replies.