Session
Detecting MySQL IO problems on Linux at different abstraction layers

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 25th, 4:30 PM
Bishopsgate Suite

Abstract

MySQL running in the LAMP stack is a complex system, luckily there is a lot of good instrumentation for investigation into the three fundamental performance problems: high CPU load, disk bandwidth problems and internal locks contention.

This presentation will discuss how to detect MySQL IO problems on Linux on different abstraction layers:

  • Using high level unix tools
  • Instrumentation inside mysql
  • OS level debug and tracing tools, including linux dynamic tracing framework and more usual tools

Slides

Detecting MySQL IO problems on Linux at different abstraction layers

Download Slides

Speaker

Nickolay Ihalainen

Nickolay Ihalainen

Principal Consultant, Percona

Nickolay joined Percona in December 2010, after working for several years at what is now the most popular cinema site in Russia. During the time he was there, Nickolay and a small team of developers were responsible for scaling the site into one which now serves over a million unique visitors per day. Prior to that, he worked for several other companies, including NetUp, which provides ISP billing and IPTV solutions, and eHouse, the oldest Russian e-commerce company. Nickolay has a great deal of experience in both systems administration and programming. He is an expert in scalability, performance, and system reliability. Nickolay has a degree from Moscow State University.

 

]]> ]]>