Linux Tech Enthusiast
Author

Linux Tech Enthusiast

Focused on sharing practical Linux technology content, covering Linux fundamentals, applications, tools, as well as databases, operating systems, network security, and other technical knowledge.

233
Articles
0
Likes
1.6k
Views
0
Comments
Recent Articles

Latest from Linux Tech Enthusiast

100 recent articles max
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 28, 2026 · Databases

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.

CTEMySQLSQL optimization
0 likes · 16 min read
8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 27, 2026 · Operations

LVS vs Nginx: Layer 4 vs Layer 7 Load Balancing Trade-offs

This article compares LVS (Layer 4) and Nginx (Layer 7) load balancers, explaining why LVS achieves higher throughput by only inspecting IP headers while Nginx terminates TCP connections for HTTP-aware routing, health checks, and request retry — at the cost of added latency and configuration complexity.

LVSNginxhealth checks
0 likes · 11 min read
LVS vs Nginx: Layer 4 vs Layer 7 Load Balancing Trade-offs
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 26, 2026 · Game Development

Why Classic FC Games Were Written in 6502 Assembly

The article explains that classic FC (Famicom/NES) games like Super Mario Bros. and Contra were programmed in 6502 assembly language because the console's 8-bit MOS 6502 CPU, 2 KB RAM, and 40 KB ROM required low-level hardware control and extreme memory efficiency that high-level languages could not provide.

6502 CPUFamicomLow-Level Programming
0 likes · 5 min read
Why Classic FC Games Were Written in 6502 Assembly
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 25, 2026 · Fundamentals

TCP Explained in 28 Diagrams: Handshakes, Congestion Control & Reliable Transmission

This article uses 28 diagrams to comprehensively explain TCP, covering network layering, TCP header structure, byte-stream orientation, reliable transmission mechanisms (sliding window, ARQ, acknowledgments), congestion control algorithms (slow start, congestion avoidance, fast retransmit/recovery), three-way handshake and four-way termination, UDP comparison, and practical issues like packet fragmentation, sticky packets, and SYN flood attacks.

SYN floodTCPUDP
0 likes · 27 min read
TCP Explained in 28 Diagrams: Handshakes, Congestion Control & Reliable Transmission
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 24, 2026 · Operations

18 Production-Ready Shell Scripts for Daily Sysadmin Tasks

This article presents 18 practical shell scripts for common system administration tasks including file consistency checks, log rotation, network traffic monitoring, FTP downloads, user input validation, Nginx 502 error auto-recovery, port scanning, batch file renaming, IP blocking, and IP address validation.

Shell Scriptingautomationbash
0 likes · 36 min read
18 Production-Ready Shell Scripts for Daily Sysadmin Tasks
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 23, 2026 · Operations

20 Linux Network Monitoring Tools You Might Not Know

This article introduces 20 Linux command-line tools for network monitoring — such as nethogs, nload, iftop, tcpdump, and ntopng — with installation commands, usage examples, and key features for system administrators across distributions.

command-line-toolsiftoplinux
0 likes · 27 min read
20 Linux Network Monitoring Tools You Might Not Know
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 19, 2026 · Fundamentals

Linux Network Stack Complete Guide: Illustrated Deep Dive

This comprehensive illustrated guide covers the entire Linux network stack from physical layer to application layer, detailing protocols like TCP/IP, routing algorithms, DNS, HTTP, and security mechanisms with diagrams and command references.

Linux networkingOSI modelnetwork commands
0 likes · 73 min read
Linux Network Stack Complete Guide: Illustrated Deep Dive