Performance Metric kcml.kdb.dupidxio

Summary

Duplicate index I/O

Send Condition

Sent during database I/O when the maxdupidx threshold in /etc/kcml/msgq.conf has been exceeded

Overview

Produced when searching for records in tables that have duplicate indices. The threshold at which the metric is produces can be configured by setting the maxdupidx to the desired number of index blocks.

Statistics

Name	Type	Description
table	string	Table name
handle	num	Table handle
chandle	num	Connection handle
keyval	hex	Key value
add	bool	True if a key is being added, false is a key is being deleted
reccnt	count	Number of used records in the table
reclen	num	Record length
idxblocks	count	Number of index blocks read
idxbytes	count	Number of index bytes read

Config

Name	Description
maxdupidx	Max number of index blocks we read while scanning for a dup idx, if we exceed that limit issue a kcml.kdb.dupidxio

General Form

kcml.kdb.dupidxio,table=string,handle=num,chandle=num,keyval=hex,add=bool,reccnt=count,reclen=num,idxblocks=count,idxbytes=count