Mysql Scaling promlem

  • m4xos

    (@m4xos)


    1 year, 8 months ago

    Hello,
    Up to 3 million queries are processed in the wp-post table. It’s full in my postmeta and options tables. I optimized the unnecessary parts, but it’s normal since there are about 50k articles.

    I want to keep year wp-post 2017, year wp-post2 2018, .. 19-20-21-22 in separate tables. Can we do this on WordPress?

    Because, in a no cache system (I get about 5-10 thousand traffic instantly), the panel becomes unusable.

    System server uses FTP and remote mysql server, load balancing and auto scale are active. I’m on 2/2 = 4 core servers.

    Should I separate the tables or is it possible via php myadmin can you help me?

    • This topic was modified 1 year, 8 months ago by t-p. Reason: Moved to Fixing WordPress from Developing with WordPress
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Mysql Scaling promlem’ is closed to new replies.