Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Linux IO internals for database administrators

Linux IO internals for database administrators

 27 April - 12:50 PM - 1:40 PM @ Ballroom G
Experience level: 
Advanced
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
PostgreSQL
Optimization

Description

Input-output performance problems are on every day agenda for DBAs since the databases exist. Volume of data grows rapidly and you need to get your data fast from the disk and moreover - fast to the disk. For most databases there is a more or less easy to find checklist of recommended Linux settings to maximize IO throughput. In most cases that checklist is good enough. But it is always better to understand how it works, especially if you run into some corner-cases. This talk is about how IO in Linux works, how database pages travel from disk level to database own shared memory and back and what kind of mechanisms exist to control this. We will discuss memory structures, swap and page-out daemons, filesystems, schedullers and IO methods. Some fundamental differences in IO approaches between PostgreSQL, Oracle and MySQL will be covered.

Speakers

Ilya Kosmodemiansky's picture

Ilya Kosmodemiansky

CEO and consultant, Data Egret

Biography:

llya is a co-founder and Consultant at Data Egret. His previous experience encompasses such commercial databases as Oracle and DB2. Currently, Ilya works primarily with PostgreSQL with a focus on its performance and effective use in production. He sees the mission of PostgreSQL in substituting the commercial databases in high-performance mission-critical applications.

Share this talk