Plugin Causing Site Slowness/Connection Issues

  • Resolved Juwaan Carter

    (@geekvibesnation)


    1 year, 4 months ago

    plugin seems to be really slowing the site down lately. Host provider said MySQL has been very busy. Please see results below. This has caused the site to lose connection several times and clearing cache and checking internet connection has not helped. Any solution to lower the load of the plugin on our host server?

    +——–+——————+———–+——————+———+——+———-+——————————————————————————–+

    | Id     | User             | Host      | db               | Command | Time | State    | Info                                                                           |

    +——–+——————+———–+——————+———+——+———-+——————————————————————————–+

    | 934511 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 39   | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934549 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 27   | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934573 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 22   | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934585 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 19   | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934607 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 9    | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934621 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 6    | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

    | 934629 | geekvibe_newsite | localhost | geekvibe_newsite | Query   | 4    | updating | DELETE FROM wp_wf301_404_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY) |

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

    (@paultgoodchild)

    Hi,

    Sorry to hear about the trouble with that… unfortunately we can’t help you with this issue. We run a very tight ship and optimise wherever we can, though some things do use resources, such as scans when they’re running.

    These MySQL logs are for Wordfence, not Shield Security – you’ll want to take this up with them and why it’s affecting your server resources so much.

    Thanks,
    Paul.

    Thread Starter Juwaan Carter

    (@geekvibesnation)

    Our host provider said the same thing but we don’t use Wordfence. We only use Shield Security.

    Plugin Author Paul

    (@paultgoodchild)

    Can I ask why you think Shield is responsible for these queries? Shield doesn’t have anything to do with WF.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Plugin Causing Site Slowness/Connection Issues’ is closed to new replies.