Max messages questions

Jorge Bastos wrote:

> 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
>
>
>
I think that by default the messageid is bigint(21), so it's
actually up 
to the maximum possible number that mysql can store, which
is 
|18446744073709551615
after that I suppose you can delete a couple billions of old
emails and 
start over.
|

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