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. Objective C. SolarisUnix.

Open Source 244

Open Source Tuning C++ Database 244

Brendan Gregg

SEPTEMBER 5, 2017

Hit Ctrl-C to end. ^C C operation = 'read' usecs : count distribution 0 -> 1 : 0 | | 2 -> 3 : 0 | | 4 -> 7 : 4479 | *| 8 -> 15 : 1028 | | 16 -> 31 : 14 | | 32 -> 63 : 1 | | [.]. If that seems wildly unacceptable, note that you can tune overcommit on Linux to not do this, and behave more like Solaris (see sysctl vm.overcommit_memory).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017 and have shared the full story here. ## 1. The other colors are yellow for C++, and red for other user-level code.) The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes. A microservice team asked me for help with a mysterious issue.

Cache 145

Cache Cloud Java Tuning 145

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c. 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

Percona

JANUARY 17, 2019

Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. sec) mysql> select count(*) from ontime where flightdate > '2017-01-01'; + -+ | count(*) | + -+ | 5660651 | + -+ 1 row in set (2 min 48.81 select avg(DepDelay/ArrDelay+1) from ontime.

Cache 47

Cache C++ AWS Airlines 47

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at Kernel Recipes in 2017; it is an old story that's worth resharing here. The other colors are yellow for C++, and red for other user-level code.) The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes. A microservice team asked me for help with a mysterious issue.

Cache 52

Cache Cloud Java Tuning 52

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c 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 40

Speed Java AWS Virtualization 40