To many hits to database, high Cpu and pshyical memory

  • Resolved croscorpion

    (@croscorpion)


    4 years, 7 months ago

    My hosting service send me screenshot from data centar to show me problem with plugin Top 10 – Popular posts plugin for WordPress I use. Plugin cause very high Cpu and pshyical memory.

    I write only few row’s of many connection on screenshot they send to me (over 50):
    369184 scenahr_admin localhost Scenahr_scena Query Sending data 20 SELECT DISTINCT wp_top_ten_daily.postnumer
    SUM(wp_top_ten_daily-cntaccess) as sum_count.wp_posts.

    369190 scenahr_admin localhost Scenahr_scena Query Sending data 19 SELECT DISTINCT wp_top_ten_daily.postnumer
    SUM(wp_top_ten_daily-cntaccess) as sum_count.wp_posts.

    Please, what to do?

    • This topic was modified 4 years, 7 months ago by croscorpion.
    • This topic was modified 4 years, 7 months ago by croscorpion.
Viewing 1 replies (of 1 total)
  • Plugin Author Ajay

    (@ajay)

    Hi,

    Few things to do on this – please backup your site before this:
    1. Enable the cache
    2. Enable maintenance – this deletes entries older than 30 days from the daily table
    3. Go to Tools > Recreate Primary Keys – this is if the first two don’t help
    4. Go to Tools > Recreate Database tables – this is if the first 3 don’t help

    Unfortunately, if these don’t work, you’ll need to check with your hosting site to ensure they have the latest versions of PHP (7 and above) and mySQL as well – if they aren’t already at these levels.

Viewing 1 replies (of 1 total)
  • The topic ‘To many hits to database, high Cpu and pshyical memory’ is closed to new replies.

Tags