influxdata / influxdata/telegraf

Get query history in mysql

Open
#9,532 1 comment 0 reactions 0 assignees View on GitHub
area/mysql feature request help wanted size/l
Dominant language
Go
Stars
17.8k
Forks
5.8k
Avg merge
1d 20h
Merged PRs (30d)
161

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](https://user-images.githubusercontent.com/14358073/126609249-9e03b181-e938-42f9-a542-9cb536350dde.png)

This is some data that I could collect:

![image](https://user-images.githubusercontent.com/14358073/126609376-3fd54597-e4df-40e2-93a8-5b01d70024dd.png)

### Use case:
Control which query is used the most in MySQL, to control the malware query in database.

Contributor guide

Open the contributing guide

Research direction

Start by reviewing Telegraf's existing MySQL input support and the Percona Monitoring and Management query-history behavior referenced in the issue. Define which query-history data should be collected and written to InfluxDB, and establish tests or acceptance criteria that demonstrate completion.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, mysql
Domain
data, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.