On Mon, Sep 26, 2011 at 4:59 PM, Ariel T. Glenn <ariel(a)wikimedia.org> wrote:
Στις 26-09-2011, ημέρα Δευ, και ώρα 08:47 +0200, ο/η
melvin_mm έγραψε:
> > mysql> select max(rev_id) from revision;
> > +-------------+
> > | max(rev_id) |
> > +-------------+
> > | 452476647 |
> > +-------------+
> > 1 row in set (0.00 sec)
> >
As you say, there are gaps in the rev_id sequence due to undeleted
revisions and possibly the occasional transaction-rollback-induced
gap. The real real number would be SELECT COUNT(*) FROM revision; but
that'll probably take like half an hour to count all rows.
Roan Kattouw (Catrope)