Page MenuHomePhabricator

[wikireplicas] Gather usage stats
Open, HighPublic

Description

To better understand the amount of queries received by Wiki Replicas hosts, and which are the main users/tools contributing to that, we should gather some user stats.

This task is about generating a one-off report with the information we already have in logs (including cloudlb logs).

Ideas for follow-up tasks:

  • extending the number of stats we gather
  • producing automated reports and dashboards

Event Timeline

fnegri triaged this task as High priority.Dec 5 2024, 3:46 PM

The current prometheus metrics only give us the total number of queries (including the ones from the replication threads).

Enabling https://mariadb.com/kb/en/user-statistics/ might give us more details on user activity against wiki replicas.