Event language
UI language
<p>Let's be honest, database performance often feels like dark magic. One day your queries fly, the next they crawl, and you're left wondering what changed. The common pieces of advice are usually "tune your queries", "tune the parameters", but what does that really mean? This talk strips away the mystery of high-performance database tuning, focusing on practical, open-source techniques applicable to PostgreSQL, MySQL, and their variants.</p><p>We’ll explore how the core concepts of indexing, memory management, and I/O interact to determine your system’s throughput. We will demystify common optimization myths and show how effective scaling is about understanding the database engine's relationship with the underlying operating system and hardware. This isn't just theory: we'll dive into real-world tuning parameters (like shared_buffers, innodb_buffer_pool_size, and kernel settings) and provide clear, actionable rules for when software tuning hits its limit and when you must invest in faster hardware, and critically, which hardware matters most (spoiler: it's not always the CPU or Memory).</p><p>If you want to move beyond guessing and start scaling with precision, this session will give you the practical knowledge to do it. No vendor promises, no marketing fluff, just the stuff that actually moves the needle when your users are waiting!</p>
