So, I think that the SQL based queue backends should probably use
function+unique as their PK, and then implement ON DUPLICATE KEY
UPDATE when adding jobs to the queue.

Ok, I am working on this.

In Drizzle, I assume the 255 byte key limit is still around from MySQL? I need the primary key in the gearman queue to be made up of these fields:

               "unique_key VARCHAR(%d) PRIMARY KEY,"
               "function_name VARCHAR(255),"


Where %d is GEARMAN_UNIQUE_SIZE. the default there is 64. So, that goes way over the 255 byte limit no?

Brian.

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to