Adrian Cockcroft

MARCH 21, 2020

picture by Adrian When I joined Netflix in 2007 I was managing a team that built the personalized home page for the DVD shipping web site. You need an “abtest” database service. The abtest service should be used across your entire system, for all experiments that touch a customer. There are three ways to populate the database.

Testing 52

Testing Tuning Database Cache 52

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Benchmark before you decide.

Performance 124

Performance Hardware Tuning Storage 124

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. Consistent improvement is the name of the game, and it can still have positive impacts, particularly as users lean on the system more heavily over time. PWA Install Prompts. Content Indexing.

Media 145

Media Games Education Engineering 145

Brendan Gregg

JANUARY 17, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). I just wrote [wss.pl] as a front-end to this feature. seconds (100 milliseconds): #./wss.pl Est(s) RSS(MB) PSS(MB) Ref(MB).

Cache 71

Cache Latency C++ Programming 71

Brendan Gregg

JANUARY 16, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). I just wrote [wss.pl] as a front-end to this feature. seconds (100 milliseconds): #./wss.pl Est(s) RSS(MB) PSS(MB) Ref(MB).

Cache 40

Cache Latency C++ Programming 40

SQL Performance

JULY 16, 2019

From 2007 until 2016, Intel was able to successfully execute their Tick-Tock release strategy, where they would introduce a new processor microarchitecture roughly every two years (a Tock release). This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46