2014, Database, Servers and Storage - Technology Performance Pulse

MariaDB vs MySQL: Key Differences and Use Cases

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source

Open Source Servers Storage Scalability

Finding Distinct Values Quickly

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. Test Environment. BountyAmount.

Servers

Servers Tuning Database Efficiency

Stuff The Internet Says On Scalability For June 22nd, 2018

High Scalability

JUNE 22, 2018

Charlie Demerjian : what does Intel have planned for their server roadmap? For the same reason the 14/10nm messaging is causing consternation among investors, but the server side is in much worse shape. using them to respond to storage events on s3 or database events or auth events is super easy and powerful.

Internet

Internet Internet Scalability Artificial Intelligence

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL Performance

MAY 16, 2019

Without this guarantee, SQL Server might add index rows that are not sorted correctly, which would not be good. For INSERT.SELECT , SQL Server makes its own determination whether to ensure rows are presented to the Clustered Index Insert operator in key order or not. DMLRequestSort Conditions.

Cache

Cache Servers Testing Storage

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

JUNE 3, 2016

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. The following chart shows the same 1TB database testing. SQL Server. SQL Server 2014.

Hardware

Hardware Cache Servers Software Engineering

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

NOVEMBER 29, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. This was extended to instance storage devices for the x1.32xlarge in 2016.

Virtualization

Virtualization AWS Hardware Storage

Minimal Logging with INSERT…SELECT into Heap Tables

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers

Servers Database Testing Performance

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability

Availability Servers Hardware Benchmarking

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure

Azure Virtualization Storage Benchmarking

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

NOVEMBER 28, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. This was extended to instance storage devices for the x1.32xlarge in 2016.

Virtualization

Virtualization AWS Hardware Storage

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache

Cache Testing Servers Code

Grouped Aggregate Pushdown

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Columnstore storage. Introduction.

Servers

Servers Testing Metrics Storage

Real-Real-World Programming with ChatGPT

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

Programming Code Design Benchmarking

The Performance Inequality Gap, 2021

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. mid-priced Androids were slightly faster than 2014's iPhone 6. The Moto G4 , for example. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance

Performance Network Cache Metrics

Should You Use ClickHouse as a Main Operational Database?

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. Processed 4.15

Database

Database Analytics Blockchain Healthcare

Technology Performance Pulse

MariaDB vs MySQL: Key Differences and Use Cases

Finding Distinct Values Quickly

Trending Sources

Stuff The Internet Says On Scalability For June 22nd, 2018

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

AWS EC2 Virtualization 2017: Introducing Nitro

Minimal Logging with INSERT…SELECT into Heap Tables

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

AMD EPYC Processors in Azure Virtual Machines

AWS EC2 Virtualization 2017: Introducing Nitro

Minimal Logging with INSERT…SELECT and Fast Load Context

Grouped Aggregate Pushdown

Real-Real-World Programming with ChatGPT

The Performance Inequality Gap, 2021

Should You Use ClickHouse as a Main Operational Database?

Stay Connected