article thumbnail

Migrating Critical Traffic At Scale with No Downtime?—?Part 1

The Netflix TechBlog

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. It helps expose memory leaks, deadlocks, caching issues, and other system issues.

Traffic 339
article thumbnail

How to Assess MySQL Performance

HammerDB

Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. Please refer to this tuning guide to tune the system for HammerDB: Open Source Database Tuning Guide on 3rd Generation Intel® Xeon® Scalable Processors Based Platform.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

A use case for sp_prepare / sp_prepexec

SQL Performance

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. You won't be able to check the plan cache for these results, because of the recompile. TheThings. (

Cache 59
article thumbnail

Evaluating the Evaluation: A Benchmarking Checklist

Brendan Gregg

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. sounds like a homework exercise of purely academic value. They are: **Performance mantras**. Don't do it. Do it, but don't do it again. Do it less. Do it later. Do it concurrently.

article thumbnail

One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only

Percona

Tune the random_page_cost parameter. Tune the effective_cache_size parameter. Next is the table definition. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it.

article thumbnail

Evaluating the Evaluation: A Benchmarking Checklist

Brendan Gregg

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. sounds like a homework exercise of purely academic value. They are: **Performance mantras**. Don't do it. Do it, but don't do it again. Do it less. Do it later. Do it concurrently.

article thumbnail

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

In addition, DynamoDB Accelerator (DAX) a fully managed, highly available, in-memory cache further speeds up DynamoDB response times from milliseconds to microseconds and can continue to do so at millions of requests per second. Auto Scaling is on by default for all new tables and indexes.

Internet 128