Support » Fixing WordPress » Slow site problem: Database problem?

  • marcorroma

    (@marcorroma)


    Hi, I’m trying to figure out why my site is so slow.
    The problem is what in this screenshot is called “Wait” (test with Pingdom tool)
    Test image

    I’ve already tried disabling all plugins, changing the theme, restarting the server. With the sitemap the problem increases considerably (8000ms, sometimes timeout page). The problem disappears on the /wp-login.php page.

    I tried to empty the “wp_postmeta” and “wp_post” table and the problem disappears (300/400ms “wait”). But I can’t figure out how to fix it without losing my post database.
    Database Image

    Can someone help me?
    I’m going crazy!
    Thanks a lot

    My Virtual Server:
    I have webmin, apache2, php7.2-fpm, phpmyadmin
    Intel (R) Xeon (R) CPU E5-2630 v4 @ 2.20GHz, 8 cores
    Real memory: 29.44 GB total (800MB in use)
    Virtual memory: 2GB (0GB in use)
    Local disk space: 200GB (70GB in use)

    • This topic was modified 9 months ago by marcorroma.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    If you have questions about your database, try the MySql tuner: https://www.linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/

    >> I tried to empty the “wp_postmeta” and “wp_post” table and the problem disappears <<

    Yes, a site with no content would be faster, but pointless.

    Install a good caching plugin. I like the combination of autoptimize and comet cache.

    marcorroma

    (@marcorroma)

    Hi, thanks for your time.
    I already use a cache plugin.
    I also tried to install a plugin to optimize the database, and the response time of the server improves but is not optimal.
    There seems to be a problem reading the database …

    Is it possible to have a detailed log to understand which table slows down the loading of my site?

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Use the mysql tuner program. Your database server probably needs tuning.

    marcorroma

    (@marcorroma)

    See something strange?
    This is what mysql tuner gives me

    Image 1
    Image 2
    Image 3
    Image 4

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Helping you do sysadmin tasks is beyond the scope of the forums. There are a number of MySQL related groups and mailing lists where you can find help.

    marcorroma

    (@marcorroma)

    Thanks a lot

    • This reply was modified 9 months ago by marcorroma.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Slow site problem: Database problem?’ is closed to new replies.