HammerDB

JUNE 27, 2022

The wide range of database support gives HammerDB an advantage over other database benchmarking tools that only implement workloads against one or two databases, limiting comparison between database engines and assessing relative performance. When reporting TPROC-C workloads the key metric is known as NOPM or New Orders per Minute.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB retains compatibility with MySQL, offers support for different programming languages, including Python, PHP, Java, and Perl, and works with all major open source storage engines such as MyRocks, Aria, and InnoDB.

Open Source 52

Open Source Servers Storage Scalability 52

The Morning Paper

AUGUST 29, 2019

We group the DBMS design choices and tradeoffs into three broad categories, which result from the need for dealing with (A) external storage; (B) query executors that are spun on demand; and (C) DBMS-as-a-service offerings. Query performance is measured from both warm and cold caches. Key findings. Serverless o?erings

Architecture 76

Architecture Cloud Storage Serverless 76

SQL Server According to Bob

MAY 19, 2019

For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The lock manager has partitions, lock block cache and other structures. Reduce the number of partitions and size of the cache. IO Request Caches. SQLPAL may cache I/O request structures with each thread.

IoT 61

IoT Servers Development Cache 61

Percona

JANUARY 17, 2019

now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. Aurora instance type and comparison.

Cache 48

Cache C++ AWS Airlines 48

The Morning Paper

DECEMBER 8, 2019

The beauty of persistent memory is that we can use memory layouts for persistent data (with some considerations for volatile caches etc. The Twizzler KVS (key-value store) is just 250 lines of C code, and uses one persistent object for the index structure, and a second one for the data. in front of that memory , as we saw last week).

Hardware 56

Hardware Programming Media Storage 56

Percona

MAY 2, 2023

Cons of logical backups As it reads all data, it can be slow and will require disk reads too for databases that are larger than the RAM available for the WT cache—the WT cache pressure increases, which slows down the performance. Especially if going into or out of storage types that may throttle bandwidth/network traffic.

Best Practices 52

Best Practices Database Storage Servers 52