Author

Linyb Geek Road

Tech notes

155

Articles

Likes

420

Views

Comments

Latest from Linyb Geek Road

100 recent articles max

Linyb Geek Road

Jul 17, 2026 · Databases

8 Common SQL Mistakes That Are Destroying Your Database

The article identifies eight easy-to-overlook SQL habits—such as using SELECT *, applying functions on indexed columns, careless LIKE patterns, improper IN/OR logic, deep offset pagination, unconditional UPDATE/DELETE, excessive indexing, and ignoring execution plans—that can cause slow queries, lock tables, index failures, and even data loss, and provides concrete examples and safer alternatives.

DatabaseIndexingMySQL

0 likes · 12 min read

8 Common SQL Mistakes That Are Destroying Your Database

Linyb Geek Road

Jul 17, 2026 · Fundamentals

Mastering Linux’s Three Musketeers: grep, sed, and awk

This article introduces Linux’s three essential text‑processing tools—grep for searching, sed for stream editing, and awk for column‑based reporting—explaining their key options, demonstrating practical command‑line examples, and showing how each excels in specific data‑handling scenarios.

Command LineLinuxawk

0 likes · 7 min read

Mastering Linux’s Three Musketeers: grep, sed, and awk

Linyb Geek Road

Jul 17, 2026 · Databases

Why 90% of Slow SQL Queries Aren’t Caused by Large Data Volumes

Most slow SQL statements stem from poor query writing—such as index‑breaking functions, implicit type casts, leading wildcards, unnecessary column selection, improper joins, sorting, grouping, and pagination—rather than merely the size of the data, and the article shows how to diagnose and fix each issue.

DatabaseIndexingQuery Optimization

0 likes · 11 min read

Why 90% of Slow SQL Queries Aren’t Caused by Large Data Volumes

Linyb Geek Road

Jul 17, 2026 · Operations

Speed Up Log Troubleshooting with a Powerful awk, tail, grep, and sed Toolkit

When a 2 GB production log triggers an alert, this guide shows how tail, less, grep, sed, and awk can be combined in real‑world scenarios to quickly locate errors, count occurrences, filter noise, and extract time windows without downloading the entire file.

Command LineLinuxawk

0 likes · 8 min read

Speed Up Log Troubleshooting with a Powerful awk, tail, grep, and sed Toolkit

Linyb Geek Road

Jul 15, 2026 · Artificial Intelligence

From ReAct to Harness: Building Production‑Ready Agent Architectures

The article outlines the five‑stage evolution of AI agents—from the basic ReAct loop to self‑driving, self‑optimizing systems—and presents six engineering pillars (verification, stop, state, recovery, isolation, observability) that together form a Harness framework for deploying reliable, production‑grade agents.

AI Agentsagent architectureobservability

0 likes · 8 min read

From ReAct to Harness: Building Production‑Ready Agent Architectures

Linyb Geek Road

Jul 14, 2026 · Artificial Intelligence

Understanding MCP, Skill, Harness, and Loop: A Deep Dive into the Four‑Layer AI Agent Architecture

The article breaks down the four‑layer AI Agent stack—MCP protocol, Agent Skill, Harness runtime, and Loop engineering—showing how each layer solves distinct problems, presenting benchmark data (e.g., a 25.7 pp SWE‑bench gain from Harness changes), security analyses, design trade‑offs, and a production checklist.

AI Agent ArchitectureAgent HarnessAgent Skill

0 likes · 26 min read

Understanding MCP, Skill, Harness, and Loop: A Deep Dive into the Four‑Layer AI Agent Architecture

Linyb Geek Road

Jul 13, 2026 · Artificial Intelligence

Why AI Agents Crash and How Harness & Loop Engineering Make Them Run Autonomously

The article explains why AI agents frequently fail in production, identifies four core runtime failure modes, and shows how a two‑layer architecture—Harness for stability and Loop engineering for autonomous scheduling—combined with concrete configurations, memory tiering, and verification loops can keep agents running reliably.

AI AgentHarnessLoop Engineering

0 likes · 18 min read

Why AI Agents Crash and How Harness & Loop Engineering Make Them Run Autonomously

Linyb Geek Road

Jul 12, 2026 · Operations

Designing a High‑Availability Architecture: Core Principles and Practices

This article outlines the essential principles for building a high‑availability system, covering cluster and distributed designs, fault‑tolerance, reliable hardware, disaster recovery, monitoring, security, capacity planning, and automated scaling to achieve optimal performance and resilience.

Cluster ArchitectureDisaster RecoveryFault Tolerance

0 likes · 6 min read

Designing a High‑Availability Architecture: Core Principles and Practices

Linyb Geek Road

Jul 11, 2026 · Artificial Intelligence

Why Are AI Agent Bills Soaring? Token‑Saving Techniques to Cut Costs

The article explains that most token cost comes from system‑added context rather than the user query, breaks down cost components, and offers a hierarchy of optimizations—from usage habits and prompt caching to model routing, tool management, and output compression—to dramatically reduce AI coding agent expenses.

AI AgentContext CompressionModel Routing

0 likes · 23 min read

Why Are AI Agent Bills Soaring? Token‑Saving Techniques to Cut Costs

Linyb Geek Road

Jul 11, 2026 · Artificial Intelligence

How to Slash Token Costs When Using AI Agents

The article analyzes why AI agents quickly consume token quotas and presents seven practical strategies—shortening sessions, avoiding parallel sub‑agents, giving concise prompts, providing precise context, pre‑defining rules, automating mechanical tasks, and investing in clear prompts—to dramatically reduce token usage and lower operational costs.

AI AgentsPrompt Engineeringautomation

0 likes · 10 min read

How to Slash Token Costs When Using AI Agents