Skip to content

Instantly share code, notes, and snippets.

View YouSysAdmin's full-sized avatar
🤪

Oleksii Samoliuk YouSysAdmin

🤪
View GitHub Profile
Arrows
→ ← ↑ ↓ ↔ ↕ ⇒ ⇐ ⇄ ⇆ ↩ ↪ ⤴ ⤵ ➜ ➔ ▸ ◂ ▴ ▾ » « › ‹
Chevrons / triangles (toggles, menus)
▶ ▼ ◀ ▲ ▷ ▽ ◁ △ ⌃ ⌄ ⌅ ⌆ ⏵ ⏷
Status / check / cross
@YouSysAdmin
YouSysAdmin / arch-linux-install.md
Created May 13, 2026 07:47 — forked from xamox/arch-linux-install.md
Minimal instructions for installing arch linux on an UEFI system with full system encryption using dm-crypt and luks
@YouSysAdmin
YouSysAdmin / install-arch.md
Created April 13, 2026 15:27 — forked from mjnaderi/install-arch.md
Installing Arch Linux with Full Disk Encryption (LVM on LUKS)

Installing Arch Linux with Full Disk Encryption

If you're aiming for a seamless Arch Linux installation in UEFI mode, follow along as this guide will walk you through the process step by step. We'll be using LUKS (Linux Unified Key Setup) and LVM (Logical Volume Manager) partitions on LUKS to achieve full disk encryption.

Note: I have updated this doc for UEFI mode. For those with BIOS/MBR systems, you can refer to the previous version, but keep in mind that it might be outdated and no longer accurate.

If you're only interested in installing Linux and not setting up dual boot with Windows, feel free to skip the Windows-related sections.

@YouSysAdmin
YouSysAdmin / duck.sh
Last active March 8, 2026 07:34
Console pet
#!/bin/sh
# Author: YouSysAdmin
awk '
BEGIN{
Y1="\033[93m" # light yellow
Y2="\033[33m" # dark yellow
B1="\033[94m" # dark blue
B2="\033[96m" # blue
@YouSysAdmin
YouSysAdmin / YubiKey-GPG-SSH-guide.md
Created June 25, 2025 15:14 — forked from ageis/YubiKey-GPG-SSH-guide.md
Technical guide for using YubiKey series 4 for GPG and SSH

YubiKey 4 series GPG and SSH setup guide

Written for fairly adept technical users, preferably of Debian GNU/Linux, not for absolute beginners.

You'll probably be working with a single smartcard, so you'll want only one primary key (1. Sign & Certify) and two associated subkeys (2. Encrypt, 3. Authenticate). I've published a Bash function which automates this slightly special key generation process.

@YouSysAdmin
YouSysAdmin / fix.sh
Created March 25, 2025 20:39
Fix for using MacOS as remote DOCKER_HOST
# Context:
# make sure the URL is valid, and Docker 18.09 or later is installed on the remote host.
# zsh:1: command not found: docker
# Add /usr/local/bin to PATH for SSH session
echo 'PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin' >> ~/.ssh/environment
# Permit set user environment for SSH session
sudo sh -c 'echo "PermitUserEnvironment PATH" >> /private/etc/ssh/sshd_config'
@YouSysAdmin
YouSysAdmin / theme.yml
Created March 2, 2025 09:24 — forked from r-darwish/theme.yml
Alacritty One Dark Theme
colors:
# Default colors
primary:
background: '0x1e2127'
foreground: '0xabb2bf'
# Bright and dim foreground colors
#
# The dimmed foreground color is calculated automatically if it is not present.
@YouSysAdmin
YouSysAdmin / schema_auto_increment_columns.sql
Created December 2, 2024 11:28 — forked from bennadel/schema_auto_increment_columns.sql
Looking For Database Performance Bottlenecks And Optimizations Using The Sys Schema In MySQL 5.7
/**
* Find the amount of auto-increment "space" has been used. This may can help identify
* tables that are running out of available ID values.
*/
SELECT
t.table_name,
t.column_name,
-- The highest possible ID that can be created with this data-type.
t.max_value,
-- The last ID created in this table.
@YouSysAdmin
YouSysAdmin / print.go
Last active September 17, 2024 21:29
// Database Information about RDS instance
type Database struct {
// Database identifier
Identifier string
// Database ARN
Arn string
// Database engine (mysql2, postgres, etc.)
Engine string
// Database engine version
EngineVersion string
@YouSysAdmin
YouSysAdmin / mysql-memoryusage.sh
Created August 4, 2023 19:55
Script to get information about used memory by a MySQL server
#!/bin/sh
# you might want to add some user authentication here
mysql -e "show variables; show status" | awk '
{
VAR[$1]=$2
}
END {
MAX_CONN = VAR["max_connections"]
MAX_USED_CONN = VAR["Max_used_connections"]
BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]