X-Git-Url: https://git.cyclocoop.org/%27.WWW_URL.%27admin/?a=blobdiff_plain;f=includes%2Flogging%2FLogPager.php;h=0b78a3603307ddb647d824b8b5b4da1732663c9f;hb=f704207ba129198e21ada72c2961e5bd26ac3227;hp=781df06f491b60df678960f1bac5f83914c03b29;hpb=af80076034fb734d652eb043c523c1d8df974e51;p=lhc%2Fweb%2Fwiklou.git

diff --git a/includes/logging/LogPager.php b/includes/logging/LogPager.php
index 781df06f49..0b78a36033 100644
--- a/includes/logging/LogPager.php
+++ b/includes/logging/LogPager.php
@@ -361,6 +361,11 @@ class LogPager extends ReverseChronologicalPager {
 		if ( !$this->mTagFilter && !array_key_exists( 'ls_field', $this->mConds ) ) {
 			$options[] = 'STRAIGHT_JOIN';
 		}
+		if ( $this->performer !== '' ) {
+			// T223151: MariaDB's optimizer, at least 10.1, likes to choose a wildly bad plan for
+			// some reason for this code path. Tell it not to use the wrong index it wants to pick.
+			$options['IGNORE INDEX'] = [ 'logging' => [ 'times' ] ];
+		}
 
 		$info = [
 			'tables' => $tables,