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

Reply via email to