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 123

Performance Hardware Tuning Storage 123

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. There are three ways to populate the database. AB Testing?—?So So You Know What Really Works ??Castillo Castillo San Cristo?bal?,

Testing 52

Testing Tuning Database Cache 52

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

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

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

Alex Russell

APRIL 29, 2021

Since 2007, support for these features has barely improved. An extension to Service Workers that enables browsers to present users with cached content when offline. A-series chips have run circles around other ARM parts for more than half a decade, largely through gobsmacking amounts of L2/L3 cache per core. PWA Install Prompts.

Media 145

Media Games Education Engineering 145

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 130

Internet Internet AWS Performance 130