Status ID closing in on maximum unsigned integer

222 views
Skip to first unread message

Matt Sanford

unread,
May 13, 2009, 10:38:53 AM5/13/09
to Twitter Development Talk
Hi all,

Just a quick heads up. Our status id is fast approaching the
maximum unsigned integer value. Based on all of the feedback on
scaling I've received from this list I'm assuming everyone will be
fine. One thing to check is your table definitions … no amount of
interpreted language will save you from that. I think the tipping
point will be this afternoon sometime but with the planned maintenance
it might end up being later in the day.

Thanks;
— Matt Sanford / @mzsanford

Matt Sanford

unread,
May 13, 2009, 10:40:50 AM5/13/09
to Twitter Development Talk
Make that *signed* integer. Writing too many emails at once, sorry.

Chad Etzel

unread,
May 13, 2009, 10:59:19 AM5/13/09
to twitter-deve...@googlegroups.com
I'm assuming this is just a friendly warning to developers... and that
the status IDs will continue to monotonically increase past (2^31 -
1), i.e. not rollover?

-Chad

Dossy Shiobara

unread,
May 13, 2009, 10:59:40 AM5/13/09
to twitter-deve...@googlegroups.com
When you say "integer" what are you referring to? I'm _assuming_ 32-bit
integers, not 64-bit integers, because ILP-32 is so commonplace.

When you're about to breach the 2^64 in your ID space, please give us a
heads-up around 2^63 so we can upgrade our systems. :)


--
Dossy Shiobara | do...@panoptic.com | http://dossy.org/
Panoptic Computer Network | http://panoptic.com/
"He realized the fastest way to change is to laugh at your own
folly -- then you can let go and quickly move on." (p. 70)

Matt Sanford

unread,
May 13, 2009, 11:04:44 AM5/13/09
to twitter-deve...@googlegroups.com
Hi Chad,

They will continue to increment. This was, as you assumed, just a
friendly reminder.

Thanks;
– Matt Sanford / @mzsanford

Twitter Dev

Matt Sanford

unread,
May 13, 2009, 11:08:29 AM5/13/09
to twitter-deve...@googlegroups.com
Hi Dossy,

I did indeed mean 32-bit signed integer. 64 bit is increasingly
common but so are people defining table using INTEGER or INT(10) or
whatever their database calls it. When we breach 2^64 I'm not telling
anyone … it seems to create more work for me when I send out friendly
warnings :)

Thanks;
– Matt Sanford / @mzsanford

Twitter Dev

See Also: http://twitter.com/dougw/status/1741587950

Nick Arnett

unread,
May 13, 2009, 11:13:20 AM5/13/09
to twitter-deve...@googlegroups.com
On Wed, May 13, 2009 at 7:40 AM, Matt Sanford <ma...@twitter.com> wrote:

Make that *signed* integer. Writing too many emails at once, sorry.

That would be the MySQL (and any 32-bit OS) maximum signed integer, or 2,147,483,647, I'm assuming.  So if we're using an unsigned INT in our tables, we're fine for a while (months?) - status IDs will always be positive, right?  And BIGINT, especially unsigned, is safe for a long, long time?

Just curious... does this mean Twitter really is closing in on 2 billion tweets, or were some IDs skipped?  Is there a prize for whoever posts tweet number 2 billion?  ;-)

Nick

Matt Sanford

unread,
May 13, 2009, 11:19:34 AM5/13/09
to twitter-deve...@googlegroups.com
Hi Nick,

    As mentioned to Dossy (probably still wending its way thought Google Groups) I did mean 32-bit signed integers. Unsigned ints in MySQL will be fine but the rails default is int(10) if I recall which would be a problem. As mentioned to Chad (Google Groups seems to be slow delivering my messages :/) status IDs will continue to increment as positive numbers. BIGINT and unsigned number should be fine for the time being, yes.
    You know we don't comment on the number of users and tweets … but you almost tricked me. Sneaky, sneaky.

Thanks;
 – Matt Sanford / @mzsanford
     Twitter Dev

Chad Etzel

unread,
May 13, 2009, 11:21:36 AM5/13/09
to twitter-deve...@googlegroups.com
On Wed, May 13, 2009 at 11:08 AM, Matt Sanford <ma...@twitter.com> wrote:
> When we breach 2^64 I'm not telling anyone … it seems to
> create more work for me when I send out friendly warnings :)

Well, if you *did* send out a warning at 2^64, it would mean either:

a) you have found the fountain of youth
b) you're a zombie
c) you wrote the most awesome cron job ever
d) you have a Delorean

-Chad

Andrew Badera

unread,
May 13, 2009, 11:26:15 AM5/13/09
to twitter-deve...@googlegroups.com
or e) Twitter becomes even more massively popular while the world also
undergoes a birth rate revoluion.

