Hi Thomas,
LEIBOVICI Thomas <[email protected]> writes:
> Hi Loris,
>
> robinhood updates --fs-info and --user-info on-the-fly to make them instantly
> available when you query it
> (this feature is known as "accounting" and is activated by {user,group}_acct
> parameters).
>
> Unlike fs-info and user-info, top-dirs is generated at the time you query it
> and
> is a very expensive request
> so it is expected to be much longer.
>
> However, in you case, I can't explain why it already returned 1 directory and
> don't print the 4 others
> as it did most of the sorting job if it could print the first directory.
> Perhaps there is a stuck DB request. You can check by running:
>
> mysql <your_db>
>> show process list;
I did 'show processlist;'. Apart from I bunch of sleeping processes I
have
INSERT INTO
ENTRIES(id,owner,gr_name,size,blocks,last_access,last_mod,type,mode,nlink,md_update,inva
which is presumably from the currently running scan and
Copying to tmp table | SELECT parent_id, COUNT(*) as dirattr_sort FROM NAMES
GROUP BY parent_id ORDER BY dirattr_sort DESC
which I assume is related to top-dirs.
Is that what I should see and is the running scan causing the slowness?
Cheers,
Loris
> Regards
> Thomas
>
>
> On 08/25/15 16:23, Loris Bennett wrote:
>> Hi,
>>
>> I ran
>>
>> rbh-report --top-dirs=5
>>
>> version 2.5.5-1 on a 17 TB NFS file system with a MySQL backend. Nearly
>> 3 hours later, only the first directory has been printed out. Commands
>> such as --fs-info and --user-info return almost immediately.
>>
>> Any ideas about what could be going on?
>>
>> Cheers,
>>
>> Loris
>>
--
This signature is currently under construction.
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support