Page load time is too slow

  • Resolved mohammedkadhim

    (@mohammedkadhim)


    5 months, 3 weeks ago

    Hello,

    I added keys with no issue however for some reason page load time is still extremely slow :\ the problem is not new it been like that for months.

    Database in our site is big (not huge though). especially the following tables:

    wp_postmeta (786,104 rows), wp_posts (138,173 rows)

    I’ve done the monitoring process (Upload ID= 73XKTBaY) and I could see right away that some tables are taking more time than it suppose to. However, don’t really know if there is anything I could do about it. Are you able to check the table ID and see if something ring a bell?

    We’re on dedicated server. Server load is mostly too low so we’re not exhausting our resources. We do have active cache plugin (LiteSpeed) with MemCached object cache enabled, CloudFlare CDN is enabled as well. Running latest versions of: PHP 8.1, WordPress, Theme. And finally I’ve already repaired/optimized our Database.

    Any help is appreciated.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the upload. Your database server (MariaDB 10.6) only has 128MiB of innodb_buffer_pool_size. But the size of your tables and keys is upward of 600MiB, much of it coming from wp_postmeta.

    May I suggest you change your MariaDB .cnf to set the innodb_buffer_pool_size to 1GiB? If that’s too much for your server physical RAM, try to set it at least to 0.75GiB. Please let me know if this helps resolve the problem.

    Background information here: https://mariadb.com/kb/en/innodb-buffer-pool/

    Thread Starter mohammedkadhim

    (@mohammedkadhim)

    @olliejones

    I followed your advice and … I HONESTLY CANNOT EXPRESS MY GRATITUTE!

    The difference is day and night! Absolutely mind blowing I’m not exaggerating. Page load time went from 20 seconds (sometimes 40 seconds I’m not kidding) to 2 – 3 seconds!!

    Our server has 32 G of RAM so I checked how much we’ve been using in the past and it never exceeded 7GB. So I set innodb_buffer_pool_size to 1128 M.

    I’ve been researching for a way to fix the slow page load for more than a year! Tried so many things, almost gave up and honestly my team have lost faith in me. You, gave me a priceless advice. Our webhost company couldn’t do anything as well. Thank you so much! You’re genius and fantastic IT specialist.

    Accept my kind regards,

    Mohammed Kadhim

    Plugin Author OllieJones

    (@olliejones)

    Sweet! I love to hear when simple reconfigurations make things go faster!

    And, the general rule for innodb_buffer_pool_size on a dedicated server machine is 70% of the available RAM. I guess you share the server for database and web server. So, with that much RAM you may as well give the innodb_buffer_pool_size at least 2GiB, maybe even 4GiB.

    You might also investigate downsizing your VM. You’d save a bunch of money.

    • This reply was modified 5 months, 3 weeks ago by OllieJones. Reason: suggestions about sizing
Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.