Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 128

Performance Hardware Tuning Storage 128

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Such solutions also incorporate features like disaster recovery and built-in safeguards that ensure data integrity across diverse operating systems.

Cloud 130

Cloud Virtualization Storage Efficiency 130

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. HammerDB has graphical and command line interfaces for the Windows and Linux operating systems. Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute. Basic Benchmarking Concepts. Database benchmarking in parallel.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

JULY 1, 2023

These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc. There are also cases where although the workload and operational needs seem to best fit to one solution, there are other limiting factors that may be blockers (or at least need special handling).

AWS 52

AWS Database Serverless Storage 52

Adrian Cockcroft

JANUARY 20, 2023

on Myths and Legends of High Performance Computing  — it’s a somewhat light-hearted look at some of the same issues by the leader of the team that built the Fugaku system I mention below. HPCG is led by Japan’s RIKEN Fugaku system at 16 petaflops, which is 3% of it’s peak capacity. petaflops, which is 0.8% of peak capacity.

Architecture 52

Architecture Latency Benchmarking AWS 52

HammerDB

NOVEMBER 30, 2018

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. Virtual Users within HammerDB are operating system threads. Virtual Users.

Architecture 40

Architecture Virtualization Open Source C++ 40

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench.

Benchmarking 48

Benchmarking Database Operating System Architecture 48

SQL Server According to Bob

JANUARY 11, 2020

Subsystem / Path The ​​ I/O subsystem or path ​​ includes ​​ those ​​ components ​​ that are ​​ used to support an I/O operation.

Servers 40

Servers Cache Database Media 40

ScaleOut Software

MAY 15, 2014

In addition to looking at performance differences, we also want to compare ScaleOut StateServer (SOSS) to AppFabric on qualitative measures, such as features, ease of installation, and management. Testing Scale-Up Performance. So our comments will be confined to what testing we felt was valuable and how well SOSS performed.

Cache 40

Cache Servers Network Design 40

Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. PostgreSQL is an open source object-relational database system with over 30 years of active development. Let’s take a look at core functionality of these two relational database management systems.

Open Source 244

Open Source Tuning C++ Database 244

High Scalability

NOVEMBER 25, 2019

For e.g., if accessing file system over WebDAV or FTP has performance issues, and it will take 4 hours to fix, then for those 4 hours, you can just kill FTP/WebDAV at kong/firewall and ask customers to use web UI or other mechanisms to work. Who performs what roles? What operating systems do you use?

Architecture 52

Architecture Cache Azure Storage 52