Slow query on where clause in composite primary key

[timsehn]

Database: https://www.dolthub.com/repositories/timsehn/media_wiki

Query:

SELECT /* MediaWiki\\Deferred\\LinksUpdate\\LinksTable::fetchExistingRows */ pp_propname,pp_value FROM `page_props` WHERE pp_page = 4003405
               -> ;
Empty set (317.22 sec)

Schema:

CREATE TABLE `page_props` (
  `pp_page` int unsigned NOT NULL,
  `pp_propname` varbinary(60) NOT NULL,
  `pp_value` blob NOT NULL,
  `pp_sortkey` float DEFAULT NULL,
  PRIMARY KEY (`pp_page`,`pp_propname`),
  UNIQUE KEY `pp_propname_page` (`pp_propname`,`pp_page`),
  UNIQUE KEY `pp_propname_sortkey_page` (`pp_propname`,`pp_sortkey`,`pp_page`)
) ENGINE=InnoDB DEFAULT CHARSET=binary COLLATE=binary

Weirdly, even explain on this one is slow indicating it may be a bug in analysis:

media_wiki/main*> explain SELECT /* MediaWiki\\Deferred\\LinksUpdate\\LinksTable::fetchExistingRows */ pp_propname,pp_value FROM `page_props` WHERE pp_page = 4003405 ;
+------------------------------------------------------------+
| plan                                                       |
+------------------------------------------------------------+
| Project                                                    |
|  ├─ columns: [page_props.pp_propname, page_props.pp_value] |
|  └─ IndexedTableAccess(page_props)                         |
|      ├─ index: [page_props.pp_page,page_props.pp_propname] |
|      ├─ filters: [{[4003405, 4003405], [NULL, ∞)}]         |
|      └─ columns: [pp_page pp_propname pp_value]            |
+------------------------------------------------------------+
6 rows in set (310.19 sec)

[timsehn]

Subsequent runs of analyse returned fast:

media_wiki/main*> explain SELECT /* MediaWiki\\Deferred\\LinksUpdate\\LinksTable::fetchExistingRows */ pp_propname,pp_value FROM `page_props` WHERE pp_page = 4003405 ;
+------------------------------------------------------------+
| plan                                                       |
+------------------------------------------------------------+
| Project                                                    |
|  ├─ columns: [page_props.pp_propname, page_props.pp_value] |
|  └─ IndexedTableAccess(page_props)                         |
|      ├─ index: [page_props.pp_page,page_props.pp_propname] |
|      ├─ filters: [{[4003405, 4003405], [NULL, ∞)}]         |
|      └─ columns: [pp_page pp_propname pp_value]            |
+------------------------------------------------------------+
6 rows in set (0.00 sec)

[timsehn]

This one was caused by a blocking job.