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

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

Commenting is disabled while not logged in