Max messages questions

Who's using int(10)? DBMail has been using bigint(21) since
forever. 

Call me when you have more than 2 billion messages in one
mailbox and
we'll work on updating IMAP to handle 64 bit message
sequence numbers 

Aaron

On Tue, Dec 19, 2006, Jorge Bastos <mysql.jorgedecimal.pt> said:

> Yes, i mean when that limit is reached
> for an int(10)
> 9999999999
> 
> it goes BUM ? :P
> 
> ----- Original Message ----- 
> From: "Dmitri" <project1sharedlog.com>
> To: "DBMail mailinglist" <dbmaildbmail.org>
> Sent: Tuesday, December 19, 2006 11:34 PM
> Subject: Re: [Dbmail] Max messages questions
> 
> 
>> Jorge Bastos wrote:
>> 
>>> Hi,
>>>  
>>> My question may be dumb so prepare 
>>>  
>>> X-DBMail-PhysMessage-ID: 375180
>>>  
>>> This in the email's header is the message
number in the table, the 
>>> autoincrement i think, imagine that this value
has reached the limit 
>>> on the table, that is suposed to happen? (this,
for my case i think 
>>> wouln't be reached for the next 5 years).
>>> I'm just curious about it.
>>>  
>>> Jorge
>>>
>>>------------------------------------------------
------------------------
>>>
>>>_______________________________________________
>>>DBmail mailing list
>>>DBmaildbmail.org
>>>htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>  
>>>
>> There is a limit for auto increment counter?
>> I thought the limit was determined by the size of
the int(), so int(10) 
>> would be a highest 10-digits number.
>> 
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

-- 



_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail