Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It’s low because certain machines and operating systems do not support higher values.

Tuning 55

Tuning Database Performance Benchmarking 55

Brendan Gregg

JUNE 30, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 54

Benchmarking Latency Cache Network 54

The Morning Paper

MARCH 10, 2020

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook , Cao et al., Or in the case of key-value stores, what you benchmark. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

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 103

Database Benchmarking Latency C++ 103

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? To be fair, that is also true with PostgreSQL; it hasn’t been tuned either, and it, too, can also perform much better.

Tuning 134

Tuning Cache Servers Benchmarking 134

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 over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks . uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Dynatrace

OCTOBER 2, 2023

However, the distributed system of a microservices architecture comes with its own cost: increased application complexity and convoluted testing. In fact, it can be difficult to make code changes that won’t disrupt the entire system. Use SLAs, SLOs, and SLIs as performance benchmarks for newly migrated microservices.

Architecture 231

Architecture Artificial Intelligence Cloud Open Source 231

The Morning Paper

JUNE 27, 2019

Machine learning systems are stuck in a rut Barham & Isard, HotOS’19. In this paper we argue that systems for numerical computing are stuck in a local basin of performance and programmability. That said, after around 17 minutes Tensor Comprehensions does find a solution that outperforms a hand-tuned CUDA solution.

Systems 87

Systems Tuning Programming Innovation 87

Brendan Gregg

JUNE 29, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 40

Benchmarking Latency Cache Network 40

Dynatrace

FEBRUARY 10, 2022

Compared to intrusion detection systems (IDS/IPS), WAFs are focused on the application traffic. For most enterprises, using a RASP solution would mean running multiple agents on their production systems, potentially creating risk due to incompatibilities. WAFs protect the network perimeter and monitor, filter, or block HTTP traffic.

Traffic 233

Traffic Benchmarking Innovation Java 233

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. Operating System: Ubuntu 22.04 Operating System: Ubuntu 22.04

Performance 54

Performance Benchmarking Cache Storage 54

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

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. PostgreSQL.

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

MARCH 25, 2022

Like most IT professionals, Harikrishnan and the Parker team’s cybersecurity engineer Tom Hood have multiple requirements to manage, from implementing digital transformation and ensuring operational efficiency to securing IT systems. Unplanned system outages are costly, in both time and resources. Where is a user coming from?

Benchmarking 171

Benchmarking Efficiency DevOps Tuning 171

Percona

MARCH 23, 2023

