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: 
50 minutes conference


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.


Ilya Kosmodemiansky's picture

Ilya Kosmodemiansky

CEO and consultant, Data Egret


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