Hello,
we currently check on the amount of thread our mysql servers are running
with a bash script which more or less does:
STRING=`mysqladmin -u $USER -p XXX status`
THREADS=`echo $STRING | sed 's/.*Threads: \([0-9]*\) .*/\1/'`
gmetric -tuint32 -c$MCAST -p$PORT -l$TTL -x180 -d300 -nmysql_threads
-v$THREADS
While this works well enough, the resolution is currently at 1 minute,
too low for reading spikes.
I have two questions:
a) is there a better way of piping mysql statistics into gmetric than
using bash to read variables, called by a 1-minute cronjob?
b) is there any way I can increase the resolution without installing a
cronjob handler which can run more often than 1 time per minute?
Thanks
Jan
--
Geschäftsführer
Hitflip Media Trading GmbH
Tel. 0221-272407-27
Fax. 0221-272407-22
