Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. So Which Is Best?

Open Source 244

Open Source Tuning C++ Database 244

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). Outside of EC2, many other providers are deploying on KVM.

Virtualization 76

Virtualization AWS Engineering Hardware 76

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. Query Store 2017 to the Rescue.

Tuning 115

Tuning Servers Monitoring Hardware 115

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. html [60s checklist]: /Articles/Netflix_Linux_Perf_Analysis_60s.pdf [re:Invent talk]: [link] [recommendation]: [link] [Nitro]: /blog/2017-11-29/aws-ec2-virtualization-2017.html

Speed 126

Speed Java AWS Virtualization 126

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Finding a small number of distinct values might seem like quite a specific requirement, but I have come across it fairly frequently over the years, usually as part of tuning a larger query. Test Environment. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. This helps identify potential issues and fine-tune the partitioning strategy.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 47

Cache C++ AWS Airlines 47