| Speakers | |
|---|---|
| Steve Hardy | |
| Schedule | |
| Day | Saturday |
| Room | H.2213 |
| Capacity | 100 |
| Start time | 14:00 |
| End time | 14:25 |
| Duration | 00:25 |
| Info | |
| Track | MySQL & friends devroom |
Boosting Enterprise MySQL performance: implementing I/O prefetch for InnoDB
Tests have shown that InnoDB is not using traditional spindle-based I/O subsystems to their maximum potential while doing OLTP workloads with I/O-bound queries; Pages are requested sequentially from the disk system instead of asynchronously, even when using MySQL 5.5's native Aynchronous I/O support. The presentation shows the advantages of implementing a prefetch mechanism which can result in large gains in I/O performance.
For more information of the Innodb prefetch improvement see this mailinglist post: http://lists.mysql.com/internals/38126
Tests have shown that InnoDB is not using traditional spindle-based I/O subsystems to their maximum potential while doing OLTP workloads with I/O-bound queries; Pages are requested sequentially from the disk system instead of asynchronously, even when using MySQL 5.5's native Aynchronous I/O support. The presentation shows the advantages of implementing a prefetch mechanism which can result in large gains in I/O performance.
For more information of the Innodb prefetch improvement see this mailinglist post: http://lists.mysql.com/internals/38126
Concurrent events:
Next (up to 3) talks in the same room (H.2213):
| When | Event | Track |
|---|---|---|
| 14:30-14:55 | Over 20,000QPS, XtraDB performance show | MySQL & friends |
| 15:00-15:25 | Data Recovery for MySQL | MySQL & friends |
| 15:30-15:55 | Taking Backups With XtraBackup | MySQL & friends |
Events that start after this one (within 30 minutes):
| When | Event | Track | Where |
|---|---|---|---|
| 14:30-14:55 | Over 20,000QPS, XtraDB performance show | MySQL & friends | H.2213 |
| 14:30-14:55 | The Web Objects Kitchen | Mono | AW1.120 |
| 14:30-15:00 | Stump the XMPP Experts! Open Q&A | Jabber & XMPP | AW1.121 |
| 14:30-15:00 | In-tab UI | Mozilla | H.1301 |
| 14:40-14:55 | 0MQ: Multithreading magic | Lightning Talks | Ferrer |
| 14:45-15:00 | Tools and Methods for Web Data Extraction | Data Analytics | AW1.124 |
| 14:45-15:00 | EtoileText | World of GNUstep | AW1.117 |
| 14:45-15:00 | CyaSSL | Security & hardware crypto | AW1.105 |
| 14:45-15:30 | Gallium state trackers applied to 2D rendering libraries | Crossdesktop | H.1309 |