diff options
Diffstat (limited to 'extras/munin/filebin_stats')
| -rw-r--r-- | extras/munin/filebin_stats | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/extras/munin/filebin_stats b/extras/munin/filebin_stats index f7e3bbeac..4396c3503 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 coalesce(sum(filesize), 0) 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 file_storage;" || echo "a" echo -n "dedup.value " -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" +mysql $mysqlopts -sr $database <<<"select coalesce(sum((c - 1) * sub.filesize), 0) 'Space saved by deduplication' from (select fs.id, filesize, count(*) c from files join file_storage fs on fs.id = files.file_storage_id group by fs.id having c > 1 order by c) sub;" || echo "a" |