[mirrorbrain] Seeing how many files a mirror have

From: Dr. Peter Pöml <peter_at_poeml.de>
Date: Tue, 7 Aug 2012 06:24:36 +0200

I saw this question on IRC the other day.

How many files a mirror has is displayed during scanning. The known number of files can be more quickly queried directly from the database, though. The following command does this:

echo "SELECT count(id) FROM filearr WHERE (SELECT id FROM server WHERE identifier LIKE 'ftp5.gwdg.de') = ANY(mirrors);" | mb db shell

Replace the mirror identifier with the name of the mirror you refer to.

Indeed, this should be a made a command in the mb tool. 

mirrorbrain mailing list
Archive: http://mirrorbrain.org/archive/mirrorbrain/

Note: To remove yourself from this mailing list, send a mail with the content
to the address mirrorbrain-request_at_mirrorbrain.org
Received on Tue Aug 07 2012 - 04:24:47 GMT

This archive was generated by hypermail 2.3.0 : Tue Aug 07 2012 - 18:17:06 GMT