Changes between Initial Version and Version 1 of DbIds


Ignore:
Timestamp:
08/12/14 09:46:32 (3 years ago)
Author:
davea
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DbIds

    v1 v1  
     1= What to do when you run out of database IDs =
     2
     3If your project processes 2^32^
     4jobs you'll run out of IDs in the result table.
     5If this happens you can compress the ID space using the following queries:
     6{{{
     7alter table result add column tmpid int;
     8
     9set @count = 0;
     10update result set tmpid = @count:= @count + 1;
     11
     12update workunit inner join result on result.id = workunit.canonical_resultid set workunit.canonical_resultid = result.tmpid;
     13
     14update result set id = tmpid;
     15
     16alter table result auto_increment = 1;
     17}}}