Percona

OCTOBER 12, 2023

The idea behind this is to speed up cluster resources such as garbage collection, reduce image transfer over the network, and accelerate the application launch. Manual flame graphs collection Although the tool is excellent and automatically provides flame graphs, we don’t have much control over tuning the selected profiler.

Code 113

Code Tuning C++ Benchmarking 113

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. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 126

Speed Java AWS Virtualization 126

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 129

Performance Hardware Tuning Storage 129

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

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. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 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. The governor "performance" may decide which speed to use within this range.

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Each partition holds data that falls within a specific range, optimizing data handling and query speed. So, What is MySQL Partitioning? Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 107

Database Benchmarking Latency C++ 107

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

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

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