Administration Section
A classic question that a developer brings to their DBA or a business owner to a PostgreSQL consultant almost always sounds the same: 'Why do queries take so long on the database?' The traditional set of reasons: inefficient algorithm when you decided to JOIN several CTEs with a couple of tens of thousands of records; outdated statistics if the actual data distribution in the table is already significantly […]
Introducing Windows Terminal v0.10! As always, you can download it from the Microsoft Store or from the releases page on GitHub. Below, we’ll take a closer look at the details of the update! Mouse Input The Terminal now supports mouse input in Windows Subsystem for Linux (WSL) applications, as well as in Windows applications that use virtual terminal (VT) input. This […]
Translator's Preface The material intrigued me primarily because of the table below: Given that statisticians (and Russians, genetically speaking) generally do not favor anything that deviates from linear relationships, these guys managed to push for the use of an activation function in a parabolic form to determine the risk level of using Big Data in official statistics. Well done. Naturally, statisticians added their own […]
I invite you to read the transcript of Roman Khavronenko's report "ExtendedPromQL". A brief introduction about myself: My name is Roman. I work at CloudFlare, live in London, and I also maintain VictoriaMetrics. I am the author of the ClickHouse plugin for Grafana and ClickHouse-proxy – a small proxy for ClickHouse. We will start with the first part, titled "Translation Challenges," in which I will […]
Today we will discuss an interesting technology implemented in Unity/Unity XT storage systems – FAST VP. If you are hearing about Unity for the first time, you can find the system specifications at the link at the end of the article. I have worked on FAST VP for over a year within the Dell EMC project team. Today, I would like to delve deeper into this technology and reveal some details about it […]
One of the typical scenarios in all the familiar applications is searching for data based on certain criteria and displaying it in a readable format. There may also be additional features for sorting, grouping, and pagination. The task is, in theory, trivial, but many developers make a series of mistakes during implementation that negatively impact performance. Let's take a look at various […]
The topic of DevOps has become very popular in recent years. Many aspire to get into it, but, as practice shows, often only due to salary levels. Some list DevOps on their resumes even though they don't always understand the essence of the term. Others think that by learning Ansible, GitLab, Jenkins, Terraform, and similar tools (the list can go on according to personal preference), they […]
Hello! We hope you're reading this post during working hours, already transitioned to remote work by your employer. We managed to shift our employees to remote work fairly quickly for one simple reason - starting in 2016, our strategic remote work project, BeeFREE, has existed, allowing employees to work from home. Below, we will discuss […]
There is a lot of reference literature on the Internet, but sometimes the simplest advice turns out to be the most valuable. The Kubernetes aaS team from Mail.ru has compiled a list of ten tricks and tips that the article's author gathered after a year of working with Kubernetes. The tips are not sorted by significance, but we believe everyone will find something useful for themselves. The simplest command for working with Kubernetes […]
Berkeley Packet Filters (BPF) is a Linux kernel technology that has consistently made headlines in English-language technical publications for several years. Conferences are filled with talks about the use and development of BPF. David Miller, the maintainer of the Linux networking subsystem, titles his talk at Linux Plumbers 2018 “This talk is not about XDP” (XDP is one of […]
In Unix-like operating systems, a program communicates with the outside world and the operating system through a small set of functions known as system calls. This means that for debugging purposes, it can be useful to observe the system calls made during the execution of processes. The utility strace helps to monitor the 'intimate life' of programs on Linux, which is the focus of this article. Examples of the use of 'spy' equipment are included along with brief […]
Hello, friends! After the publication of the article 'UPS and Battery Array: Where to Install? Just Wait' there were many comments regarding the dangers of Li-Ion solutions for servers and data centers. Therefore, today we will try to understand the differences between industrial lithium solutions for UPS and the batteries in your gadgets, how the operating conditions of batteries differ in the server room, and why Li-Ion in phones […]