Percona

APRIL 14, 2023

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Consolidate workloads: In the past, you might have wanted to split out additional replicas or cluster nodes to process specific types of workloads, such as those related to reporting. If needed, you can spin up a backup.

Database 83

Database Serverless Tuning Cloud 83

Percona

JUNE 4, 2023

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. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. Notice the lack of a check at 1250 due to the code quirk I mentioned. Let’s look at some examples using a fresh database. Well, almost. The sqlmin!lck_lockInternal

Database 98

Database Storage Testing Servers 98

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The Sort only has 19 rows to process, so it consumes only 1ms or so.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. If you have instances running older versions like SQL Server 2008 R2 (I found one!),

C++ 58

C++ Database Servers Storage 58

Alex Russell

AUGUST 30, 2021

Anyone who cares to download and fork the code can do so. From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." This process can be messy and slow, but it never creates a political blockage for developing new capabilities for the web.

Engineering 98

Engineering Open Source Website Operating System 98