Scalegrid

JANUARY 25, 2024

This blog post lists the important database metrics to monitor. 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.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

MARCH 17, 2023

The VictoriaMetrics team has also published some best practices , which can also be referred to while planning for resources for setting up PMM2. VictoriaMetrics maintains an in-memory cache for mapping active time series into internal series IDs. We have tested PMM version 2.33.0

Monitoring 101

Monitoring Scalability Cache Database 101

Percona

JUNE 22, 2023

In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM. This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index. error_log: Specifies the location of the MySQL error log.

Performance 106

Performance Monitoring Traffic Database 106

MachMetrics

DECEMBER 14, 2019

Google’s best practice is to have a speed index under 3 seconds. Google’s best practice is to be below 0.5 However, Google’s best practice is to keep the number of requests below 50, so there is still work to be done. Google’s best practice is to achieve a time under 1.3

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. By understanding these challenges and following best practices, you can make the most of triggers while minimizing potential drawbacks. Benchmark different trigger implementations to identify the most efficient option.

Cache 62

Cache Database Games Healthcare 62

Percona

JUNE 22, 2023

” Here are additional metrics used to determine the reliability of a database, make adjustments that minimize downtime, and set benchmarks for meeting business continuity requirements. MongoDB : While not open source (see our blog Is MongoDB Open Source? Please note that these are presented as general best practices.

Availability 110

Availability Database Open Source Hardware 110