LEIBOVICI Thomas <[email protected]> writes: > 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.
That fix might work, but for me personally it doesn't really seem worth backporting it. It seems like the simplest route would to just discard the the existing data. What would be the easiest way of doing this? Cheers, Loris -- Dr. Loris Bennett (Mr.) ZEDAT, Freie Universität Berlin Email [email protected] ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
