Remove Benchmarking Remove Cache Remove Tuning
article thumbnail

The Most Important MySQL Setting

Percona

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 145
article thumbnail

Tuning PostgreSQL Database Parameters to Optimize Performance

Percona

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. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. wal_buffers.

Tuning 79
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

Key metrics like throughput, request latency, and memory utilization are essential for assessing Redis health, with tools like the MONITOR command and Redis-benchmark for latency and throughput analysis and MEMORY USAGE/STATS commands for evaluating memory. Cache Hit Ratio The cache hit ratio represents the efficiency of cache usage.

Metrics 130
article thumbnail

The evolution of single-core bandwidth in multicore processors

John McCalpin

For most high-end processors these values have remained in the range of 75% to 85% of the peak DRAM bandwidth of the system over the past 15-20 years — an amazing accomplishment given the increase in core count (with its associated cache coherence issues), number of DRAM channels, and ever-increasing pipelining of the DRAMs themselves.

article thumbnail

Impact of Querying Table Information From information_schema

Percona

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. having to open each table.frm (and in which my test runs, I have purposely read a very high number of tables compared to “Table-open-cache” variable). Results for Percona Server for MySQL 8.0

Cache 124
article thumbnail

InnoDB Performance Optimization Basics

Percona

By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way. Benchmark before you decide. If you see concurrency issues, you can tune this variable. CPU From a CPU standpoint, faster processors with many cores provide better throughput.

article thumbnail

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook

The Morning Paper

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.