On Sep 20, 2009 10:49 PM, "Tim Starling"
<tstarling(a)wikimedia.org> wrote:
APseudoUtopia wrote: > I'm running MW
1.15.1. I'm having a problem with the
Job Queue. I > noticed t...
This is most likely due to a known bug in Special:Statistics, which
causes it to give inaccurate numbers for the number of jobs remaining
in the queue. You can get an accurate count by running an SQL query,
say using phpMyAdmin:
SELECT COUNT(*) FROM jobs;
On that note, is there really any better way we could
do this? Right now if I'm remember correctly we check
the results of an EXPLAIN for an estimate. Is select
count(*) just impossibly slow, even if we cached the
result for an hour or whatever?
It's only slow if there are a large number of jobs. We could just do
the EXPLAIN, and if it's less than say 10000, then we could follow it
up with a COUNT(*) to get a more accurate result.
-- Tim Starling