Percona

MAY 1, 2023

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. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 1, 2023

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

Scalegrid

JANUARY 25, 2024

Effective management of memory stores with policies like LRU/LFU proactive monitoring of the replication process and advanced metrics such as cache hit ratio and persistence indicators are crucial for ensuring data integrity and optimizing Redis’s performance. Cache Hit Ratio The cache hit ratio represents the efficiency of cache usage.

Metrics 130

Metrics Monitoring Latency Cache 130

Smashing Magazine

NOVEMBER 8, 2021

At the limit, statically generated, edge delivered, and HTML-first pages look like the optimal strategy. On top of this foundation, we add layers of caching, prerendering and edge delivery optimizations — not the other way around. Stay tuned for more in 2022! Large preview ).

Cache 137

Cache Best Practices Strategy Servers 137

The Netflix TechBlog

AUGUST 10, 2020

and thus fall back to less efficient encode families. Since then, we have applied innovations such as shot-based encoding and newer codecs to deploy more efficient encode families. Further tuning of pre-defined encoding parameters. One such encode family that has wide decoder support amongst legacy devices is our H.264/AVC

Innovation 239

Innovation Traffic Network Efficiency 239

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

Percona

JULY 6, 2023

In PostgreSQL, there are different ways it can leverage the indexes to produce the most efficient plan. But still, this is one of the most efficient ways of retrieving data from a table. Tune the random_page_cost parameter. Tune the effective_cache_size parameter. Next is the table definition.

Best Practices 87

Best Practices Tuning Database Testing 87