Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server. Are these results good enough?

Tuning 135

Tuning Cache Servers Benchmarking 135

Dynatrace

SEPTEMBER 25, 2019

Dynatrace Extension: database performance as experienced by the SAP ABAP server. It provides the bottom line of Citrix virtual application and desktop (formerly XenApp and XenDesktop) infrastructure performance. Citrix platform performance—optimize your Citrix landscape with insights into user load and screen latency per server.

Latency 116

Latency Performance Virtualization Infrastructure 116

Scalegrid

FEBRUARY 8, 2024

At its core, a distributed storage system comprises three main components: a controller for managing the system’s operations, an internal datastore where information is held, and databases geared towards ensuring scalability, partitioning capabilities, and high availability for all types of data.

Storage 130

Storage Systems Big Data Azure 130

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. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Also, in the case of multi-Primary, the writes will be distributed by transaction. The POC Why this POC?

Traffic 122

Traffic Scalability Database Servers 122

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So lets take an Ubuntu system with Platinum 8280 CPUs with the following Ubuntu OS, reboot and check the CPU configuration before running any tests. uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. This will slow this test a little.) These can be invisible to top(8).

Speed 52

Speed Java AWS Virtualization 52

Enprowess

SEPTEMBER 7, 2021

Unit testing: Node.js has a unit testing framework called Jasmine, which allows unit testing of code during development. with its low latency I/O operations, gives the benefit of ‘No buffering’ to developers. The performance of React improves because of the Virtual DOM algorithm. Easy UI test cases.

Open Source 52

Open Source Virtualization Programming Servers 52

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. The CFQ works well for many general use cases but lacks latency guarantees.

Best Practices 52

Best Practices Design Tuning Database 52

HammerDB

DECEMBER 5, 2020

A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. This was both expensive and time consuming to configure. I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. This will slow this test a little.) These can be invisible to top(8).

Speed 40

Speed Java AWS Virtualization 40

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Alex Russell

MAY 9, 2022

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Consistent performance matters just as much as low average latency.

Performance 86

Performance Latency Metrics Engineering 86

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. HammerDB difference from Sysbench. 10 rows in set (0.02

Best Practices 40

Best Practices Scalability Performance C++ 40

Dotcom-Montior

DECEMBER 8, 2021

In a different article, we talked about chaos engineering and how SRE teams proactively seek out and test for failures to prevent the worst from happening. The IT service catalog is typically a database or resource that an organization creates to provide users with information on their operational services and offerings.

Social Media 90

Social Media Monitoring Latency DevOps 90

Brendan Gregg

JANUARY 17, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Test in a lab environment for your kernel versions, and consider this experimental: use at your on risk.** Consider these overheads.

Cache 71

Cache Latency C++ Programming 71

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? The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Brendan Gregg

JANUARY 16, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Test in a lab environment for your kernel versions, and consider this experimental: use at your on risk.** Consider these overheads.

Cache 40

Cache Latency C++ Programming 40

O'Reilly Software

MARCH 7, 2018

In addition to that, software is increasingly dependent on other software to provide its functionality, be it WebServices, HTTP APIs, databases, or even external devices such as sensors. Sadly, it is very common to write logic that deeply couples the notion of IO with the processing of that IO. The need for flow control.

Transportation 72

Transportation Java Programming Architecture 72

Alex Russell

APRIL 29, 2021

Thanks to the Web Platform Tests project and wpt.fyi , we have the makings of an answer for the first: Tests that fail only in a given browser. wpt.fyi 's new Compat 2021 dashboard narrows this full range of tests to a subset chosen to represent the most painful compatibility bugs : Stable-channel Compat 2021 results over time.

Media 145

Media Games Education Engineering 145

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