Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Database Administrator
/
Questions
/
Performance Tuning
Database Administrator
Performance Tuning questions
9 questions on Performance Tuning for database administrators, easiest first.
Easy
1
Sizing the InnoDB buffer pool
easy
Medium
3
What effective_cache_size does
medium
Big aggregate uses one CPU
medium
Avoiding double caching in MySQL
medium
Hard
5
More autovacuum workers, no speed-up
hard
Huge pages for a 64 GB buffer pool
hard
Linux OOM killer and PostgreSQL
hard
Write stalls from a small redo log
hard
Finding queries that spill to disk
hard
