Uber Engineering

JANUARY 19, 2016

The details and examples of Schemaless triggers, a key feature of the datastore that’s kept Uber Engineering scaling since October 2014.

Engineering 89

Engineering Design Database Architecture 89

SQL Server According to Bob

SEPTEMBER 26, 2016

As we moved towards SQL Server 2014, the pace of hardware accelerated. While we were confident in the design of SQL Server 2012, several customers reported to us performance problems that did not appear to be with disk subsystems, CPU, or networks. Our design needed to scale and be adaptable to the modern hardware on the market.

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Server According to Bob

JULY 12, 2016

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. Trace flag 2549 is used to change how DBCC sees the volume layout of the database. Trace flag 2562 is used to change the batch sizing used by DBCC.

Servers 40

Servers Design Engineering Database 40

SQL Performance

MAY 1, 2019

The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2014 and later , the transition point is 950 rows for this table. The thresholds are not dependent on the Cardinality Estimation model in use or the database compatibility level.

Servers 47

Servers Database Testing Performance 47

SQL Server According to Bob

JUNE 3, 2016

Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases.

Hardware 40

Hardware Cache Servers Software Engineering 40

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

APRIL 8, 2019

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. “SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! A example class of application invariants is database integrity constraints. See Coordination avoidance in database systems for more details. Interactive checks for coordination avoidance Whittaker & Hellerstein et al.,

Programming 59

Programming Processing Database Systems 59

Alex Russell

JUNE 22, 2022

World-class experts in graphics, networking, cryptography, databases, language design, VM implementation, security, usability (particularly usable security), power management, compilers, fonts, high-performance layout, codecs, real-time media, audio and video pipelines, and per- OS specialisation are required.

Engineering 110

Engineering Traffic Government Google 110

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. mid-priced Androids were slightly faster than 2014's iPhone 6.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

APRIL 29, 2021

Delayed three years ( Chrome 40, November 2014 vs. Safari 11.1, A subset ( element.animate() ) has enabled developers to more easily create high-performance visual effects with lower risk of visual stuttering in Chrome and Firefox since 2014. For example, an area where Apple is absolutely killing it is in mobile CPU design.

Media 145

Media Games Education Engineering 145

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Whether you're exploring your local #MongoDB database or working with shards and replica sets, @Studio3T allows you to do all of it. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo.

Servers 95

Servers Tuning Architecture Processing 95

The Netflix TechBlog

JANUARY 10, 2024

From Reloaded to Cosmos Reloaded Starting in 2014, we developed and operated the video processing pipeline on our third-generation platform Reloaded. When Reloaded was designed, we focused on a single use case: converting high-quality media files (also known as mezzanines) received from studios into compressed assets for Netflix streaming.

Processing 229

Processing Media Latency Innovation 229

Highly Scalable

MARCH 10, 2015

Although these problems are very different, we are trying to establish a common framework that helps to design optimization and data mining tasks required for solutions. The design of the model heavily depends on the problem. This model helps to design targeted usage expansion campaigns. Propensity to category expansion.

Retail 152

Retail C++ Analytics Metrics 152

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers.

Programming 98

Programming Code Design Benchmarking 98