Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Tuning Linux for Database performance

Tuning Linux for Database performance

 21 April 11:00 AM - 11:50 AM @ Room 209
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Scalability/Performance
Topics:
MySQL
Other
Optimization

Description

Working primarily with PostgreSQL, I've noticed, that an open source database DBA must be a Linux/UNIX expert. PostgreSQL, MySQL or any NoSQL database challenges an administrator with a lot of operating system tasks in comparison with our colleagues from commercial databases. In my talk I'll try to cover lots of such tasks and will try to compare which impact Linux/Unix tuning can have on both PostgreSQL and MySQL. Linux operating system has lots of tuning options which can change performance of your favorite database installation drastically. For PostgreSQL for example, obviously, most important are storage-related options like vm.dirty*, IO elevators or filesystem mount options, but there are many more of them: CPU scheduler options, NUMA settings, or even power saving policy The goal of this talk is to explain to DBAs and engineers how to use all this settings in order to match hardware configuration and PostgreSQL or any other database workload.

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


Slides