Eugene Klimov Slach

Proxmox VE Installation on Hetzner Server via Rescue System

Follow these steps to install Proxmox VE on a Hetzner server via the Rescue System. The Rescue System is a Linux-based environment that can be booted into to perform system recovery tasks. We'll be using it to install Proxmox VE.

In order to complete the process, it is indeed necessary to first boot into the Rescue System and then connect to it via SSH. This will allow you to run the commands for installing Proxmox VE. Here are the steps:

Starting the Rescue System

Log into the Hetzner Robot.
Under "Main Functions; Server" select the desired server and then open the tab "Rescue".

Счётчики, метрики и трейспоинты в ClickHouse (черновик).

Мотивация

В ClickHouse разным образом реализовано некоторое количество функциональности, имеющей общие черты. Это:

метрики на основе инкрементальных счётчиков (ProfileEvents);
метрики на основе количества одновременных процессов (Metrics);
метрики на основе асинхронно получаемых значений (AsynchronousMetrics);
ограничения на сложность выполнения запроса (встроены в Settings);
прогресс выполнения запроса (Progress, отправляется клиенту);

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

There are always 24 hours in a day.
February is always 28 days long.
Any 24-hour period will always begin and end in the same day (or week, or month).

There are certain files created by particular editors, IDEs, operating systems, etc., that do not belong in a repository. But adding system-specific files to the repo's .gitignore is considered a poor practice. This file should only exclude files and directories that are a part of the package that should not be versioned (such as the node_modules directory) as well as files that are generated (and regenerated) as artifacts of a build process.

All other files should be in your own global gitignore file:

Create a file called .gitignore in your home directory and add any filepath patterns you want to ignore.
Tell git where your global gitignore file is.

Note: The specific name and path you choose aren't important as long as you configure git to find it, as shown below. You could substitute .config/git/ignore for .gitignore in your home directory, if you prefer.

	FROM centos:7

	RUN yum install -y python3 python3-devel python3-pip unixODBC unixODBC-devel python3-setuptools gcc gcc-c++ https://download.dremio.com/odbc-driver/dremio-odbc-LATEST.x86_64.rpm && \
	pip3 install apache-superset sqlalchemy_dremio && \
	export LC_ALL=en_US.UTF-8 && \
	superset db upgrade && \
	superset init && \
	export FLASK_APP=superset && \
	flask fab create-admin --username admin --firstname admin --lastname admin --email admin@admin --password admin

	SELECT
	count(),
	arrayStringConcat(arrayMap(x -> concat(demangle(addressToSymbol(x)), '\n ', addressToLine(x)), trace), '\n') AS sym
	FROM system.trace_log
	WHERE (query_id = 'ebca3574-ad0a-400a-9cbc-dca382f5998c') AND (event_date = today())
	GROUP BY trace
	ORDER BY count() DESC
	LIMIT 10

	Row 1:

	#!/bin/sh
	# Launch a Pod ab-using a hostPath mount to land on a Kubernetes node cluster as root
	# without requiring `privileged: true`, in particular can abuse `DenyExecOnPrivileged`
	# admission controller.
	# Pod command in turn runs a privileged container using node's /var/run/docker.sock.
	node=${1}
	case "${node}" in
	"")
	nodeSelector=''
	podName=${USER+${USER}-}docker-any

	# -- ksh --
	#
	# If you use the GNU debugger gdb to debug the Python C runtime, you
	# might find some of the following commands useful. Copy this to your
	# ~/.gdbinit file and it'll get loaded into gdb automatically when you
	# start it up. Then, at the gdb prompt you can do things like:
	#
	# (gdb) pyo apyobjectptr
	# <module 'foobar' (built-in)>
	# refcounts: 1

	###
	###
	### UPDATE: For Win 11, I recommend using this tool in place of this script:
	### https://christitus.com/windows-tool/
	### https://github.com/ChrisTitusTech/winutil
	### https://www.youtube.com/watch?v=6UQZ5oQg8XA
	### iwr -useb https://christitus.com/win \| iex
	###
	### OR take a look at
	### https://github.com/HotCakeX/Harden-Windows-Security

	// Tarantool quick test
	// Copyright, Dennis Anikin 2016
	//
	// Quick disclaimer:
	//
	// This test shows 500K-1000K transactions per second on one CPU core
	// and 600K-1600K queries per second on one CPU core.
	//
	// Based on the $6.57 per-month-price for the AWS t2.micro instance we can afford the tremendous number of 630bln queries for just $1
	//