mysqlsfp.sh

#!/bin/bash

MYSQL=`which mysql`
MYSQLUSER=root
MYSQLPASSWD=`grep ^mysql= /usr/local/directadmin/scripts/setup.txt|cut -d'=' -f2`
MYSQLHOST=localhost

DST=/var/spool/mysqlsfp

DST=$DST/`date +%Y-%m-%d`
mkdir -p $DST

cd `dirname $0`

FN=`date +%Y.%m.%d-%k:%M:%S`
OP="select concat('========================================== ',now(),' =============================================') as date;show full processlist;"
SLOP="select sleep(10);"

LC_MESSAGES=ru_RU.UTF-8
LC_COLLATE=ru_RU.UTF-8
LANG=ru_RU.UTF-8
export LC_MESSAGES LC_COLLATE LANG
$MYSQL -u${MYSQLUSER} -p${MYSQLPASSWD} -h${MYSQLHOST} -NBe "${OP}${SLOP}${OP}${SLOP}${OP}${SLOP}${OP}${SLOP}${OP}${SLOP}${OP}" 2>&1| gzip -c > $DST/${FN}.gz

find $DST -mtime +30 -delete