This plugin appears to be slowing down our server (slow queries)

  • Resolved Jason Judge

    (@judgej)


    6 years, 5 months ago

    We have this plugin installed on a number of sites on a server. I have been trying to get to the root cause of a very slow and memory-hungry database engine. I find queries like this scattered throughout our slow query log:

    use my_wp_db;
SET timestamp=1537586827;
SELECT /*!40001 SQL_NO_CACHE */ * FROM <code>my_wp_db_redirection_404</code>;
# Time: 180922  4:27:26
# User@Host: admin[admin] @ localhost []  Id: 7683594
# Query_time: 2.018775  Lock_time: 0.000000 Rows_sent: 209774  Rows_examined: 209774
SET timestamp=1537586846;
SELECT /*!40001 SQL_NO_CACHE */ * FROM <code>my_wp_db_redirection_404</code>;

    Are these “select * from wp_redirection_404” queries generated by this plugin? If so, why? What can we do about it?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author John Godley

    (@johnny5)

    I don’t believe this is part of the normal operation of the plugin.

    About the only thing that could be doing it is if you are exporting 404s. Does that fit with your usage? Are you running some backup software that might be archiving tables?

    Thread Starter Jason Judge

    (@judgej)

    I suppose it could be something backing up ALL the tables, but only the particularly slow tables are making it to the slow query log.

    I’ll chase it up with the other devs. There’s nothing I have installed that would back up databases like this, table by table, but maybe someone has…

    Thanks for the quick response ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘This plugin appears to be slowing down our server (slow queries)’ is closed to new replies.