Paul DuBois schreef:
> mmccaws2 wrote:
>> can I set an option so that when auto_increment reaches it's maximum
>> integer value, it will start all over at zero. I'm deleting every 15
>> minute the earlier entries, so I'm not too worried about the table
>> growing too large. Can mysql be set to roll once it's max value is
>> reached?
>
> No.
Right, but there are other ways to deal with this.
1.a. Maybe the type of the auto_increment column isn't UNSIGNED BIGINT
yet.
1.b. If it already is, insert a "page" column that is 0 for all current
records, and set the key to {page, auto_inc_column}, and switch to page
1.
2. If the auto_increment column is not referenced by anything, a
frequent maintenance run to 'floor' the keys could be used.
3. And I suppose you could even disable the auto-increment, and set up
an auto-incrementing trigger that uses a separate table to hold the last
used value, etc.
I think that #3 looks the worst.
--
Affijn, Ruud
"Gewoon is een tijger."
