From 15572ce3a023ea3c6093dc595107564a7f35d7cb Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Fri, 26 Apr 2013 21:14:05 +0200 Subject: munin-plugin: return 0 instead of NULL munin can't graph NULL Signed-off-by: Florian Pritz --- extras/munin/filebin_stats | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'extras') diff --git a/extras/munin/filebin_stats b/extras/munin/filebin_stats index f638ecc4b..f7e3bbeac 100644 --- a/extras/munin/filebin_stats +++ b/extras/munin/filebin_stats @@ -19,7 +19,7 @@ EOM esac echo -n "used.value " -mysql $mysqlopts -sr $database <<<"select sum(filesize) as 'Used storage' from (select filesize from files group by hash) a;" || echo "a" +mysql $mysqlopts -sr $database <<<"select coalesce(sum(filesize), 0) as 'Used storage' from (select filesize from files group by hash) a;" || echo "a" echo -n "dedup.value " -mysql $mysqlopts -sr $database <<<"select sum((c - 1) * sub.filesize) 'Space saved by deduplication' from (select hash, filesize, count(*) c from files group by hash having c > 1 order by c) sub;" || echo "a" +mysql $mysqlopts -sr $database <<<"select coalesce(sum((c - 1) * sub.filesize), 0) 'Space saved by deduplication' from (select hash, filesize, count(*) c from files group by hash having c > 1 order by c) sub;" || echo "a" -- cgit v1.2.3-24-g4f1b