n0derunner

SEPTEMBER 17, 2018

Creating a HCI benchmark to simulate multi-tennent workloads. It is very common to have large resource-hungry databases separated across nodes using anti-affinity rules. It is the shared storage that often causes performance issues for data bases which are otherwise separated across nodes. Time based benchmark actions.

Performance Testing 40

Performance Testing Benchmarking Testing Performance 40

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

n0derunner

OCTOBER 1, 2019

For our purposes we are going to use Postgres DB and the built-in benchmarking tool PGbench. This time though the metric is Database transactions per second not IOPS or Storage throughput. I found that one combination gave better performance at low loads, but the other combination generated better performance under higher loads.

Performance 75

Performance Benchmarking Storage Database 75

Brendan Gregg

FEBRUARY 9, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 75

Performance Benchmarking Cache Tuning 75

n0derunner

OCTOBER 4, 2019

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI.

Benchmarking 75

Benchmarking Database Servers Performance Testing 75

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

n0derunner

JULY 23, 2019

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. The aim of the experiment was to see how data-locality might affect a running database workload, not to generate the maximum TPS.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Brendan Gregg

FEBRUARY 8, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 40

Performance Benchmarking Cache Tuning 40

Apica

MAY 10, 2019

The spread of where consumers want to consume content, at home, at the office, at the gym, on a plane, at any time where there is connectivity, puts significant pressure on the network and performance monitoring teams for streaming brands. Consumers will leave you for slow or intermittent performance because there are other content options.

Testing 40

Testing Performance Social Media Wireless 40

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

Smashing Magazine

JANUARY 6, 2020

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 145

Performance Cache Network Metrics 145

Particular Software

DECEMBER 18, 2018

Getting up and running was simple and we don't have to worry about managing and maintaining queue databases anymore. When we attempted to do performance testing of the new transport to compare it to the legacy transport, we discovered that it is essentially impossible to run benchmarks on the Standard Tier.

Transportation 49

Transportation Azure Benchmarking Availability 49

High Scalability

NOVEMBER 25, 2019

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. Automate schema management for some remaining databases. Who performs what roles? Which database do you use? Cloud Platform. Google cloud. Hosted Data Centers. Object Stores.

Architecture 52

Architecture Cache Azure Storage 52

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

High Scalability

DECEMBER 3, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well.

Best Practices 21

Best Practices Performance Systems Processing 21