Open in app

Sign In

Write

Sign In

Aliaksandr Valialkin
Aliaksandr Valialkin

1K Followers

Home

About

Pinned

How to optimize PromQL and MetricsQL queries

PromQL and MetricsQL are powerful query languages. They allow writing simple queries for building nicely looking graphs over time series data. They also allow writing sophisticated queries for SLI / SLO calculations and alerts. But it may be hard to optimize PromQL queries. …

Promql

8 min read

How to optimize PromQL and MetricsQL queries
How to optimize PromQL and MetricsQL queries
Promql

8 min read


Dec 16, 2020

Promscale vs VictoriaMetrics: measuring resource usage in production

Timescale recently published Promscale — an open source long-term remote storage for Prometheus built on top of TimescaleDB. According to the announcement, it should be fast and resource efficient. Let’s compare performance and resource usage on production workload for Promscale and VictoriaMetrics. Benchmark setup The following scheme has been constructed for the…

Timescaledb

6 min read

Promscale vs VictoriaMetrics: resource usage on production workload
Promscale vs VictoriaMetrics: resource usage on production workload
Timescaledb

6 min read


Nov 27, 2020

Prometheus vs VictoriaMetrics benchmark on node_exporter metrics

Recently single-node VictoriaMetrics gained support for scraping Prometheus targets. This made possible to run apples-to-apples benchmark, which compares resource usage for Prometheus and VictoriaMetrics during scraping big number of real node_exporter targets. Benchmark setup The benchmark was run in Google Compute Engine on four machines (instances): An instance with node_exporter v1.0.1 for…

Prometheus

5 min read

Prometheus vs VictoriaMetrics benchmark on node_exporter metrics
Prometheus vs VictoriaMetrics benchmark on node_exporter metrics
Prometheus

5 min read


Nov 5, 2020

How to use relabeling in Prometheus and VictoriaMetrics

Prometheus supports relabeling, which allows performing the following tasks: Adding new label Updating existing label Rewriting existing label Updating metric name Removing unneeded labels Removing unneeded metrics Dropping metrics on certain condition Modifying label names Constructing a label from multiple existing labels Chaining relabeling rules Lets’ looks at how to…

Prometheus

6 min read

How to use relabeling in Prometheus and VictoriaMetrics
How to use relabeling in Prometheus and VictoriaMetrics
Prometheus

6 min read


Jan 22, 2020

Billy: how VictoriaMetrics deals with more than 500 billion rows

Recently ScyllaDB published an interesting article How Scylla scaled to one billion rows per second. They conducted a benchmark (named Billy) for a typical time series workload, which simulates a million temperature sensors reporting every minute for a year’s worth of data. This translates to 1M*60*24*365=525.6 billion data points. …

Benchmark

11 min read

Billy: how VictoriaMetrics deals with more than 500 billion rows
Billy: how VictoriaMetrics deals with more than 500 billion rows
Benchmark

11 min read


Dec 3, 2019

Prometheus storage: technical terms for humans

Many technical terms could be used when referring to Prometheus storage — either local storage or remote storage. New users could be unfamiliar with these terms, which could result in misunderstandings. Let’s explain the most commonly used technical terms in this article. Time Series A time series is a series of (timestamp…

Prometheus

5 min read

Prometheus storage: technical terms for humans
Prometheus storage: technical terms for humans
Prometheus

5 min read


Nov 26, 2019

Improving histogram usability for Prometheus and Grafana

It looks like histogram support is great in Prometheus ecosystem: Prometheus client libraries provide Histogram metrics. Prometheus provides histogram_quantile function for calculating quantiles over histogram buckets. Grafana supports visualizing Prometheus histogram buckets via Heatmap panel. But why Prometheus users continue complaining about issues in histograms? …

Prometheus

6 min read

Improving histogram usability for Prometheus and Grafana
Improving histogram usability for Prometheus and Grafana
Prometheus

6 min read


Nov 20, 2019

Evaluating Performance and Correctness: VictoriaMetrics response

Recently the Evaluating Performance and Correctness article has been published by Prometheus author. The article points to a few data model discrepancies between VictoriaMetrics and Prometheus. It also contains benchmark results showing poor compression ratio and poor performance for VictoriaMetrics comparing to Prometheus. Unfortunately the original article doesn’t support comments…

Prometheus

8 min read

Evaluating Performance and Correctness: VictoriaMetrics response
Evaluating Performance and Correctness: VictoriaMetrics response
Prometheus

8 min read


Nov 10, 2019

Speeding up backups for big time series databases

Suppose you have a time series database containing terabytes of data. How do you mange backups for this data? Do you think it is too big to backup and blindly rely on database replication for data safety? Then you are in trouble. Why replication doesn’t save from disaster? Replication is the process of creating multiple copies…

Database

4 min read

Speeding up backups for big time series databases
Speeding up backups for big time series databases
Database

4 min read


Published in FAUN Publication

·Jun 30, 2019

Comparing Thanos to VictoriaMetrics cluster

Thanos is known as long-term storage for Prometheus, while cluster version of VictoriaMetrics had been open sourced recently. Both solutions provide the following features: Long-term storage with arbitrary retention. Global query view over data collected from multiple Prometheus instances. Horizontal scalability. Let’s compare different aspects of Thanos and VictoriaMetrics starting…

Kubernetes

11 min read

Comparing Thanos to VictoriaMetrics cluster
Comparing Thanos to VictoriaMetrics cluster
Kubernetes

11 min read

Aliaksandr Valialkin

Aliaksandr Valialkin

1K Followers

Founder and core developer at VictoriaMetrics

Following
  • Sammy Abdullah

    Sammy Abdullah

  • Сергей Карелов

    Сергей Карелов

  • Rosi Haft

    Rosi Haft

  • Jesus Rodriguez

    Jesus Rodriguez

  • Shon Lev-Ran

    Shon Lev-Ran

See all (338)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech