Plug-in causing high MySQL queries?

  • Resolved GRAVELBIKEcom

    (@gravelbikecom)


    9 years, 3 months ago

    Running 4.2.4 and 3.2.0 of the plug-in (Twenty Eleven theme).

    My hosting company had to take my site offline due to heavy MySQL queries. In their email, they included some of the queries, specifically:

    UPDATEwp_optionsSEToption_value= 'a:501:{i:0;a:4:{s:4:\"type\";s:4:\"PERF\";s:7:\"message\";s:81:\"ABD_Setup::initialize() // self::enqueue() -- Exec Time = 0.691ms, Mem Usage = 0B\";s:4:\"time\";s:32:\"08/03/15 @ 23:30:57 (+00:00 GMT)\";s:8:\"indented\";b:1;}i:1;a:4:{s:4:\"type\";s:4:\"PERF\";s:7:\"message\";s:84:\"ABD_Setup::initialize() //

    I disabled the plug-in by renaming the directory, but the wp_abd_shortcodes table is still present even after deleting the plug-in.

    Has anyone reported a similar problem? The only changes that I’ve made to my site in the past week was installing the ABD plug-in.

    Thanks!

    https://www.ads-software.com/plugins/ad-blocking-detector/

Viewing 1 replies (of 1 total)

  • Hello GRAVELBIKEcom,

    I’m sorry you’re encountering problems with Ad Blocking Detector.

    One feature of this plugin is an activity, performance, and error log which is viewable on the “Report a Problem / Debug” tab. Due to a few recent bug reports, I have temporarily increased the volume of log entries to help track down the problem. Each log entry has the potential to generate a database query. When, and how often the logging results in queries is up to WordPress.

    You are the first to report any issues with excessive database queries.

    —–

    However, the logging behavior is customizable. In version 3.2.0 of the plugin, “Performing Statistics Logging” can be disabled in the Advanced Settings tab, or they can be filtered by execution time and memory usage cutoffs. Adjusting these settings will drastically reduce the number of log entries.

    In the soon to be released version 3.2.1, all log entries can be enabled or disabled, or the log can be disabled altogether.

    I have changed the default behavior, in version 3.2.1, to filter Performance Statistics Logging, which will reduce log entries. If the plugin was functioning, other than the database query problem, then you can take this farther and disable some or all logging as desired.

    —–

    About a week ago, I released a massive update for this plugin that made several radical changes. The wp_abd_shortcodes table is currently kept so users can return to previous versions of this plugin without losing their old shortcodes, in case the new update caused problems.

    Once the growing pains pass, I will re-include deletion of that table in the uninstall process.

Viewing 1 replies (of 1 total)
  • The topic ‘Plug-in causing high MySQL queries?’ is closed to new replies.