launchpad-dev team mailing list archive

[Robert Collins <robert.collins@xxxxxxxxxxxxx>]

I've done a little data mining in the page performance report - we
know that over the *entire* set of requests we're good in terms of 99%
of requests, so why are we getting timeouts?

So here are the page ids for those page id's where more than 1% of
requests take more than 10 seconds.

This is taken from lpnet, so some fixes have not yet been applied from
stable: contrasting this with the same analysis next week will be
interesting.

Some of these things are in-progress, some are hard and long term,
some are easy.

I plan to make sure we have bugs for them all; it would be nice to do
a cheap, automated way of cross referencing - can bug tags have : and
+ in them ?

-Rob

The --- lines separate out each of 10-20,20-30,30-40 group of times.
The === line is the current hard timeout on edge.
The +++ line is the current hard timeout on production.

Page ID mean stddev 99%-complete-in-under
LibraryFileAlias:StreamOrRedirectLibraryFileAliasView 12.45     9.55    41.100
---
Distribution:+assignments 15.98 7.77    39.290
BugTask:+create-question 11.03  8.97    37.940
DistroSeries:+needs-packaging 12.93     7.63    35.820
Person:+editproposedmembers 12.22       6.93    33.010
BugTrackerSet:+index 14.63      5.58    31.370
---
Question:+makebug 4.61  7.73    27.800
Question:+edit 6.66     6.87    27.270
DistributionSourcePackage:+addquestion 4.95     6.88    25.590
Question:+confirm 4.87  6.75    25.120
Distribution:+filebug-show-similar 18.98        1.75    24.230
ProjectGroup:+milestones 4.87   5.94    22.690
Distribution:+filebug 3.13      6.45    22.480
TranslationGroup:+index 6.82    5.10    22.120
Public XML-RPC (we don't seem to see page ids here?) 8.36       4.48    21.800
Distribution:+search 3.96       5.64    20.880
DistroSeries:+templates 18.53   0.73    20.720
Distribution:+archivemirrors 7.76       4.18    20.300
Distribution:+addquestion 4.08  5.35    20.130
---
DistroSeries:+builds 6.47       4.50    19.970
DistroSeries:+cve 19.64 0.00    19.640
ProductSet:+project-cloud 6.22  4.31    19.150
BranchSet:CollectionResource 3.98       4.66    17.960
Person:+patches 17.61   0.00    17.610
++++++++++++++++++++++++++++++++++++++++
DistributionSourcePackage:+filebug-show-similar 4.18    4.22    16.840
MaloneApplication:+bugs 7.09    3.19    16.660
Distribution:+patches 5.78      3.53    16.370
Builder:+history 8.59   2.42    15.850
RootObject:+recently-changed-branches 6.68      3.05    15.830
DistroArchSeries:+builds 3.50   4.04    15.620
Product:+filebug-show-similar 3.49      3.85    15.040
Archive:+copy-packages 2.74     3.86    14.320
BugTask:+editstatus-page 3.15   3.67    14.160
========================================
Distribution:+branches 5.44     2.76    13.720
BugTask:+distrotask 2.09        3.83    13.580
Distribution:+questions 4.89    2.50    12.390
Distribution:+bugtarget-portlet-tags-content 6.35       2.00    12.350
Distribution:+bugs 3.24 2.98    12.180
RootObject:+recently-registered-branches 5.08   2.30    11.980
Distribution:+bugtarget-portlet-bugfilters-stats 6.79   1.64    11.710
DistroArchSeries:+index 2.39    3.10    11.690
Archive:+packages 2.16  2.71    10.290
Distribution:+ppas 4.02 2.07    10.230
Distribution:+cdmirrors 3.55    2.21    10.180
BazaarApplication:+index 2.66   2.45    10.010