The Netflix TechBlog

OCTOBER 19, 2020

Our engineering teams tuned their services for performance after factoring in increased resource utilization due to tracing. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Adrian Cockcroft

MARCH 21, 2020

You need an “abtest” database service. In a small system this may be a table in a central relational database, but it’s best setup as a NoSQL data source using something like Amazon DynamoDB or Apache Cassandra, with a caching client library or at large scale a microservice data access layer.

Testing 52

Testing Tuning Database Cache 52

O'Reilly

MAY 25, 2021

Note that the dataset on which GPT-3 trained terminated around October 2019. It is likely that entire companies will be in the business of identifying these nuances and selling them as “fingerprint databases” for identifying fake news articles. And the final paragraph of section 3.9.4 So GPT-3 doesn’t know about COVID19, for example.

Social Media 138

Social Media Media Internet Internet 138

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. I tested my solutions in SQL Server 2019 Enterprise edition. The downsides are that you need to use Enterprise edition, use at minimum SQL Server 2019 where batch mode on rowstore was introduced, and the solution involves using an undocumented hint.

C++ 114

C++ Servers Testing Processing 114

Apica

MAY 10, 2019

2019 will go down as the year when giants collided over who is streaming the right content to win the growing market demand and dollars. These companies should involve multiple organizations during Apica’s load testing to observe and pinpoint opportunities for performance tuning. million Netflix users as of Q3 2018.

Testing 40

Testing Performance Social Media Wireless 40

SQL Performance

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. I tested my solutions in SQL Server 2019 Enterprise edition. The downsides are that you need to use Enterprise edition, use at minimum SQL Server 2019 where batch mode on rowstore was introduced, and the solution involves using an undocumented hint.

C++ 61

C++ Servers Testing Processing 61

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. PostgreSQL popularity is skyrocketing in the enterprise space.

Strategy 182

Strategy Cloud Java Open Source 182

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 197

Database Traffic Transportation Open Source 197

The Netflix TechBlog

MAY 14, 2021

Once you finally find useful identifiers, you may begin writing SQL queries against your production database to find out what went wrong. Even though Cosmos was developed for asynchronous media processing, we worked with them to expand to generic file processing and tune their workflow platform for our near real-time use case.

Traffic 160

Traffic Latency Java Google 160

Dynatrace

JULY 3, 2019

For instance, if a problem is caused by incorrect data returned by the server, Dynatrace full-stack insights can be used to follow the problem through the entire stack down to the single line of code or database statement. Usability analytics with rage clicks will be publicly available towards the end of June, 2019. Want to try it out?

Analytics 121

Analytics Tuning Mobile Monitoring 121

Dynatrace

JUNE 6, 2019

In 2019, Containerd became the 5th project to reach CNCF’s highest maturity level, graduation. These capabilities not only ensure full-stack visibility into containers (down to the code level and database), they’re also key for automated discovery of your container and service-to-service dependencies. So stay tuned.

Monitoring 165

Monitoring Tuning Metrics Analytics 165

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. In 2019 myself and others tested kvm-clock and found it was only about 20% slower than tsc. What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 126

Speed Java AWS Virtualization 126

Scalegrid

MARCH 4, 2019

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Guess again.

Database 255

Database Metrics Systems Strategy 255

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This next example query uses the same database and index as before. Compatibility level 150 is used exclusively.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

AUGUST 15, 2019

Updated August 15th, 2019 for 0.9.6. Connecting to SQL Server 2012 or better, or Azure SQL Database. New in 0.9.6 – August 15th, 2019. SentryOne Plan Explorer / Query Tuning forum. After some discussion, we brought the concept to the leadership team, and set a plan in motion. or newer ( July announcement post ).NET

Azure 50

Azure Servers Tuning Operating System 50

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. In 2019 myself and others tested kvm-clock and found it was only about 20% slower than tsc. What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 40

O'Reilly

JULY 25, 2023

For instance, if I’m reading a paper from 2019, a popular song from that year could start playing. Similarly, it taught me that “Background scripts are ideal for handling long-term or ongoing tasks, managing state, maintaining databases, and communicating with remote servers.

Programming 98

Programming Code Design Benchmarking 98

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. rc3-custom #1 SMP Mon Aug 12 14:07:33 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux Welcome to Ubuntu 19.04 (GNU/Linux 5.3.0-rc3-custom uname -a Linux ubuntu19 5.3.0-rc3-custom rc3-custom x86_64).

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244