OK, I've tried a few times. Did some mysql tuning and what I have now is:
2016/09/09 09:12:46 [21484/2] STATS | ==================== Dumping stats at
2016/09/09 09:12:46 =====================
2016/09/09 09:12:46 [21484/2] STATS | ======== General statistics =========
2016/09/09 09:12:46 [21484/2] STATS | Daemon start time: 2016/09/09 08:42:45
2016/09/09 09:12:46 [21484/2] STATS | Started modules: log_reader
2016/09/09 09:12:46 [21484/2] STATS | ChangeLog reader #0:
2016/09/09 09:12:46 [21484/2] STATS | fs_name = plkra
2016/09/09 09:12:46 [21484/2] STATS | mdt_name = MDT0000
2016/09/09 09:12:46 [21484/2] STATS | reader_id = cl1
2016/09/09 09:12:46 [21484/2] STATS | records read = 1830902
2016/09/09 09:12:46 [21484/2] STATS | interesting records = 1830620
2016/09/09 09:12:46 [21484/2] STATS | suppressed records = 282
2016/09/09 09:12:46 [21484/2] STATS | records pending = 1000
2016/09/09 09:12:46 [21484/2] STATS | last received =
2016/09/09 09:04:13
2016/09/09 09:12:46 [21484/2] STATS | last read record time =
2016/09/07 20:28:30.099225
2016/09/09 09:12:46 [21484/2] STATS | last read record id = 18391116
2016/09/09 09:12:46 [21484/2] STATS | last pushed record id = 18390117
2016/09/09 09:12:46 [21484/2] STATS | last committed record id = 18380083
2016/09/09 09:12:46 [21484/2] STATS | last cleared record id = 18379864
2016/09/09 09:12:46 [21484/2] STATS | read speed = 677.18
record/sec
2016/09/09 09:12:46 [21484/2] STATS | processing speed ratio = 4.00
2016/09/09 09:12:46 [21484/2] STATS | status = busy
2016/09/09 09:12:46 [21484/2] STATS | ChangeLog stats:
2016/09/09 09:12:46 [21484/2] STATS | MARK: 0, CREAT: 262, MKDIR: 9,
HLINK: 0, SLINK: 0, MKNOD: 0, UNLNK: 7, RMDIR: 0, RENME: 0
2016/09/09 09:12:46 [21484/2] STATS | RNMTO: 0, OPEN: 0, CLOSE: 0,
LYOUT: 0, TRUNC: 48, SATTR: 1830576, XATTR: 0, HSM: 0
2016/09/09 09:12:46 [21484/2] STATS | MTIME: 0, CTIME: 0, ATIME: 0
2016/09/09 09:12:46 [21484/2] STATS | ==== EntryProcessor Pipeline Stats ===
2016/09/09 09:12:46 [21484/2] STATS | Idle threads: 0
2016/09/09 09:12:46 [21484/2] STATS | Id constraints count: 10000 (hash
min=0/max=6/avg=0.6)
2016/09/09 09:12:46 [21484/2] STATS | Name constraints count: 18 (hash
min=0/max=1/avg=0.0)
2016/09/09 09:12:46 [21484/2] STATS | Stage | Wait | Curr |
Done | Total | ms/op |
2016/09/09 09:12:46 [21484/2] STATS | 0: GET_FID | 0 | 0 |
0 | 0 | 0.00 |
2016/09/09 09:12:46 [21484/2] STATS | 1: GET_INFO_DB | 9990 | 0 |
0 | 1819630 | 0.20 |
2016/09/09 09:12:46 [21484/2] STATS | 2: GET_INFO_FS | 0 | 10 |
0 | 1819613 | 3.75 |
2016/09/09 09:12:46 [21484/2] STATS | 3: PRE_APPLY | 0 | 0 |
0 | 1819606 | 0.00 |
2016/09/09 09:12:46 [21484/2] STATS | 4: DB_APPLY | 0 | 0 |
0 | 1819606 | 0.17 | 99.76% batched (avg batch size: 17.0)
2016/09/09 09:12:46 [21484/2] STATS | 5: CHGLOG_CLR | 0 | 0 |
0 | 1819620 | 0.01 |
2016/09/09 09:12:46 [21484/2] STATS | 6: RM_OLD_ENTRIES | 0 | 0 |
0 | 0 | 0.00 |
2016/09/09 09:12:46 [21484/2] STATS | DB ops:
get=1819360/ins=246/upd=1819360/rm=0
2016/09/09 09:12:46 [21484/2] STATS | --- Pipeline stage details ---
2016/09/09 09:12:46 [21484/2] STATS | GET_INFO_DB : first: changelog
record #18380115, fid=[0x2000291ab:0xdb7b:0x0], status=waiting
2016/09/09 09:12:46 [21484/2] STATS | GET_INFO_DB : last: changelog
record #18390116, fid=[0x200002eae:0x1b148:0x0], status=waiting
2016/09/09 09:12:46 [21484/2] STATS | GET_INFO_FS : first: changelog
record #18380085, fid=[0x200025ab0:0x1a350:0x0], status=processing
2016/09/09 09:12:46 [21484/2] STATS | GET_INFO_FS : last: changelog
record #18380112, fid=[0x2000291ab:0xdb7a:0x0], status=processing
Whay do someone experienced with robinhood can read from this? I see that I
have a lot of waiting GET_INFO_DB operations - does it mean my database is
responding slow? Should I check slow queries?
My server responsiveness is limited :)
What I have from I/O stat is:
avg-cpu: %user %nice %system %iowait %steal %idle
0.02 0.00 80.22 0.00 0.00 19.76
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 1.88 0.00 0.02 0 0
cheers,
Marcin
2016-09-07 13:31 GMT+02:00 LEIBOVICI Thomas <[email protected]>:
> On 09/07/16 13:03, Marcin Stolarek wrote:
>
> Hi,
>
> I installed robinhood 3.0-rc1 with lustre 2.5. Initial scan of the
> filesystem took around 2 days. For this time the changelog was enabled.
> Today I started:
> #robinhood --readlog --once
> and after a few hours robinhood process started to use a lot of CPU
> (around 700% - everything available). Is this normal?
>
> Why not... if it's for doing useful things, such as processing bursts of
> changelogs :)
> But I'd say it may also be the sign of something wrong...
> You can check if the changelog processing is going well and how it evolved:
> grep STATS /var/log/robinhood.log
>
> Thomas
>
>
> cheers,
> Marcin
>
>
> ------------------------------------------------------------------------------
>
>
>
> _______________________________________________
> robinhood-support mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/robinhood-support
>
>
>
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support