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 137

Tuning Cache Servers Benchmarking 137

Percona

MARCH 23, 2023

Nowadays, solid-state drives (SSDs) or non-volatile memory express (NVMe) drives are preferred over traditional hard disk drives (HDDs) for database servers due to their faster read and write speeds, lower latency, and improved reliability. Benchmark before you decide. If you see concurrency issues, you can tune this variable.

Performance 127

Performance Hardware Tuning Storage 127

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 . 3823 2694 -- 0 4 4 2864 74.83

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . Additionally for the log disk component it is latency for an individual write that is crucial rather than the total I/O bandwidth. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 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

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

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. of the “adjusted peak performance”, there is no longer a significant upside to performance tuning.

Latency 40

Latency Hardware Code Testing 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. an example is shown of the shortest of these: . An example MySQL my.cnf file is shown.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Server According to Bob

JANUARY 11, 2020

Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. The following are examples of successful recovery situations actually encountered by Microsoft SQL Server Product Support Services personnel. This cache is often supported by a battery-powered backup facility.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

As ​​ a ​​ simple ​​ example, ​​ take the following ​​ 2-byte string value of “AB” and apply a formula to it (Value = Position + ASCII value). ​​ Checksum ​​ is ​​ the sum of the values.

Servers 40

Servers Cache Database Media 40