Artemiy Ryabinkov furdarius

## arch_installation.md

      
              1 file
            
          
              28 forks
            
          
              4 comments
            
          
              103 stars
            
          
                eltonvs
                / arch_installation.md
            
            
              Last active
              March 13, 2024 17:51
            
              
                Arch Linux step to step installation guide
              
          
    Arch Linux Installation Guide

This guide will show step-by-step how to Install Arch Linux on UEFI mode.
Table of Contents


Bootable Flash Drive
BIOS
Pre installation

Set Keyboard Layout
Check boot mode


Update System Clock


## ARCH_INSTALL.MD

      
              1 file
            
          
              25 forks
            
          
              4 comments
            
          
              95 stars
            
          
                heppu
                / ARCH_INSTALL.MD
            
            
              Last active
              February 27, 2022 17:01
            
              
                Installing Arch with GPT, dm-crypt, LUKS, LVM and systemd-boot
              
          
    Create bootable USB

dd bs=4M if=/path/to/archlinux.iso of=/dev/sdx status=progress oflag=sync
Boot from USB and set prepare system

loadkeys <your-keymap>

  
## benchmark+go+nginx.md

      
              1 file
            
          
              120 forks
            
          
              22 comments
            
          
              515 stars
            
          
                hgfischer
                / benchmark+go+nginx.md
            
            
              Last active
              April 11, 2024 22:09
            
              
                Benchmarking Nginx with Go
              
          
    Benchmarking Nginx with Go

There are a lot of ways to serve a Go HTTP application. The best choices depend on each use case. Currently nginx looks to be the standard web server for every new project even though there are other great web servers as well. However, how much is the overhead of serving a Go application behind an nginx server? Do we need some nginx features (vhosts, load balancing, cache, etc) or can you serve directly from Go? If you need nginx, what is the fastest connection mechanism? This are the kind of questions I'm intended to answer here. The purpose of this benchmark is not to tell that Go is faster or slower than nginx. That would be stupid.
So, these are the different settings we are going to compare:

Go HTTP standalone (as the control group)
Nginx proxy to Go HTTP
Nginx fastcgi to Go TCP FastCGI
Nginx fastcgi to Go Unix Socket FastCGI


## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'