WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Yet Another Related Posts Plugin] Database disconnects when YARPP is Activated (6 posts)

  1. techstar
    Member
    Posted 4 years ago #

    I just installed YARPP, turned it on, modified some settings then it shut down my website and disconnected the MYSQL database from wordpress.

    This is what the processlist shows at the time of the database disconnect:

    +--------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id     | User           | Host      | db             | Command | Time | State                | Info                                                                                                 |
    +--------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 266665 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72129)                                     |
    | 266674 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (20959,33974,39167,18297,28412)             |
    | 266678 | wpdatabase | localhost | wpdatabase | Query   | 156  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (71042,61563,57090,57239,47285)             |
    | 266691 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72129)                                     |
    | 266695 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (13149,0,0) on duplicate key updat |
    | 266697 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72129)                                     |
    | 266712 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (23587)                                     |
    | 266716 | wpdatabase | localhost | wpdatabase | Query   | 80   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72044)                                     |
    | 266719 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72171)                                     |
    | 266720 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72171)                                     |
    | 266734 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (4716,16504,337,3166,72171)                 |
    | 266736 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (923,65057,64590,1114,161)                  |
    | 266743 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266747 | wpdatabase | localhost | wpdatabase | Query   | 204  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (68248,67150,4716,8459,68089)               |
    | 266750 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (13493,33914,13464,8347,13856)              |
    | 266752 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (15324,11532,71115,70540,66226)             |
    | 266754 | wpdatabase | localhost | wpdatabase | Query   | 175  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (70785,0,0) on duplicate key updat |
    | 266755 | wpdatabase | localhost | wpdatabase | Query   | 186  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266756 | wpdatabase | localhost | wpdatabase | Query   | 164  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (64654,38384,29283,4716,41785)              |
    | 266757 | wpdatabase | localhost | wpdatabase | Query   | 169  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266758 | wpdatabase | localhost | wpdatabase | Query   | 167  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266759 | wpdatabase | localhost | wpdatabase | Query   | 130  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (18040,65463,44454,23624,70965)             |
    | 266762 | wpdatabase | localhost | wpdatabase | Query   | 185  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (43886,34468,59416,28557,36709)             |
    | 266763 | wpdatabase | localhost | wpdatabase | Query   | 151  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (16251,13557,27165,24659,11322)             |
    | 266764 | wpdatabase | localhost | wpdatabase | Query   | 155  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (14627,9937,34334,2675,46351)               |
    | 266766 | wpdatabase | localhost | wpdatabase | Query   | 143  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266767 | wpdatabase | localhost | wpdatabase | Query   | 151  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (1349,29914,65223,4472,10690)               |
    | 266770 | wpdatabase | localhost | wpdatabase | Query   | 135  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266771 | wpdatabase | localhost | wpdatabase | Query   | 133  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266772 | wpdatabase | localhost | wpdatabase | Query   | 130  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266773 | wpdatabase | localhost | wpdatabase | Query   | 122  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266775 | wpdatabase | localhost | wpdatabase | Query   | 114  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (9321,3586,67121,65338,69306)               |
    | 266776 | wpdatabase | localhost | wpdatabase | Query   | 122  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (629,0,0) on duplicate key update  |
    | 266777 | wpdatabase | localhost | wpdatabase | Query   | 89   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72098,0,0) on duplicate key updat |
    | 266780 | wpdatabase | localhost | wpdatabase | Query   | 106  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (20036,43670,39936,48194,46524)             |
    | 266781 | wpdatabase | localhost | wpdatabase | Query   | 99   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266783 | wpdatabase | localhost | wpdatabase | Query   | 107  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266788 | wpdatabase | localhost | wpdatabase | Query   | 72   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (39932,16416,27362,14411,14278)             |
    | 266789 | wpdatabase | localhost | wpdatabase | Query   | 92   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266790 | wpdatabase | localhost | wpdatabase | Query   | 91   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (59343,10867,63358,47470,51603)             |
    | 266796 | wpdatabase | localhost | wpdatabase | Query   | 88   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (71785,0,0) on duplicate key updat |
    | 266798 | wpdatabase | localhost | wpdatabase | Query   | 88   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (58787,61724,60077,63151,58988)             |
    | 266800 | wpdatabase | localhost | wpdatabase | Query   | 87   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (71785,0,0) on duplicate key updat |
    | 266801 | wpdatabase | localhost | wpdatabase | Query   | 80   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266804 | wpdatabase | localhost | wpdatabase | Query   | 61   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (70659,70087,16347,5235,6030)               |
    | 266805 | wpdatabase | localhost | wpdatabase | Query   | 73   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (72171,0,0) on duplicate key updat |
    | 266808 | wpdatabase | localhost | wpdatabase | Query   | 50   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (70785,0,0) on duplicate key updat |
    | 266810 | wpdatabase | localhost | wpdatabase | Query   | 61   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (30359,0,0) on duplicate key updat |
    | 266811 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 71785, ID, (0+ (MATCH (post_conten |
    | 266819 | wpdatabase | localhost | wpdatabase | Query   | 40   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (70785,0,0) on duplicate key updat |
    | 266827 | wpdatabase | localhost | wpdatabase | Query   | 29   | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) values (70785,0,0) on duplicate key updat |
    | 266830 | wpdatabase | localhost | wpdatabase | Query   | 28   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (4270,2294,3040,3300,10862)                 |
    | 266837 | wpdatabase | localhost | wpdatabase | Query   | 212  | Copying to tmp table | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266838 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266839 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266840 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 69025, ID, (0+ (MATCH (post_conten |
    | 266841 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72098, ID, (0+ (MATCH (post_conten |
    | 266843 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 71785, ID, (0+ (MATCH (post_conten |
    | 266845 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 71940, ID, (0+ (MATCH (post_conten |
    | 266847 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 12951, ID, (0+ (MATCH (post_conten |
    | 266848 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 61375, ID, (0+ (MATCH (post_conten |
    | 266849 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266850 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72171, ID, (0+ (MATCH (post_conten |
    | 266851 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 71785, ID, (0+ (MATCH (post_conten |
    | 266854 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266855 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 46257, ID, (0+ (MATCH (post_conten |
    | 266856 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72044, ID, (0+ (MATCH (post_conten |
    | 266857 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266858 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 20644, ID, (0+ (MATCH (post_conten |
    | 266861 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266862 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 23587, ID, (0+ (MATCH (post_conten |
    | 266868 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 70785, ID, (0+ (MATCH (post_conten |
    | 266869 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72171, ID, (0+ (MATCH (post_conten |
    | 266874 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72171, ID, (0+ (MATCH (post_conten |
    | 266876 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 4322, ID, (0+ (MATCH (post_content |
    | 266880 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 34907, ID, (0+ (MATCH (post_conten |
    | 266881 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72227, ID, (0+ (MATCH (post_conten |
    | 266882 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72129, ID, (0+ (MATCH (post_conten |
    | 266904 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 72171, ID, (0+ (MATCH (post_conten |
    | 266905 | wpdatabase | localhost | wpdatabase | Query   | 212  | Locked               | insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 16589, ID, (0+ (MATCH (post_conten |
    | 267001 | wpdatabase | localhost | wpdatabase | Query   | 157  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72168)                                     |
    | 267002 | wpdatabase | localhost | wpdatabase | Query   | 157  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72171)                                     |
    | 267005 | wpdatabase | localhost | wpdatabase | Query   | 156  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (4322)                                      |
    | 267007 | wpdatabase | localhost | wpdatabase | Query   | 156  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72171)                                     |
    | 267010 | wpdatabase | localhost | wpdatabase | Query   | 155  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (12951)                                     |
    | 267013 | wpdatabase | localhost | wpdatabase | Query   | 152  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (71198)                                     |
    | 267019 | wpdatabase | localhost | wpdatabase | Query   | 148  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72098)                                     |
    | 267021 | wpdatabase | localhost | wpdatabase | Query   | 148  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72098)                                     |
    | 267023 | wpdatabase | localhost | wpdatabase | Query   | 146  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (58457)                                     |
    | 267024 | wpdatabase | localhost | wpdatabase | Query   | 146  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72171)                                     |
    | 267051 | wpdatabase | localhost | wpdatabase | Query   | 131  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (72098)                                     |
    | 267064 | wpdatabase | localhost | wpdatabase | Query   | 125  | Locked               | delete from wp_yarpp_related_cache where reference_ID in (16589)                                     |
    | 267114 | wpdatabase | localhost | wpdatabase | Query   | 97   | Locked               | delete from wp_yarpp_related_cache where reference_ID in (71485)                                     |
    | 267304 | root           | localhost |                | Query   | 0    |                      | show processlist                                                                                     |
    +--------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
  2. erikajurney
    Member
    Posted 4 years ago #

    Are we living parallel lives? This happened to me last night. I'm running wp 2.9.1 and the most recent version of yarpp.

    Erika

  3. techstar
    Member
    Posted 4 years ago #

    Uhoh.. where is the dev team at these hours of the day? :>

  4. Whoah, this is unfortunate... YARPP can be moderately database intensive, but hopefully some of those slow queries will clear soon. What version of YARPP are you using?

    Turning off the "consider" tags and/or categories as well as not excluding any tags or categories, and not cross-relating posts and pages will all help.

  5. techstar
    Member
    Posted 4 years ago #

    Latest version.

    Turning anything off should not be a solution, but thanks for the tip. This software shouldn't need to access the database so frequently, seems like a bad use of db table access to me, or we are just screwed in the beginning without innodb support on full text tables?

  6. techstar, wait, are you using InnoDB? I believe YARPP's fulltext query requires MyISAM...

Topic Closed

This topic has been closed to new replies.

About this Topic