Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. 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.

Speed 126

Speed Java AWS Virtualization 126

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.

Database 40

Database Analytics Blockchain Healthcare 40

Percona

JANUARY 17, 2019

I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. sec) mysql> explain select count(*) from ontime where flightdate > '2017-01-01'G 1.

Cache 47

Cache C++ AWS Airlines 47

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. 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

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT(). all_columns AS c WHERE EXISTS. (

C++ 59

C++ Servers Testing Database 59