Skip to content
Rom Walton edited this page Feb 5, 2015 · 2 revisions

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 result.tmpid;

update result set id = tmpid;

alter table result auto_increment = 1;
Clone this wiki locally