Operating system Linux is the most common operating system for high-performance MySQL servers. Benchmark before you decide. If you see concurrency issues, you can tune this variable. innodb_numa_interleave (Static) – For ‘NUMA enabled systems’ with large amounts of memory (i.e.,>

Performance 124

Performance Hardware Tuning Storage 124

The Morning Paper

NOVEMBER 3, 2019

Perhaps the most interesting lesson/reminder is this: it takes a lot of effort to tune a Linux kernel. Google’s data center kernel is carefully performance tuned for their workloads. A micro-benchmark suite, LEBench was then built around tee system calls responsible for most of the time spent in the kernel.

Performance 108

Performance Benchmarking Tuning Hardware 108

HammerDB

OCTOBER 18, 2018

To get started with Oracle metrics use the previous option for CPU metrics that now shows the service name and system user and password. It is also clear that most significant wait event is “log file sync” and therefore tuning should focus on the redo log performance.

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

OCTOBER 12, 2023

An example of a flame graph can be found below: Each box is a function in the stack, and wider boxes mean more time the system was busy on CPU on these functions. Kubernetes limitations In Linux, by default, performance system events can’t be collected by unprivileged users.

Code 108

Code Tuning C++ Benchmarking 108

Adrian Cockcroft

JUNE 21, 2022

Photo by Adrian I spent six years at Cambridge Consultants, building some interesting systems, managing our Sun workstations and learning a lot, but by then Sun had opened a sales office across the street, and I wanted to find out what they were going to release next, before everyone else.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Scalegrid

MARCH 22, 2024

Register now for free and experience the seamless operation of your databases across multi-cloud and hybrid-cloud systems. You want to avoid the chaos of “shadow IT,” where stuff gets done outside your approved systems, and ensure that your security game is tight. Elevate your cloud strategy today with ScaleGrid!

Strategy 130

Strategy Cloud Government Innovation 130

High Scalability

AUGUST 24, 2021

If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! has hours of system design content. They also do live system design discussions every week. InterviewCamp.io

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

Wynter is looking for system administrators, engineers, and developers to join its research panel. If you have experience in hosting and with the WordPress stack, have worked with Ubuntu or Debian-based systems, and cutting-edge technologies, such Ansible and LXC, you should definitely check us out and apply here ! Who's Hiring?

Education 100

Education DevOps Infrastructure Benchmarking 100

The Netflix TechBlog

OCTOBER 19, 2020

which is difficult when troubleshooting distributed systems. Troubleshooting a session in Edgar When we started building Edgar four years ago, there were very few open-source distributed tracing systems that satisfied our needs. Investigating a video streaming failure consists of inspecting all aspects of a member account.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

NOVEMBER 3, 2023

Have you tuned your environment? This means they can ensure that every possible scenario is tested, from data integrity checks to performance benchmarks. System downtime Incorrect migration can lead to prolonged system downtimes, affecting your business operations. What’s your plan to mitigate or minimize downtime?

Database 81

Database Open Source Benchmarking Strategy 81

Scalegrid

OCTOBER 24, 2019

AWS High Performance XLarge (see system details below). MySQL Performance Benchmark Configuration. For some of the tests on the ScaleGrid deployment, MySQL configuration binlog_group_commit_sync_delay is tuned so that the slave replication lag does not go beyond 30s. MySQL on AWS Performance Test. Amazon RDS. Instance Type.

AWS 183

AWS Latency Performance Benchmarking 183

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. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

The Morning Paper

NOVEMBER 28, 2019

A TLA+ inductive invariant is a state formula expressing what must be true about the system state after every algorithm step. Some of these examples have been hand-tuned to make them efficient for TLC to check, no such tuning is done for APALACHE. 4 seconds on this same benchmark). But when TLC starts to struggle (e.g.,

Tuning 106

Tuning Benchmarking Efficiency Systems 106

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . SQL> alter system flush buffer_cache; System altered. These parameters can be set as follows: SQL> alter system set commit_logging='BATCH' scope=spfile; System altered. commit_logging.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Microbenchmark os::javaTimeMillis() on both systems. Running this on the two systems saw similar results. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Try changing the kernel clocksource.

Speed 126

Speed Java AWS Virtualization 126

Dynatrace

FEBRUARY 25, 2021

Lambda functions often serve as a gluing tier or a gateway from on-premises systems to AWS services; they’re almost never standalone. Depending on how resilient the calling system is, a failure in a Lambda function can potentially take down an entire website or application. Stay tuned?for Why metrics alone aren’t enough.

Lambda 218

Lambda AWS Monitoring Serverless 218

Percona

DECEMBER 20, 2018

Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud.

Database 40

Database Tuning Performance AWS 40

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. This shows the system-wide syscall rate.

Performance 75

Performance Benchmarking Cache Tuning 75

IO River

NOVEMBER 15, 2023

This involves:Threat Intelligence: Keeping an eye on the latest types of attacks, whether it's a novel form of SQL injection or a new phishing tactic.Internal Audits: Regularly scanning your own system for vulnerabilities. Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture.

Traffic 52

Traffic Network Logistics Architecture 52

IO River

NOVEMBER 2, 2023

This involves:Threat Intelligence: Keeping an eye on the latest types of attacks, whether it's a novel form of SQL injection or a new phishing tactic.Internal Audits: Regularly scanning your own system for vulnerabilities. Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture.

Traffic 40

Traffic Network Logistics Architecture 40

Percona

APRIL 12, 2023

Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.)

Open Source 80

Open Source Programming Database Servers 80