72
100%
master: 100%

Ran 12 Feb 2016 11:29PM UTC

Jobs 5

Files 45

Run time 11min

Badge

Embed ▾

pending completion

Build # 72

Build Type

push

travis-ci

Committed by

nurse

Commit Message

Use CONNECTION_ID() for finer grained locking

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

This adds a new column `owner` 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

Run Details

2639 of 2859 relevant lines covered (92.31%)

96.73 hits per line

Jobs

ID	Job ID	Ran	Coverage
1	72.1 (1.9.3)	12 Feb 2016 11:29PM UTC	92.27	Travis Job 72.1
2	72.2 (2.0.0)	12 Feb 2016 11:29PM UTC	92.3	Travis Job 72.2
3	72.3 (2.1.6)	12 Feb 2016 11:29PM UTC	92.3	Travis Job 72.3
4	72.4 (2.2.2)	12 Feb 2016 11:30PM UTC	92.3	Travis Job 72.4
5	72.5 (ruby-head)	12 Feb 2016 11:30PM UTC	92.3	Travis Job 72.5

Source Files on build 72

Detailed source file information is not available for this build.

treasure-data / perfectqueue / 72
100%
master: 100%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 72

treasure-data / perfectqueue / 72 100% master: 100%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 72

treasure-data / perfectqueue / 72
100%
master: 100%

README BADGES
x