#!/bin/sh

MY_BASE=/var/tmp/mysqlmonitor

mkdir -m 700 -p "$MY_BASE"

while :
do
        MY_DATE=$(date +%Y.%m.%d)
        MY_TIME=$(date +%H:%M:%S)
        MY_PATH=$MY_BASE/processlist_$MY_DATE
        MY_FILE=$MY_BASE/processlist_$MY_DATE/${MY_DATE}_${MY_TIME}

        test -d $MY_PATH || mkdir -m 700 $MY_PATH

        mysql -t -e 'show processlist' > $MY_FILE

        sleep 10
done