MySQL and SSD: Usage Patterns

Vadim Tkachenko (Percona Inc)
Average rating: ****.
(4.00, 5 ratings)

f you’re considering using solid-state storage for your MySQL server, you should attend this talk. The obvious usage of SSD is just to put all data on it, but that may not be the most optimal solution. It might be better to have a mixture of SSDs and normal disks. Or you might want to use separate SSDs for different tasks, so they don’t get a mixed workload. There are many possibilities. I will show various usage patterns, like: using SSD as a cache, using SSD for temporary table, and separating the transaction logs and doublewrite buffer. Benchmarks included. Get the most from your SSDs for MySQL!

Photo of Vadim Tkachenko

Vadim Tkachenko

Percona Inc

Vadim Tkachenko is the CTO and co-founder of Percona Inc. He is an expert in application scaling and performance tuning, and co-authored the O’Reilly book High Performance MySQL, 2nd Edition.

Vadim has over five years of experience in benchmarking and profiling MySQL, having worked inside MySQL’s High Performance group. He now continues his benchmarks independently on mysqlperformanceblog.com

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts