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. monitoring.

Best Practices 40

Best Practices Scalability Performance C++ 40

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. Careful planning and continuous monitoring are crucial to facing these challenges and achieving optimal performance. Common choices include time-based or range-based values.

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

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

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. Some customers use scripts or monitoring tools to automate this.

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 116

Games Healthcare Processing Retail 116