HammerDB

OCTOBER 18, 2018

An essential part of database performance testing is viewing the statistics generated by the database during the test and in 2009 HammerDB introduced automatic AWR snapshot generation for Oracle for the TPC-C test. In this example a test with 2 minute rampup and 5 minute test time can be seen.

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. An example is kubectl-flame ( [link] ). For example, if you specify the NodeJS language, it produces the flame graph based on perf output. ✔ Launching profiler.

Code 111

Code Tuning C++ Benchmarking 111

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1.

Open Source 90

Open Source Storage Database Big Data 90

The Netflix TechBlog

OCTOBER 19, 2020

a Netflix member via Twitter This is an example of a question our on-call engineers need to answer to help resolve a member issue?—?which Our engineering teams tuned their services for performance after factoring in increased resource utilization due to tracing. which is difficult when troubleshooting distributed systems.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Apica

MAY 10, 2019

Load and stress-testing benchmark goals for the backend technological components. These companies should involve multiple organizations during Apica’s load testing to observe and pinpoint opportunities for performance tuning. User scenarios specifically expected to have high-loads.

Testing 40

Testing Performance Social Media Wireless 40

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

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 127

Performance Hardware Tuning Storage 127

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? That’s a heritage of the LAMP model when the same server would host both the database and the web server.

Tuning 137

Tuning Cache Servers Benchmarking 137

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

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? 3834 2696

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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. Oracle Log File Sync.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Dynatrace

APRIL 8, 2021

When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. These served as our benchmark when creating our Lambda monitoring extension. So, stay tuned for more blog posts and announcements. Top enterprise use-cases for AWS Lambda.

Lambda 220

Lambda AWS Serverless Monitoring 220

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. For example, using my [perf-tools]: sudo./perf-tools/bin/funccount

Performance 75

Performance Benchmarking Cache Tuning 75

O'Reilly

JULY 25, 2023

Tutorials provide generic conceptual explanations and use made-up toy examples that I can’t relate to. In contrast, ChatGPT can generate personalized tutorials that use my own Swift Papers project as the example in its explanations! So I end up needing to figure out how their explanations may or may not apply to my own context.

Programming 98

Programming Code Design Benchmarking 98

Dynatrace

APRIL 8, 2021

When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. These served as our benchmark when creating our Lambda monitoring extension. So, stay tuned for more blog posts and announcements. Top enterprise use-cases for AWS Lambda.

Lambda 182

Lambda AWS Serverless Monitoring 182

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. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

FEBRUARY 8, 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. For example, using my [perf-tools]: sudo./perf-tools/bin/funccount

Performance 40

Performance Benchmarking Cache Tuning 40

IO River

NOVEMBER 15, 2023

For example, if a request activates a rule designed to block SQL injection attempts, the WAF might automatically block that request, preventing it from reaching your web application.‍Security 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

Percona

AUGUST 30, 2018

One of the common ways to classify database workloads is whether it is “read intensive” or “write intensive”. 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.

Benchmarking 48

Benchmarking Database Operating System Architecture 48

IO River

NOVEMBER 2, 2023

For example, if a request activates a rule designed to block SQL injection attempts, the WAF might automatically block that request, preventing it from reaching your web application.‍Security Flywheel‍‍When it comes to fortifying web applications, think of security as a flywheel—an ever-revolving cycle that gains momentum with each turn.

Traffic 40

Traffic Network Logistics Architecture 40

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB.

Best Practices 40

Best Practices Scalability Performance C++ 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? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

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

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. Which database do you use? How is your database architected? Cloud Platform. Google cloud. Hosted Data Centers.

Architecture 52

Architecture Cache Azure Storage 52