Overview
This course teaches learners how to optimize database performance on Red Hat Enterprise Linux for both bare metal and virtual machines using Kernel-based Virtual Machine (KVM) technology. The course covers implementing tuning settings, utilizing Linux tools to identify performance issues, and provides data and charts illustrating the impact of tuning recommendations. The teaching method includes a session led by an expert in the field. The intended audience for this course includes IT professionals, system administrators, and individuals interested in enhancing database performance on Red Hat Enterprise Linux.
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