Excessive Database Usage

  • I just had to deactivate this plugin, as it was querying our database 34,000 times per minute. It increased our server load by a factor of 3. It didn’t always do this, it just started in the past 2-3 days or so. Can you review the database interaction here and release a fix?

    Otherwise can you tell me how to prevent this from happening again? I’d like to keep this tool live for our users, but not if it’s going to put this level of stress on the database. It completely bogged down our site speed.

    https://www.ads-software.com/plugins/top-10/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author WebberZone

    (@webberzone)

    Hi,

    I haven’t noticed this kind of database usage so it’s difficult to fix.

    Could you please reset the plugin options and then do a complete uninstall and reinstall of the plugin from the WordPress admin?

    Thread Starter Friar

    (@friar)

    The plugin just started doing this, after running fine for about 5 weeks. We have a high traffic site, with about 20-30k users per day on it, and over a dozen posts going up most days. Would this affect plugin performance over a 4-5 week period?

    Plugin Author WebberZone

    (@webberzone)

    It could be due to bloat on the daily tables. Can you check your phpMyAdmin to see what the size of the wp_top_ten_daily table is?

    Also, Top 10 has an option of caching in this version. Could you please turn on the cache for a day or so and monitor the load? It caching the output for 60 minutes

    Thread Starter Friar

    (@friar)

    The table wp_top_ten_daily has 15.56MB at this moment. I’m not sure if that’s large or not. What do you think? Our site speed was basically crippled with it enabled, and we couldn’t handle more than 70 or so users at a time. Previously we had 800+ on the site with no trouble, so whatever happened with the plugin occurred rather suddenly after 4-5 weeks of use.

    Plugin Author WebberZone

    (@webberzone)

    I wouldn’t expect 15MB to be a big problem. Are you in a position to run a couple of tests? If so, here is the following worth trying:

    a) Under settings, deactivate the Daily under “Enable Trackers” and check how the load is
    b) Enable the cache under Settings and check load.
    c) Remove any widgets that you might have added with respect to Top 10 and again check the load.
    d) Backup your wp_top_ten_daily table and then empty it in phpMyAdmin and see the load again

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Excessive Database Usage’ is closed to new replies.