Skip to content

Improve performance of sg-report-host-history

Ian Jackson xen-devel 1 version New

Get series with b4
b4 am [email protected]

Versions newest first

  1. v1 Latest11 patches 0 repliesNew

Patches in v1 No applies recorded yet

#Subject and filesSizeRepliesApplied
1/11schema: Add index for quick lookup by hostschema/runvars-host-index.sql+8 -00 replies
2/11sg-report-host-history: Find flight limit by flight start datesg-report-host-history+27 -290 replies
3/11sg-report-host-history: Drop per-job debug etc.sg-report-host-history+7 -70 replies
4/11Executive: Export opendb_testsOsstest/Executive.pm+1 -10 replies
5/11sg-report-host-history: Add a debug print after sorting jobssg-report-host-history+2 -00 replies
6/11sg-report-host-history: Do the main query per hostschema/runvars-host-index.sql sg-report-host-history+10 -190 replies
7/11sg-report-host-history: Rerganisation: Make mainquery per-hostsg-report-host-history+11 -80 replies
8/11sg-report-host-history: Rerganisation: Read old logs latersg-report-host-history+4 -40 replies
9/11sg-report-host-history: Rerganisation: Change loopssg-report-host-history+2 -100 replies
10/11sg-report-host-history: Drop a redundznt AND clausesg-report-host-history+1 -20 replies
11/11sg-report-host-history: Forksg-report-host-history+40 -70 replies

Reviews trailers per patch

No Reviewed-by, Acked-by or Tested-by trailers for v1 yet.

Read the v1 thread

Cover letter [OSSTEST PATCH 00/11] Improve performance of sg-report-host-history

This is reasonably straightforward.

In my tests it reduces the time for an incremental run, with a hot cache, from several hundred seconds to a handful of seconds.

This series really wants to go after the flight report improvements, although the schema updates could be combined.

Ian Jackson (11):
schema: Add index for quick lookup by host
sg-report-host-history: Find flight limit by flight start date
sg-report-host-history: Drop per-job debug etc.
Executive: Export opendb_tests
sg-report-host-history: Add a debug print after sorting jobs
sg-report-host-history: Do the main query per host
sg-report-host-history: Rerganisation: Make mainquery per-host
sg-report-host-history: Rerganisation: Read old logs later
sg-report-host-history: Rerganisation: Change loops
sg-report-host-history: Drop a redundznt AND clause
sg-report-host-history: Fork

 Osstest/Executive.pm          |   2 +-
 schema/runvars-host-index.sql |   8 ++
 sg-report-host-history        | 152 +++++++++++++++++++---------------
 3 files changed, 94 insertions(+), 68 deletions(-)
 create mode 100644 schema/runvars-host-index.sql
Signature · 1 line
2.20.1