1
100%
master: 100%

Ran 24 Aug 2016 10:09AM UTC

Files 30

Run time 1s

Badge

Embed ▾

Committed 24 Aug 2016 09:46AM UTC coverage: 100.0%. Remained the same

Job # 2.1.10

Build Type

push

travis-ci

Committed by

nurse

Commit Message

UPDATE first strategy

To acquire tasks, run UPDATE and SELECT insteadof SELECT and UPDATE.

This adds a new column `owner`, whose content is expected to be CONNECTION_ID(),
 to identify which connection acquires the task.
With this column, RDBCompatBackend#acquire now doesn't get table lock nor use
GET_LOCK(), but adopt mark-and-select method.
It locks only oldest N rows and their gaps during UPDATE.

CONNECTION_ID()
---------------

64bit unsigned integer from the server's internal thread ID counter.
This is unique while the MySQL server running.
http://dev.mysql.com/doc/refman/5.6/en/information-functions.html#function_connection-id
https://bugs.mysql.com/bug.php?id=19806

References
---------------

* http://yuuki.hatenablog.com/entry/go-and-mysql-jobqueue
* https://blog.engineyard.com/2011/5-subtle-ways-youre-using-mysql-as-a-queue-and-why-itll-bite-you
* https://github.com/treasure-data/perfectqueue/pull/15#discussion_r52893022

Run Details

2080 of 2080 relevant lines covered (100.0%)

2.1 hits per line

treasure-data / perfectqueue / 288 / 1
100%
master: 100%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 288.1 (2.1.10)

treasure-data / perfectqueue / 288 / 1 100% master: 100%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 288.1 (2.1.10)

treasure-data / perfectqueue / 288 / 1
100%
master: 100%

README BADGES
x