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

HammerDB

APRIL 27, 2021

As the workflow in the CLI and GUI are the same we will show equivalent commands side by side to help you quickly get up to speed on using the CLI in both interactive and scripted scenarios. One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

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()? This will slow this test a little.) include <sys/time.h>

Speed 126

Speed Java AWS Virtualization 126

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()? This will slow this test a little.) in total.

Speed 52

Speed Java AWS Virtualization 52

Dynatrace

SEPTEMBER 23, 2021

Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. Four types of tools are commonly used to detect software vulnerabilities: Source-code tests that are used in development environments. Source code tests. Run source code tests.

Open Source 250

Open Source Benchmarking Best Practices Network 250

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()? This will slow this test a little.) include <sys/time.h>

Speed 40

Speed Java AWS Virtualization 40

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Why HammerDB was developed. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. ” Usually when benchmark results are surprising it is a major hint that something could be misconfigured and that certainly seems the case here, so what could it be?

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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 124

Performance Hardware Tuning Storage 124

Percona

JANUARY 24, 2023

There will be a considerable gain if we combine this with other sets of great improvements in WAL archiving in PostgreSQL 15, as discussed in previous posts New WAL Archive Module/Library in PostgreSQL 15 and Speed Up of the WAL Archiving in PostgreSQL 15. Such “torn pages” are corruptions from the database point of view.

Database 116

Database Benchmarking Open Source Latency 116

Particular Software

SEPTEMBER 20, 2021

Sometimes developers only care about speed. Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. But that’s just a micro-benchmark and doesn’t tell you the whole story.

Benchmarking 97

Benchmarking Latency Servers Systems 97

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

KeyCDN

AUGUST 29, 2019

Running speed tests with tools like Google PageSpeed Insights , WebPageTest , or KeyCDN’s Website Speed Test are always a good way to help gauge your website’s performance. Why Care About Page Speed? There are a multitude of reasons why you should care about page speed.

Google 103

Google Cache Speed Analytics 103

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

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 104

Database Benchmarking Latency C++ 104

Alex Russell

MARCH 6, 2021

Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. Recall that single-core performance most directly translates into speed on the web. Today, either method returns a similar answer. Tap for a larger version. How bad is it?

Performance 124

Performance Network Cache Metrics 124

Alex Russell

MAY 9, 2022

Improving latency and reducing variance allows teams to test other product hypotheses with less noise. Even junior PM s internalise the notion that product quality is at risk if tests are not built, automated, and tracked. These tests are expensive to run, so they must be chosen well. Protecting the Commons #.

Performance 86

Performance Latency Metrics Engineering 86

SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. We needed to start thinking about how fast can we replicate to a synchronous secondary replica in terms of % of the speed of a standalone workload. Direct seeding of new database replicas. one without a replica).

Availability 40

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

Servers 40

Servers Cache Database Media 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

Smashing Magazine

JANUARY 6, 2020

Testing And Monitoring. You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. You can then mimic the 90th percentile’s experience for testing. Quick Wins.

Performance 145

Performance Cache Network Metrics 145

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. Cloud Platform. Google cloud.

Architecture 52

Architecture Cache Azure Storage 52