Tuning Linux for Database performance
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.
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.