https://bugzilla.wikimedia.org/show_bug.cgi?id=61111

Bawolff (Brian Wolff) <bawolff...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bawolff...@gmail.com

--- Comment #5 from Bawolff (Brian Wolff) <bawolff...@gmail.com> ---
The biggest two of those primary keys are (The other's are at least an order of
magnitude smaller):

MariaDB [enwiki_p]> select max(rc_id) from recentchanges;
+------------+
| max(rc_id) |
+------------+
|  636232414 |
+------------+
1 row in set (0.04 sec)

MariaDB [enwiki_p]> select max(rev_id) from revision;
+-------------+
| max(rev_id) |
+-------------+
|   594743381 |
+-------------+


So in 13 years, we've managed to get up to an rc_id of 636,232,414 or about 30%
of possible values (Since rc_id appears to be unsigned for some reason). It
doesn't seem like this is something we should really be worrying about. It also
doesn't seem like fixing this will really become any harder in the future than
it is now. Thus this seems like a solution in search of a problem. (Although
perhaps making the default schema have these fields be unsigned might be a good
idea just for cleanliness sake)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to