Jorge Bastos wrote:
Yes, i mean when that limit is reached
for an int(10)
9999999999
it goes BUM ? :P
----- Original Message ----- From: "Dmitri" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
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
[email protected]
https://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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
