Hi Tru,

Per-user stats are generated on-the-fly and maintained in the DB, so 
--top-users is instantaneous.

--top-dirs is implemented as a big SQL "group by" on all directory 
entries, moreover it has to be sorted,
that's why it can take a long time depending on your FS inode count.
I noticed it can take 1h for 100M entries FS, but it's not a big deal as 
long as
it is not a robinhood critical task, just a report you run sometimes.

To see what's going on:
 > mysql <robinhood_db>
myqsl> show processlist;

Also, if you have not tuned your MySQL engine yet, I suggest you do it
(see DB tunings in robinhood 2.5 documentation).

Regards,
Thomas


Le 07/03/2014 20:03, Tru Huynh a écrit :
> this is fast (few seconds)
> [tru@houyo ~]$ sudo rbh-report --top-users
> Using config file '/etc/robinhood.d/tmpfs/houyo.conf'.
> rank, user      ,   spc_used,      count,   avg_size
>     1, xxxxxxxx  ,  989.14 GB,      35376,   28.63 MB
>     2, xxxxxxxx  ,  930.31 GB,    1473355,  659.68 KB
>     3, xxxxxxxx  ,  653.22 GB,    2357423,  288.26 KB
>     4, xxxxxxxx  ,  436.51 GB,       5274,   84.45 MB
>     5, xxxxxxxx  ,  361.58 GB,     324562,    1.13 MB
>     6, xxxxxxxx  ,  353.78 GB,      19944,   18.16 MB
>     7, xxxxxxxx  ,  344.44 GB,      30215,   11.67 MB
>     8, xxxxxxxx  ,  256.18 GB,     222770,    1.18 MB
>     9, xxxxxxxx  ,  106.18 GB,     579981,  189.14 KB
>    10, xxxxxxxx  ,   39.36 GB,       1578,   20.59 MB
>    11, xxxxxxxx  ,   13.03 GB,       7817,    1.70 MB
>    12, xxxxxxxx  ,    6.53 GB,      11961,  567.25 KB
>    13, xxxxxxxx  ,    1.52 GB,       2507,  631.87 KB
>    14, xxxxxxxx  ,  711.38 MB,          2,  355.68 MB
>
> but this command has been running for minutes and is not yet finished
> [tru@houyo ~]$ sudo rbh-report --top-dirs
> Using config file '/etc/robinhood.d/tmpfs/houyo.conf'.
>
> top does not report anythin special
>
> top - 20:01:19 up 3 days,  6:15,  2 users,  load average: 3.17, 2.77, 2.36
> Tasks: 124 total,   1 running, 123 sleeping,   0 stopped,   0 zombie
> Cpu(s):  1.8%us,  1.5%sy,  0.0%ni, 50.3%id, 46.4%wa,  0.0%hi,  0.0%si,
> 0.0%st
> Mem:   5927456k total,  5321392k used,   606064k free,   136980k buffers
> Swap:        0k total,        0k used,        0k free,  2101128k cached
>
>    PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 11460 root      20   0 1018m 208m 1224 S  0.0  3.6  51:53.17 robinhood
>   1281 mysql     20   0 1145m  51m 3640 S  7.3  0.9 362:45.04 mysqld
> 11583 apache    20   0  429m  16m 4256 S  0.0  0.3   0:02.93 httpd
> 11588 apache    20   0  431m  16m 2020 S  0.0  0.3   0:02.22 httpd
>
> Cheers,
>
> Tru


------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works. 
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
robinhood-support mailing list
robinhood-support@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/robinhood-support

Reply via email to