You are here: Foswiki>Tasks Web>Item14038 (11 Aug 2016, GeorgeClark)Edit Attach

Item14038: PageCache generates too many dependencies on System.ParentList.

pencil
Priority: Normal
Current State: Closed
Released In: 2.1.1
Target Release: patch
Applies To: Engine
Component: PageCache, Performance
Branches: Release02x01 master Item14033 Item13897
Reported By: GeorgeClark
Waiting For:
Last Change By: GeorgeClark
Some very long running queries were noted in show PROCESSLIST;

20142 foswiki_adm localhost foswiki_db Query 159 updating delete from foswiki_cache_deps where from_topic = 'System.ParentList' and variation = '::foswiki.org 0.000


MariaDB [foswiki_db]> select * from foswiki_cache_deps where from_topic = 'System.ParentList' and variation = '::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions';
+-------------------+-----------------------------------------------------------------------------------------------------------------+----------------------------------------------------+
| from_topic        | variation                                                                                                       | to_topic                                           |
+-------------------+-----------------------------------------------------------------------------------------------------------------+----------------------------------------------------+
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.AccessStatsPlugin                       |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.AcronymDefinitionsPlugin                |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.ActionTrackerPlugin                     |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.AliasPlugin                             |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.AllExtensions                           |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.AntiSpamPlugin                          |
...
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Extensions.ZonePlugin                              |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Main.AdminGroup                                    |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Main.InterWikis                                    |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Main.SitePreferences                               |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Main.WebPreferences                                |
| System.ParentList | ::foswiki.org::443::view::0::language=en::cover=text::section=select::selected=FamilyTreePlugin::web=Extensions | Main.WikiGuest                                     |
+-------------------+-----------------------------------------------------------------------------------------------------------------+----------------------------------------------------+
606 rows in set (24.11 sec)

It appears as though this one topic is accounting for 26% of the dependencies.


MariaDB [foswiki_db]> select count(*) from foswiki_cache_deps where from_topic = 'System.ParentList';
+----------+
| count(*) |
+----------+
|  1720338 |
+----------+
1 row in set (5.05 sec)

MariaDB [foswiki_db]> select count(*) from foswiki_cache_deps;
+----------+
| count(*) |
+----------+
|  6434685 |
+----------+
1 row in set (20.60 sec)

-- GeorgeClark - 03 Apr 2016

For now, I've set ParentList to non cacheable.

-- GeorgeClark - 03 Apr 2016
 
Topic revision: r7 - 11 Aug 2016, GeorgeClark - This page was cached on 18 Nov 2017 - 11:34.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License