jcrespo added a comment.
There is this procedure: https://wikitech.wikimedia.org/wiki/MariaDB/query_performance which could be done for Wikidata by people with root database privileges, however it is quite involved. I will ask if maybe Manuel wants to perform soon such a thing for other main reasons (e.g. MCR changes checking) and maybe this could be checked at the same time. There is also performance_schema storing digests <https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html>, but it is unreliable due to the large amount of different query patterns mw/wikibase gets (it gets quickly out of memory after a server gets started). If the query was stored there, it howerver can reliably say when was the last time it was executed. Note that due to volume, all queries are almost impossible to be checked, only a high sigma of it, probabilistically. TASK DETAIL https://phabricator.wikimedia.org/T246232 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, jcrespo Cc: Michael, Lucas_Werkmeister_WMDE, Addshore, Aklapper, Marostegui, Ladsgroup, jcrespo, Hazizibinmahdi, Akuckartz, Iflorez, darthmon_wmde, alaa_wmde, Nandana, jijiki, Klaas_Z4us_V, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, elukey, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
