diff options
| author | ASchulz <aschulz@wikimedia.org> | 2012-08-28 17:01:31 -0700 |
|---|---|---|
| committer | Tim Starling <tstarling@wikimedia.org> | 2012-10-16 09:39:58 +1100 |
| commit | b567f3602e8bac048c9dce0f359ef0131d947c28 (patch) | |
| tree | 92cc3dc0cc8986345d57f1a17b4e642e7315891d /maintenance/sqlite | |
| parent | 16f25691ea5382eb333bcd6801e714727e68704e (diff) | |
| download | mediawikicore-b567f3602e8bac048c9dce0f359ef0131d947c28.tar.gz mediawikicore-b567f3602e8bac048c9dce0f359ef0131d947c28.zip | |
[JobQueue] Job queue refactoring and generalizing.
* Added support for different queue types and methods for storing queues.
* Treat each job type as being on its own queue, at least logically.
* Added $wgJobTypeConf to configure queue types for each job type.
* Improved the job DB table so that duplicate job checks actually work
and are faster. Also improved the method for popping rows of the table.
* Disabled duplicate job removal for everything except refreshLinks.
The DELETE statements just add DB overhead and are not useful for cheap
jobs, especially ones with start/end params (which are unlikely to have
exact duplicates).
Change-Id: I49824c7fa855fea4ddcac5c9901ece8c2c0101d0
Diffstat (limited to 'maintenance/sqlite')
| -rw-r--r-- | maintenance/sqlite/archives/patch-job_token.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-job_token.sql b/maintenance/sqlite/archives/patch-job_token.sql new file mode 100644 index 000000000000..4e4d28fde8f2 --- /dev/null +++ b/maintenance/sqlite/archives/patch-job_token.sql @@ -0,0 +1,8 @@ +ALTER TABLE /*_*/job ADD COLUMN job_random integer unsigned NOT NULL default 0; +ALTER TABLE /*_*/job ADD COLUMN job_token varbinary(32) NOT NULL default ''; +ALTER TABLE /*_*/job ADD COLUMN job_sha1 varbinary(32) NOT NULL default ''; +ALTER TABLE /*_*/job ADD COLUMN job_token_timestamp varbinary(14) NULL default NULL; + +CREATE INDEX /*i*/job_sha1 ON /*_*/job (job_sha1); +CREATE INDEX /*i*/job_cmd_token ON /*_*/job (job_cmd,job_token,job_random); + |