High Scalability

JUNE 22, 2018

Each drone is rated with a game mechanic and gets special privileges based on performance (just kidding). using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Ultimately, Netflix did end up paying Comcast in 2014 and, surprise surprise, the throttling stopped.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

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

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. Each option has pros and cons. Example Scenario.

C++ 74

C++ Database Servers Tuning 74

Percona

AUGUST 27, 2018

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter was an early employee at MySQL AB, eventually leading the company’s High-Performance Group. Peter is a co-author of High-Performance MySQL: Optimization, Backups, and Replication , one of the most popular books on MySQL performance.

Open Source 43

Open Source Internet Internet Strategy 43

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

FEBRUARY 22, 2021

And while it doesn't have an explicit deprecation warning, the official documentation for the DBCC command has this gentle nudge: Starting with SQL Server 2014 (12.x) But dbid is unreliable and marginally useful anyway, particularly for cross-database queries; there's much better info in sys.dm_tran_locks. sysprocesses.

Latency 57

Latency Servers Monitoring Systems 57

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. Trace flag 2549 is used to change how DBCC sees the volume layout of the database.

Servers 40

Servers Design Engineering Database 40

SQL Server According to Bob

JUNE 3, 2016

The following chart shows the same 1TB database testing. ‘It Just Runs Faster’ – Out of the box SQL Server 2016 DBCC provides you better performance, scale while shrinking your maintenance window(s.). The DBCC CheckDB demonstration loads a table and demonstrates the performance improvement. SQL Server 2014.

Hardware 40

Hardware Cache Servers Software Engineering 40

Alex Russell

JUNE 22, 2022

Past swings away from OS default browsers have hinged on the superior features , better performance , improved security , and adequate site compatibility that come from switching. Without the ability to differentiate on features, security, performance, and privacy, what's to sell? What are those mechanisms? A slightly different UI ?

Engineering 110

Engineering Traffic Government Google 110

SQL Performance

JULY 1, 2019

Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level. The basic idea there is to choose one row from multiple candidates, and use values from that row to perform the update.

C++ 58

C++ Servers Database Performance 58

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%.

Speed 126

Speed Java AWS Virtualization 126

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. 2014) added support for JSONB data type. B-tree indexes are the most common index type in relational databases. JSONB Patterns & Antipatterns. JSONB Indexes.

Storage 321

Storage Database Efficiency Processing 321

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). 5000 named Percona to their list in 2013, 2014, 2015 and 2016. Register Now.

Architecture 41

Architecture Database Open Source Internet 41

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. Video Inspection Service (VIS): This service takes a mezzanine as the input and performs various inspections. The results are saved to a database so they can be reused.

Processing 229

Processing Media Latency Innovation 229

SQL Performance

MAY 1, 2019

This is reflected in the summary tables included in the Data Loading Performance Guide and the Tiger Team post. As noted in the Data Loading Performance Guide , bulk loading with INSERT.SELECT takes an exclusive X lock on the table, not the bulk update BU lock required for concurrent bulk loads. Introduction. An Exception to the Rule.

Servers 47

Servers Database Testing Performance 47

SQL Performance

FEBRUARY 1, 2022

You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it. Prior to SQL Server 2014, when the log file auto grows, the number of new VLFs added to the end of the log file is determined by the algorithm above, based on the auto-grow size.

Architecture 53

Architecture Servers Virtualization Database 53

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 111

Virtualization AWS Hardware Storage 111

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%.

Speed 52

Speed Java AWS Virtualization 52

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Steve & Tim's Close-up Magic.

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. Should have an excellent way to measure server and query performance. View query performances with visual explain plans. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

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. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

APRIL 8, 2019

The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 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.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. As we moved towards SQL Server 2014, the pace of hardware accelerated. Our design for SQL Server 2012 and SQL Server 2014 is still proven and meets the demands for many of our customers.

Availability 40

Availability Servers Hardware Benchmarking 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. Moreover, the system can have higher performance because it doesn’t need to coordinate: Bailis et al. So now life is easy, right?

Programming 59

Programming Processing Database Systems 59

SQL Performance

JULY 16, 2019

For many years, I explicitly advised people not to run their SQL Server workloads on AMD hardware because of the much lower single-threaded CPU performance and consequently higher SQL Server core license costs. 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

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). This can make it difficult to draw sound performance-tuning conclusions. A final example.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. The internal facility that enables these cases is called FastLoadContext. Fast Load Context.

Cache 64

Cache Testing Servers Code 64

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

SQL Performance

APRIL 23, 2019

SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. When pushdown is successful, aggregation is performed within the Columnstore Scan operator itself, possibly operating directly on compressed data, and taking advantage of SIMD CPU instructions.

Servers 67

Servers Testing Metrics Storage 67

SQL Performance

MAY 7, 2019

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. If you’re reading this and thinking “what is he talking about?” Scheduling.

Servers 40

Servers Azure Metrics Tuning 40

Highly Scalable

MARCH 10, 2015

The goal is to find a set of the most promising candidates who should receive the resource in order to maximize the overall performance of the targeted group of customers. Moreover, gross margin is not the only performance metric that is important for retailers. The resource can be homogenous (i.e. Applications. Applications.

Retail 152

Retail C++ Analytics Metrics 152

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

Database 40

Database Analytics Blockchain Healthcare 40