Mysql Extend DB Metric

Hi All,

Can someone please assist me.

I’m trying to create a alert for Read Requests but I cant figure out how its written in the DB.
image

If any one can give me the correct Metrics I’ll appreciate it so much.

Below is how its logged

Thanks in Advance!

ACs
AdCs
BRd
BSt
CDe
CISt
CIt
CLd
CRe
CRSt
Cs
CSt
CTMPDTs
CTMPFs
CTMPTs
CUe
CUMi
IBCd
IBFBl
IBIAd
IBIAe
IBIFLg
IBIFSc
IBIIAo
IBIIs
IBILg
IBILog
IBIMRd
IBIMs
IBIRd
IBISc
IBIWr
IBLFh
IBLWn
IBOWs
IBPDBp
IBPFe
IBPMps
IBPse
IBRd
IBSRs
IBSWs
IBTNx
IBWr
IDBLBSe
IDBRDd
IDBRId
IDBRRd
IDBRUd
KRRs
KRs
KWR
KWs
MaCs
MUCs
OdTs
OFs
OTs
QCeFy
QCHs
QCIs
QCLMPs
QCNCd
QCQICe
QCs
SFJn
SFRJn
SMPs
SQs
SRange
SRCk
SRe
SRows
SScan
SSn
State_closing_tables
State_copying_to_tmp_table
State_end
State_freeing_items
State_init
State_locked
State_login
State_none
State_other
State_preparing
State_reading_from_net
State_sending_data
State_sorting_result
State_statistics
State_updating
State_writing_to_net
TCd
TLIe
TLWd
TOC

It looks like KRRs is MyISAM read requests.

For others, check out the mysql_* files in:

…or just grep through that directory on your LibreNMS server.

2 Likes

Thank you very much!!