Since gerrit 67468 it is possible to use [[Special:MIMESearch]] in miser mode.
It would be nice to have it also work for api. list=allimages has a aimime= param, but that is disabled in miser mode due to bad performance on the database.
You can also found some comments about the performance in gerrit 76954.
Created a bug to keep this in mind, maybe some days this is possible.
Version: 1.22.0
Severity: enhancement
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T28394 Missing Indexes, Inefficient queries and alike (tracking) | |||
| Open | None | T24744 Add/Update indexes for queries done by the API (tracking) | |||
| Open | Feature | None | T54415 Allow mime search of api works in miser mode |
OK, so my apologies for being a bit under-experienced in the MimeMagic field of MediaWiki (I don't do much upload work), but I recently discovered the MimeMagic::findMediaType() function. Using this function should allow complete avoidance of using a range index match since we can now just specify all columns exactly.
If we were to add an index on (img_media_type, img_mime_major, img_mime_minor, img_name) (forgive me if those column names aren't accurate), it should make an efficient query on this very much possible. Also, it would allow sorting in Special:MIMESearch as well, which would be helpful.
(In reply to comment #1)
OK, so my apologies for being a bit under-experienced in the MimeMagic field
of
MediaWiki (I don't do much upload work), but I recently discovered the
MimeMagic::findMediaType() function. Using this function should allow
complete
avoidance of using a range index match since we can now just specify all
columns exactly.
If that can be done, then it might just work. But are there any old rows identified as 'UNKNOWN' where the type is now known?
If we were to add an index on (img_media_type, img_mime_major,
img_mime_minor,
img_name) (forgive me if those column names aren't accurate), it should make
an
efficient query on this very much possible. Also, it would allow sorting in
Special:MIMESearch as well, which would be helpful.
You can test it now, if you have MySQL with InnoDB, since the primary key is img_name. See bug 24782 comment 16 for details.
(In reply to comment #2)
If that can be done, then it might just work. But are there any old rows
identified as 'UNKNOWN' where the type is now known?
Hmm, how would I find this out?
You can test it now, if you have MySQL with InnoDB, since the primary key is
img_name. See bug 24782 comment 16 for details.
Interesting. I'll see if I can check this on my database later tonight.
(In reply to comment #3)
(In reply to comment #2)
If that can be done, then it might just work. But are there any old rows
identified as 'UNKNOWN' where the type is now known?Hmm, how would I find this out?
Easiest way would be to get an account on Tool Labs[1] if you don't already have one, and look in the replicated databases.
[1]: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help