facebook/linkbench — pull request #21 by mdcallag (2013-10-02 19:00:13+00:00)
Title: Make it faster for MySQL

Use 2 connections per client -- read-write, read-only. This avoids the need
to send "commit" for queries. This also lets InnoDB use its fast-path
for read-only transactions (SELECT when in auto-commit mode). And it reduces
the number of statements that are run (fewer COMMIT calls are made).

Add FORCE_INDEX hint on link range query to keep InnoDB from doing IO
to estimate selectivity on the wrong index.

Update indexes for linktable in README.md. These options reduce disk reads
during IO-bound linkbench.

With these changes I almost doubled QPS.