Thanks-
- Andy Badera
- and...@badera.us
- Google me: http://www.google.com/search?q=andrew+badera
- This email is: [ ] bloggable [x] ask first [ ] private

Matt Sanford

unread,
May 13, 2009, 11:28:23 AM5/13/09
to twitter-deve...@googlegroups.com
Have you not heard, we're tweeting from space these days. Birth rate
changes are now considered optional.

No Humans Required™
— Matt

Nick Arnett

unread,
May 13, 2009, 11:35:56 AM5/13/09
to twitter-deve...@googlegroups.com
On Wed, May 13, 2009 at 8:19 AM, Matt Sanford <ma...@twitter.com> wrote:

    You know we don't comment on the number of users and tweets … but you almost tricked me. Sneaky, sneaky.

Actually, I did not know that.  I might have known if there were an API call to get the total number of tweets, which returned NULL every time.  Perhaps you'll want to add that... ;-)

I still think there should be a prize.

I see that the product manager/APIs position is still on your site... does that mean the position is still open?  Does teasing the API team help as a qualification?  

Nick 

Cameron Kaiser

unread,
May 13, 2009, 1:49:32 PM5/13/09
to twitter-deve...@googlegroups.com
> I see that the product manager/APIs position is still on your site... does
> that mean the position is still open? Does teasing the API team help as a
> qualification?

It may get you an interview, but only so they can surreptitiously get a
photo and send it to the nice Italian men with the kneecappers.

--
------------------------------------ personal: http://www.cameronkaiser.com/ --
Cameron Kaiser * Floodgap Systems * www.floodgap.com * cka...@floodgap.com
-- They told me I was gullible ... and I believed them. -----------------------

Matt Sanford

unread,
May 13, 2009, 3:12:21 PM5/13/09
to twitter-deve...@googlegroups.com
Quick update …

While looking at the code that reminded me of this error I see it
had some bugs of its own. We seem to have a matter of weeks rather
than days before this change. Mobile developers and other who deride
our lack of early notice take heed … now is the time to go unsigned.

Thanks;
– Matt Sanford / @mzsanford
Twitter Dev

Craig Hockenberry

unread,
May 13, 2009, 9:07:57 PM5/13/09
to Twitter Development Talk
Let me be the first to say THANK YOU for this advance notice. I found
and fixed some bugs in our iPhone client today because of it — and I'm
very happy to hear that we have some time to get the code approved in
the App Store.

We love to complain when the process goes awry, but it's also
important to remember to give credit when it's well and truly due.
Thanks again!

-ch

On May 13, 12:12 pm, Matt Sanford <m...@twitter.com> wrote:
> Quick update …
>
>      While looking at the code that reminded me of this error I see it  
> had some bugs of its own. We seem to have a matter of weeks rather  
> than days before this change. Mobile developers and other who deride  
> our lack of early notice take heed … now is the time to go unsigned.
>
> Thanks;
>   – Matt Sanford / @mzsanford
>       Twitter Dev
>
> On May 13, 2009, at 10:49 AM, Cameron Kaiser wrote:
>
>
>
>
>
> >> I see that the product manager/APIs position is still on your  
> >> site... does
> >> that mean the position is still open?  Does teasing the API team  
> >> help as a
> >> qualification?
>
> > It may get you an interview, but only so they can surreptitiously  
> > get a
> > photo and send it to the nice Italian men with the kneecappers.
>
> > --
> > ------------------------------------ personal:http://www.cameronkaiser.com/
> >  --
> >  Cameron Kaiser * Floodgap Systems *www.floodgap.com* ckai...@floodgap.com

Martin Dufort

unread,
May 15, 2009, 10:07:39 AM5/15/09
to Twitter Development Talk
And you can check on the progress of that Status ID on: www.twitpocalypse.com
Unless Twitter decides to blacklist us) for sending too many requests
to the public timeline API...

So Twitter, if you do so, please send me an email martin [insert at]
wherecloud [dot] com so we can work something out :-)

Martin - www.wherecloud.com


On May 13, 9:07 pm, Craig Hockenberry <craig.hockenbe...@gmail.com>
wrote:

Patrick Burrows

unread,
May 15, 2009, 11:14:12 AM5/15/09
to twitter-deve...@googlegroups.com
Hilarious!

--
Patrick Burrows
http://Categorical.ly (the Best Twitter Client Possible)
@Categorically

mwm

unread,
May 15, 2009, 2:52:22 PM5/15/09
to Twitter Development Talk
I'm using a bigint (20) with MySQL for TwitteReader so
18446744073709551615 available. Still many IDs to go ;)
Reply all
Reply to author
Forward
0 new messages