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

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. Spoiler alert: This post focuses on MongoDB 3.6.X tcp_fin_timeout = 30 net.ipv4.tcp_keepalive_intvl

Best Practices 52

Best Practices Design Tuning Database 52

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

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. Large preview ).

Cache 135

Cache Best Practices Strategy Servers 135

Percona

JULY 6, 2023

I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice.

Best Practices 94

Best Practices Tuning Database Testing 94

Smashing Magazine

MARCH 19, 2021

Gael Metais suggested to more aggressively subset web fonts and look into caching issues with our AVIF files. If a browser doesn’t support AVIF, it gets a JPEG file (properly cached), The content negotiation happens via <picture> + srcset in the browser. Smashing Podcast: Tune In And Get Inspired. What’s New In Drupal 9?

Mobile 140

Mobile Design Cache Code 140