The Netflix TechBlog

JULY 1, 2019

In a previous post , we described how our TV application consists of a C++ SDK installed natively on the device, an updatable JavaScript user interface (UI) layer, and a custom rendering layer known as Gibbon. when we rolled them out globally at the end of 2018. both the full and fallback experiences?—?when

Cache 167

Cache Design Testing Development 167

Percona

SEPTEMBER 13, 2018

2018-09-03.09 > mysql-slowquery.log.2018-09-03.09 2018-09-03.09 2018-09-03.09 system time, 43.80M rss, 141.48M vsz # Current date: Tue Sep 4 15:54:21 2018 # Hostname: aahmed-GL503VD # Files: mysql-slowquery.log.2018-09-03.09 2018-09-03.09 Run pt-query-digest on the log file. . $ user time, 2.5s user time, 2.5s

C++ 60

C++ AWS Open Source Testing 60

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Here's key differences as of August 2018: Type DTrace bpftrace. Attaching 2 probes. ^C

C++ 40

C++ Virtualization Programming Latency 40

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. SELECT DISTINCT c from sbtest where id between ? order by c. SELECT c from sbtest where id=? 10 rows in set (0.02 c_ytd_payment: 10.00

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

MAY 5, 2019

Fortunately the HammerDB TPC-C/OLTP workload intentionally has a great deal of contention between threads and is therefore ideal for testing spin-locks. Copyright (C) 2003-2018 Steve Shaw. In the recent MySQL 8.0.16 So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. linux-glibc2.12-x86_64/data

Testing 49

Testing Tuning Storage Latency 49

Percona

JANUARY 17, 2019

select SQL_CALC_FOUND_ROWS FlightDate, UniqueCarrier, TailNum, FlightNum, Origin, OriginCityName, Dest, DestCityName, DepDelay, ArrDelay FROM ontime_ind o JOIN carriers c on o.carrier = c.carrier_code WHERE (carrier_name like 'United%' or carrier_name like 'Delta%') and ArrDelay > 30 ORDER by DepDelay DESC LIMIT 10G.

Cache 71

Cache C++ AWS Airlines 71

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Hit Ctrl-C to end. Much of my testing was on Linux 4.14.11 and 4.14.12 Linux 4.14.12-virtual

Performance 72

Performance Benchmarking Cache Tuning 72

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Smashing Magazine

SEPTEMBER 6, 2021

As such, a micro-optimization is, again, how you probably need to fine-tune things on a low level to really benefit from it. I would personally recommend using Cloudflare or Fastly because they have been intimately involved in the standardization process and will have the most advanced and well-tuned implementations available.

Network 120

Network Servers Cache Traffic 120

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Hit Ctrl-C to end. Much of my testing was on Linux 4.14.11 and 4.14.12 Linux 4.14.12-virtual

Performance 40

Performance Benchmarking Cache Tuning 40

John McCalpin

JANUARY 22, 2018

Dr. Damon McDougall gave a short presentation on this study at the IXPUG 2018 Fall Conference ( pdf ) — I originally wrote these notes to help organize my thoughts as we were preparing the IXPUG presentation, and later decided that the extra details contained here are interesting enough for me to post it.

Latency 40

Latency Hardware Code Testing 40

John McCalpin

JANUARY 22, 2018

Dr. Damon McDougall gave a short presentation on this study at the IXPUG 2018 Fall Conference ( pdf ) — I originally wrote these notes to help organize my thoughts as we were preparing the IXPUG presentation, and later decided that the extra details contained here are interesting enough for me to post it. An illustrative example: .

Latency 40

Latency Hardware Code Testing 40

Percona

JANUARY 14, 2019

2018-05-31 ? txt command: UPDATE score = score + 1 WHERE (id = 'dbumnpz') AND (created_utc = (SELECT created_utc FROM reddit.rc_id_v WHERE id = 'dbumnpz')) create_time: 2018-12-27 22:22:05 block_numbers.partition_id: [''] block_numbers.number: [857] parts_to_do: 0 is_done: 1 1 rows in set. toDate(min(created_utc))???toDate(max(created_utc))??????count()??

Database 47

Database Analytics Blockchain Healthcare 47