Hi Julien,
Thanks for your prompt response.
PFB my grok exporter config
global:
config_version: 3
input:
type: file
paths:
- /root/grok_exporter-1.0.0.RC3.linux-amd64/example/ptchecksum.out
- /root/grok_exporter-1.0.0.RC3.linux-amd64/example/ptchecksum.err
imports:
- type: grok_patterns
dir: ./patterns
grok_patterns:
- 'CHECKSUMOUT [a-zA-Z ]*'
metrics:
- type: counter
name: mysql_ptchecksum_checksum_stats
help: mysql ptchecksum stats.
match: '%{MONTHDAY:month}\-%{MONTHDAY:date}\T%{TIME:logtime}\s.*%{INT:ERRORS}\s.*%{INT:DIFFS}\s.*%{NUMBER:ROWS}\s.*%{INT:DIFF_ROWS}\s.*%{INT:CHUNKS}\s.*%{INT:SKIPPED}\s.*%{NUMBER:time} %{GREEDYDATA:TABLE}'
labels:
diffs: '{{.DIFFS}}'
table: '{{.TABLE}}'
date: '{{.date}}'
errors: '{{.ERRORS}}'
rows: '{{.ROWS}}'
diff_rows: '{{.DIFF_ROWS}}'
chunks: '{{.CHUNKS}}'
TS: '{{.logtime}}'
time: '{{.time}}'
- type: gauge
name: mysql_ptchecksum_checksuming_status
help: mysql ptchecksum cheksuming status.
match: '%{GREEDYDATA:checksum_status}\s%{GREEDYDATA:tabel}\:.*%{NUMBER:completion_percentage}\%\s.*%{NUMBER:TimeRemainingHours}\:%{NUMBER:TimeRemainingMinutes}'
value: '{{.completion_percentage}}'
labels:
status: '{{.checksum_status}}'
tabel: '{{.tabel}}'
- type: gauge
name: mysql_ptchecksum_waiting_status
help: mysql ptchecksum waiting status.
match: 'Replica lag\s.*\is\s.*%{INT:seconds}\s%{GREEDYDATA:data}\son\s%{GREEDYDATA:server}\.\s'
value: '{{.seconds}}'
labels:
server: '{{.server}}'
server:
protocol: http
port: 9144