MySQL and SSD: usage and tuning

I this talk I will cover Solid State Drives internals and how they affect database performance.
IO level benchmarks for SATA (Intel 320 SSD) and PCI-e (FusionIO, Virident) cards
to show absolute performance and give an idea on performance per $.
And finally how you can use MySQL and Percona Server with SSD,
what tuning parameters are most important and what performance may expect in real
production usage.

Track: 
Utilizing Hardware
Experience level: 
Beginner

Schedule info

Time slot: 
2 October 13:30 - 14:20
Room: 
Tribeca

Schedule Info

2 October 13:30 - 14:20 @
Tribeca

Speakers

Vadim Tkachenko's picture
Vadim Tkachenko
CTO, co-founder, Percona Inc

Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background.

At Percona Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases. He focuses on real-world performance and functionality scenarios that are often missed by standard benchmarks. Vadim actively consults for many Alexa Top 1000 web properties, but has an increasing focus on hardware appliances and storage engines. He is leading Percona's emerging expertise in solid-state storage with his launch of the SSD Performance Blog.

Slides

Download Slides Now


Sponsored By