On 09/13/16 08:55, Loris Bennett wrote:
>
> This seemed to help. However, the scan is still running very slowly:
>
> +--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
> | Id | Command | Time | State | Info
> |
> +--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
> | 150429 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447782' |
> | 150430 | Query | 58372 | Locked | INSERT INTO
> NAMES(id,parent_id,name,path_update,pkn) VALUES
> ('63BBC16B:2FFC5E3','63BBC16B:2FFC27C',' |
> | 150431 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447787' |
> | 150432 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447781' |
> | 150433 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447780' |
> | 150434 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447785' |
> | 150435 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447734' |
> | 150436 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:2FFF03D' |
> | 150437 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:2FFF03C' |
> | 150438 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447788' |
> | 150439 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447784' |
> | 150440 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:2FFF03A' |
> | 150441 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447786' |
> | 150442 | Query | 58372 | Locked | SELECT id FROM ENTRIES WHERE
> id='63BBC16B:2FFC27C' |
> | 150443 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447789' |
> | 150444 | Query | 58372 | Locked | SELECT release_class FROM
> ENTRIES WHERE ENTRIES.id='63BBC16B:9447783' |
> | 150446 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641783,last_mod=13736
> |
> | 150447 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641793,last_mod=13736
> |
> | 150448 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641786,last_mod=13736
> |
> | 150449 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641793,last_mod=13736
> |
> | 150450 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641783,last_mod=13736
> |
> | 150451 | Query | 58372 | Locked | UPDATE ENTRIES SET
> owner='root',gr_name='root',size=0,blocks=0,last_access=1373641784,last_mod=13736
> |
> | 150452 | Sleep | 57 | | NULL
> |
> | 150453 | Query | 58372 | statistics | SELECT parent_id, name INTO
> pid, n from NAMES where id= NAME_CONST('pid',_latin1'63BBC16B:2AA1015' C |
> | 150481 | Sleep | 33 | | NULL
> |
> | 152540 | Query | 7 | Sorting result | SELECT id FROM ENTRIES WHERE
> (ENTRIES.invalid=0 OR ENTRIES.invalid IS NULL) AND ENTRIES.type<>'dir' |
> | 152541 | Sleep | 7 | | NULL
> |
> | 152542 | Sleep | 7 | | NULL
> |
> | 152543 | Sleep | 7 | | NULL
> |
> | 152544 | Sleep | 7 | | NULL
> |
> | 152545 | Sleep | 7 | | NULL
> |
> | 152546 | Sleep | 7 | | NULL
> |
> | 153052 | Query | 0 | NULL | show processlist
> |
> +--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
>
> As a lot of files has been deleted, I think I may need to look at
> OPTIMIZE TABLE. Would 'ENTRIES' be the most relevant table to optimise?
>
> Cheers,
>
> Loris
>
Again, it seams all requests are locked, by "150453", or "152540" ?.
I wonder if that fix could help:
https://review.gerrithub.io/#/c/291017/1
However it is for v3 and must be adapted to v2.5.x if you need it.
Thomas.
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
