On Mon, Sep 26, 2011 at 4:59 PM, Ariel T. Glenn ariel@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)