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

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. availability_databases_cluster AS c ON s. group_id = c. If you have instances running older versions like SQL Server 2008 R2 (I found one!), writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

SQL Performance

OCTOBER 29, 2019

Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures. CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. Example Scenario. AccountOpenedDate , COUNT ( ct.

C++ 74

C++ Database Servers Tuning 74

Sutter's Mill

JULY 12, 2010

From the article: … Active objects dramatically improve our ability to reason about our thread’s code and operation by giving us higher-level abstractions and idioms that raise the semantic level of our program and let us express our intent more directly. NET, Java, and C/Pthreads. Feb 2008). I hope you enjoy it.

C++ 40

C++ Java Programming Website 40

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? This command compares the code bytes in the crash dump (some of them are saved in the crash dump, just in case) against those on disk. In this case it said that 9322 bytes in the code in the crash dump were wrong.

Programming 79

Programming Hardware Cache Code 79

Sutter's Mill

AUGUST 27, 2010

5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007). 6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 13 The Many Faces of Deadlock (Aug 2008).

Website 40

Website Scalability Code Design 40

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 Hit Ctrl-C to end. ^C

Virtualization 76

Virtualization AWS Engineering Hardware 76