influxdata/telegraf

Get query history in mysql

Open

#9,532 opened on Jul 22, 2021

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Go (9,892 stars) (4,161 forks)batch import
area/mysqlfeature requesthelp wantedsize/l

Description

Feature Request

It's really good if telegraf can push the query history to influx to show something like below images:

This feature is from the Percona Monitoring Management:

image

This is some data that I could collect:

image

Use case:

Control which query is used the most in MySQL, to control the malware query in database.

Contributor guide

Tech stack
gomysql
Domain
databaseobservability
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
3-5 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Go programmingTelegraf plugin developmentMySQL query history
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
35
Research direction
Examine the existing MySQL input plugin at plugins/inputs/mysql/ to understand the plugin structure. Research MySQL's performance schema tables that store query history (e.g., events statements summary by digest). Consider creating a new input plugin or extending the existing one to collect and send query metrics to InfluxDB. The issue lacks specific technical details, so a maintainer may need to clarify the desired data points.