Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. citus_columnar | 11.1-1

C++ 80

C++ Database Storage Testing 80

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. The governor "powersave" may decide which speed to use within this range. bin/pgbench -c 1 -S -T 60 pgbench starting vacuum.end. hardware limits: 1000 MHz - 4.00 bin/createdb pgbench./bin/pgbench

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. In the recent MySQL 8.0.16 So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. linux-glibc2.12-x86_64/data

Testing 48

Testing Tuning Latency Storage 48

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. SELECT DISTINCT c from sbtest where id between ? order by c.

Best Practices 40

Best Practices Scalability Performance C++ 40

High Scalability

NOVEMBER 25, 2019

To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Which database do you use?

Architecture 52

Architecture Cache Azure Storage 52

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40