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. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. innodb_file_per_table.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Evaluating your hardware requirements is another vital aspect of resource allocation.

Open Source 90

Open Source Database Hardware Strategy 90

Scalegrid

JANUARY 25, 2024

It’s important to note that recommended throughput levels may vary depending on factors such as operating system type, network bandwidth availability, and hardware quality. Best Practices for Redis Performance Tuning Optimizing memory allocation is essential for improving Redis’s performance.

Metrics 130

Metrics Monitoring Latency Cache 130

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. that a lot of people used.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Percona

AUGUST 5, 2023

This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. This helps identify potential issues and fine-tune the partitioning strategy. ” This can lead to uneven resource utilization and slower performance for certain partitions.

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

JUNE 21, 2019

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. There are exceptions to every rule or best practice. With modern hardware, the cost estimation of 5 is outdated.

Servers 49

Servers Azure Hardware Database 49

HammerDB

OCTOBER 18, 2019

Nevertheless in this blog sometimes we do publish performance data to highlight best practices or potential configuration pitfalls and although we’ve mentioned this one before it is worth dedicating an entire post to it as this issue seems to appear numerous times running database workloads on Linux. (Yes

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

Sutter's Mill

MAY 28, 2012

Cutting-edge current: It covers the best-practices state of the art techniques and shipping tools , and what parts of that are standardized in C++11 already (the answer to that one may surprise you!) Stay tuned, and fasten your seat belts. Clang), and much more that we’ve seen already…. …

C++ 40

C++ Hardware Best Practices Tuning 40

Abhishek Tiwari

JULY 12, 2018

A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable. In certain scenarios exactly-once semantics is possible but the best you can do is at-least-once or at-most-once. If tuned for performance, there is a good change reliability is compromised - and vice versa.

Latency 63

Latency Analytics Scalability Engineering 63

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

VoltDB

MAY 2, 2017

because they want to use a lower k- factor (even 0) on the replica cluster to lower hardware costs. Recovery time can vary depending on the amount of data, the number of nodes, the hardware, and the number of indexes and views in the schema. Stay tuned for more support Q&As – and don’t forget to download our newest version , v7.2.

Hardware 40

Hardware Database Servers Tuning 40

SQL Server According to Bob

JANUARY 11, 2020

ReadFile WriteFile ReadFileScatter WriteFileGather GetOverlappedResult ​​ For extended details on the 823 error, see ​​ Error message 823 may indicate hardware problems or system problems ​​ ( [link] i crosoft.com/default.aspx?scid=kb ​​ Contact your hardware manufacture for assistance.

Servers 40

Servers Cache Database Media 40

O'Reilly

OCTOBER 11, 2022

Andrew Ng , Christopher Ré , and others have pointed out that in the past decade, we’ve made a lot of progress with algorithms and hardware for running AI. Our current set of AI algorithms are good enough, as is our hardware; the hard problems are all about data. Is special-purpose training to fine-tune a model’s behavior an option?

Games 115

Games Healthcare Processing Retail 115

Smashing Magazine

AUGUST 22, 2021

As such, tuning congestion logic is usually only done by a select few developers, and evolution is slow. As such, one best practice or optimization can end up undoing another. Many network interface controllers (NICs) even have built-in hardware-offload features for TCP. And it gets worse. Finally convinced?

Performance 105

Performance Network Latency Servers 105