In addition to r65013: Please allow listing of files per user.
Maybe add a aiuser to list=allimages.
Thanks.
Version: 1.18.x
Severity: enhancement
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=65121
Description
Description
Details
Details
- Reference
- bz26872
| 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) | |||
| Declined | None | T48839 My Uploads feature of Android App fetches its information from log | |||
| Resolved | Ciencia_Al_Poder | T28872 API: allow listing of files uploaded by user |
Event Timeline
Comment Actions
Bryan.TongMinh wrote:
Somebody who has knowledge about how mysql handles indices needs to look into this. I don't know if MySQL is able to merge three indices to make the required query sane.
Comment Actions
(In reply to comment #2)
Somebody who has knowledge about how mysql handles indices needs to look into
this. I don't know if MySQL is able to merge three indices to make the required
query sane.
There is no such thing as merging indices.
There is an index on (img_user_text, img_timestamp), we could use that. However, we'd have to sort and page by timestamp instead of name (kind of annoying since timestamps aren't necessarily unique), and we couldn't support any other limiting parameters (aisha1, aiprefix, etc.) in combination with aiuser.
Comment Actions
Bryan.TongMinh wrote:
(In reply to comment #3)
(In reply to comment #2)
Somebody who has knowledge about how mysql handles indices needs to look into
this. I don't know if MySQL is able to merge three indices to make the required
query sane.There is no such thing as merging indices.
Well, then we're pretty screwed already, as we are sorting by img_name and have conditions on img_size, which are two separate indices.
We should first make sure that img_name is included in all indices.
Comment Actions
(In reply to comment #4)
We should first make sure that img_name is included in all indices.
tracking to bug 22744, maybe someone has time to look at the indices.
Comment Actions
Here I am going to provide some more use cases:
To create
- A gallery the files uploaded by one user
- A slideshow of files uploaded by one user
To enhance
- The mobile App's feature "My Uploads" see Bug 46839
Comment Actions
Request filed years ago, silent during the past year. Setting priority to Lowest in order to reflect the current situation.
Comment Actions
(In reply to Quim Gil from comment #9)
Request filed years ago, silent during the past year.
Perhaps because there is now
https://commons.wikimedia.org/w/api.php?action=query&list=allimages&aiuser=Rillke&aisort=timestamp
I don't know whom to thank but ... Thank you!
Comment Actions
Just to be sure, you mean that this report has been FIXED?
Marking as such, please revert if I was too optimistic. Also, does anybody know in which release was this fixed?
Comment Actions
Was added with gerrit 23984 along with aisort=timestamp
(In reply to Quim Gil from comment #9)
Request filed years ago, silent during the past year.
Unfortunately there are many bugs without actions in the past years ...