Last modified: 2010-07-23 17:58:36 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 24455 - Show number of revs with each status on the status page
Show number of revs with each status on the status page
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
CodeReview (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-07-20 11:28 UTC by Sam Reed (reedy)
Modified: 2010-07-23 17:58 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sam Reed (reedy) 2010-07-20 11:28:43 UTC
Be useful to have the information in easy view. Simple queries as below:

<RoanKattouw> On the toolserver: 6 rows in set (6.48 sec)
<snip>
<RoanKattouw> It's a second faster on the cluster
<Reedy> That it?
<RoanKattouw> But that's still 5.5s
<Reedy> Yeah
<RoanKattouw> == too slow

mysql> SELECT cr_status, COUNT(*) FROM code_rev GROUP BY cr_status;
+-----------+----------+
| cr_status | COUNT(*) |
+-----------+----------+
| new       |    32444 | 
| fixme     |       65 | 
| reverted  |      615 | 
| resolved  |     1118 | 
| ok        |    32704 | 
| deferred  |    11016 | 
+-----------+----------+
6 rows in set (5.47 sec)

Tracking table is the alternative.

Also, any queries sorting/similar on cr_status are unindexed...
Comment 1 Sam Reed (reedy) 2010-07-21 19:16:34 UTC
Was trying to look at the query speed of bug 24455 but hindered as couldn't set
statuses via the gui


mysql> select COUNT(*), repo_name, cr_status FROM mw_code_rev cr, mw_code_repo
cp WHERE cr_repo_id = repo_id GROUP BY cr_repo_id, cr_status;
+----------+-----------------+-----------+
| COUNT(*) | repo_name       | cr_status |
+----------+-----------------+-----------+
|     6802 | autowikibrowser | new       |
|    69657 | MediaWiki       | new       |
+----------+-----------------+-----------+
2 rows in set (0.00 sec)

(but that's presumably cached after doing a couple of other queries)
Comment 2 Max Semenik 2010-07-23 17:58:36 UTC
Done in r69748.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links