[16:19:39] <Krinkle>	 AaronSchulz: could use your input at https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1072816 - trying to understand a bit around lock manager and the lockTTL setting.
[16:45:59] <Krinkle>	 I'm looking at https://wikitech.wikimedia.org/wiki/MediaWiki_Engineering/Guides/Backend_performance_practices#Indexing and not able to find what "One of them also offers a reverse index, which gives you a cheap alternative to SORT BY. " refers to
[16:46:33] <Krinkle>	 I've checked old MW versions for ipblocks and page_props, but I'm not sure which one is meant by "reverse index". 
[16:53:11] <Lucas_WMDE>	 I can’t make sense of it either
[16:53:50] <Lucas_WMDE>	 I think my best guess is page_props?
[16:54:20] <Lucas_WMDE>	 where the primary key is pp_page, pp_propname and the “reverse index” could be pp_propname_sortkey_page (“reverse” referring to the columns – first pp_propname and pp_sortkey, then pp_page)