Last modified: 2010-07-23 17:58:36 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...
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)
Done in r69748.