Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add capture of query load metric #121

Open
huitema opened this issue Dec 20, 2018 · 1 comment
Open

Add capture of query load metric #121

huitema opened this issue Dec 20, 2018 · 1 comment

Comments

@huitema
Copy link
Collaborator

huitema commented Dec 20, 2018

We want to experiment with measurement of query load.

  1. Query rate: average number of queries per time slice of 10 seconds
  2. Standard deviation: std of the number of queries per 10 seconds, across the whole set
  3. Max: max number of queries per 10 seconds, across the whole set.

The first step is to upgrade the capture program with a few new data points:

  1. Number of 10 second slices in segment
  2. Sum of queries received over all slices
  3. Sum of squares of number of queries received over all slices
  4. maximum number of queries per slice

We will also update the summary program, so the max is computed across all maxes, instead of just doing a summation.

Then we will update M3 to display the average, std and max -- i.e., the most simple part. We can then play with the data set and try find variations per locale, day, etc.

@huitema
Copy link
Collaborator Author

huitema commented Feb 16, 2019

After discussion, we just did something much simpler. Count the total number of requests (and bytes) in a capture session, and the duration of the capture. This gives us unquestioned raw data. Then, we will try build a model.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant