#!/bin/bash

HOURS=12

CHRBIN=/usr/sbin/chroot
CHRDIR=/chroot/admin

echo "%	count	limit	last	key"
echo

if [ -S $CHRDIR/run/mysqld/mysqld.sock ]; then
	echo "SELECT
			FLOOR(FLOOR(qt.Counter)/FLOOR(ql.CounterLimit)*100) AS percent,
			FLOOR(qt.Counter),
			FLOOR(ql.CounterLimit),
			DATE_FORMAT(FROM_UNIXTIME(qt.LastUpdate), '%H:%i'),
			qt.TrackKey
		FROM quotas_tracking qt LEFT JOIN quotas_limits ql ON qt.QuotasLimitsID=ql.id
		WHERE qt.Counter > 10
		AND from_unixtime(qt.LastUpdate) > DATE_ADD(NOW(), INTERVAL -${HOURS} HOUR)
		ORDER BY percent DESC, qt.LastUpdate DESC;" | \
	$CHRBIN $CHRDIR mysql \
	--defaults-file=/etc/mysql/debian.cnf \
	--socket=/run/mysqld/mysqld.sock \
	-ss -n sys_cluebringer
fi