Overview
Explore database performance optimization techniques for Red Hat Enterprise Linux in this 52-minute conference talk from the 2013 Red Hat Summit. Discover how to tune RHEL for both bare metal and virtual machine environments using KVM technology. Learn implementation strategies for various tuning settings, analyze performance impact through data and charts, and gain insights on using Linux tools to identify and resolve performance issues. Delve into topics such as I/O profiling, file systems, memory management, huge pages, overclocking, Infiniband, storage profiles, and monitoring tools. Understand the intricacies of C Groups, KVM optimization, and Single Root I/O Virtualization for enhanced database performance in virtualized environments.
Syllabus
Introduction
Scaling
IO
IO Profiling
Elevators
Example
Deadline
File System
Direct IO
IO Iostat
Fibre Channel
Iostat
Memory
Memory Pages
Interleaved Pages
Oracle Pages
Manual Pinning
Page Mapping
Huge Pages
Transparent Huge Pages
Huge Pages vs Pneuma
Flush Caches
LRU Split
Overclocking
Frequency
C States
Infiniband
Storage
Profiles
Performance Mode
Database Tools
C Groups
Dynamic C Groups
KVM
CPU Activity
Max Bandwidth
Single Root IO Virtualization
Bare Metal Monitoring Tools
User Friendly Monitoring Tools
Perf
IO Monitor
Device Monitor
Networks
Taught by
Red Hat