To speed up MySQL we will switch its datadir to tmpfs (T96230).
We run MySQL/innodb with the stock settings which are not ideal and are running 5.5.41-0ubuntu0.14.04.1.
The MySQL documentation has a whole chapter about Optimizing InnoDB Disk I/O and found some more at http://www.tocker.ca/2013/11/04/reducing-mysql-durability-for-testing.html
Other things that come to mind:
@ori mentionned libeatmydata , not sure it is worth the added layer.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Krinkle | T96229 Creating MySQL tables for MediaWiki sometimes stalled on I/O for several minutes | |||
| Resolved | Krinkle | T95971 Apache on Jenkins slave takes over 30s to respond (QUnit/AJAX "Test timed out") | |||
| Resolved | Krinkle | T96249 MySQL tuning on CI slaves (tracking) | |||
| Declined | Krinkle | T96250 Tune MySQL innodb settings on CI slaves |
MySQL performance doesn't seem to be an issue at the moment. tmpfs cut it down by an order of magnitude. For simplicity sake, probably best not to deviate too much from defaults settings.