DbIds

What to do when you run out of database IDs

If your project processes 2^32^ jobs you'll run out of IDs in the result table. If this happens you can compress the ID space using the following queries:

alter table result add column tmpid int;

set @count = 0;
update result set tmpid = @count:= @count + 1;

update workunit inner join result on result.id = workunit.canonical_resultid set workunit.canonical_resultid = result.tmpid;

update result set id = tmpid;

alter table result auto_increment = 1;