Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Register
  • Sign in
  • slapos slapos
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Merge requests 129
    • Merge requests 129
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Jobs
  • Commits
Collapse sidebar
  • nexedinexedi
  • slaposslapos
  • Merge requests
  • !801

Fix erp5 slow queries logs

  • Review changes

  • Download
  • Patches
  • Plain diff
Merged Jérome Perrin requested to merge fix/erp5-slow-queries-logs into master Aug 21, 2020
  • Overview 13
  • Commits 6
  • Pipelines 8
  • Changes 16

ERP5 software release has some support for mariadb slow queries:

  • run pt-query-digest daily
  • check that the number of slow queries and the slowest slow query do not exceed some thresholds defined as instance parameters

but this had issues:

  • the daily pt-query-digest reports where kept as not-compressed text files, which over time takes quite a lot of disk space
  • the threshold detection was not working, since strings and floats were compared - see https://lab.nexedi.com/nexedi/slapos.toolbox/merge_requests/83

This uses new techniques in software release testing from https://lab.nexedi.com/nexedi/slapos.core/merge_requests/245, we use faketime to simulate running crontabs and promises at a specific time in the future, so that we can assert the exact expected behaviour of crontab scripts.

Edited Aug 25, 2020 by Jérome Perrin
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: fix/erp5-slow-queries-logs
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7