Support » Fixing WordPress » [Plugin: Yet Another Related Posts Plugin] Database disconnects when YARPP is Activated

  • 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                                                                                     |
    +--------+----------------+-----------+----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
Viewing 5 replies - 1 through 5 (of 5 total)
  • 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

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

    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.

    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?

    techstar, wait, are you using InnoDB? I believe YARPP’s fulltext query requires MyISAM…

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] Database disconnects when YARPP is Activated’ is closed to new replies.