This guide shares a curated list of foundational books and resources for beginners aiming to master SQL, deepen MySQL expertise, and develop the operational and data‑centric mindset needed for a successful DBA career, including links to downloads and a weekly MySQL radio show.
After a rushed fix for a division‑by‑zero bug caused incorrect results, the team learns to validate data at its source, adopt proper validation frameworks, and step back to understand underlying requirements, emphasizing that thoughtful design outweighs quick code patches.
This article demystifies TCP optimization by explaining flow control, slow start, congestion avoidance, and practical methods to tune the receive and congestion windows (rwnd and cwnd) on Linux systems for better network performance.
When a Linux server experiences a failure, this guide walks you through a comprehensive 13‑step checklist—covering problem context, user activity, process inspection, network services, resource usage, hardware, I/O performance, logs, and scheduled tasks—to help you quickly pinpoint and resolve the root cause.
Drawing from a year and a half of Linux operations experience, this guide outlines practical standards for online actions, data handling, security, monitoring, performance tuning, and the right mindset to prevent costly incidents and maintain stable, secure systems.
This article examines the trade‑off between tab navigation and side‑drawer navigation in a multi‑page mobile app, sharing A/B test results that show a dramatic drop in user engagement when the drawer was introduced and offering practical guidance on when each pattern is appropriate.
This article analyzes how Ctrip transformed from a simple flight and hotel booking platform into a dominant, integrated travel ecosystem through aggressive pricing wars, strategic investments, mobile expansion, and partnerships, reshaping the Chinese online travel market and its profit structures.
This guide lists 25 practical Linux hardening techniques—from BIOS protection and partitioning to SSH configuration, SELinux, firewall rules, password policies, and log management—helping system administrators strengthen server security against attacks and vulnerabilities.
This article explains the exact sequence of files executed during Linux login, including /etc/profile, user-specific profiles, .bashrc, /etc/bashrc, and .bash_logout, and clarifies the roles of /etc/profile versus /etc/environment in setting system and user environments.
This article explains how leveraging human instincts in UI/UX design—through surprise, feedback loops, and detail‑focused interactions—creates deep user satisfaction, fosters repeat usage, and ultimately drives significant commercial value for mobile and web applications.
This guide walks through a practical three‑step process—using iostat to view I/O stats, iotop to identify the consuming processes, and pt‑ioprofile to reveal the exact files causing high disk I/O—helping Linux administrators quickly locate and address performance bottlenecks, especially in MySQL environments.
This article highlights several often‑overlooked MongoDB limitations—including excessive disk‑space preallocation, a 12‑node replica‑set cap, lack of high‑availability in master‑slave mode, 32‑bit version constraints, high consulting fees, and weak management tools—helping developers avoid costly surprises.
The article provides a detailed, data‑driven look at Google’s internal software development practices, covering unified trunk code management, pervasive code visibility, rigorous reviews, feature‑flag experimentation, strict testing, and the blend of Java, C++, and JavaScript in front‑end and back‑end work.
This guide compiles the most useful Linux command‑line tools for inspecting system information, managing resources, networking, processes, users, services, packages, security settings, and FTP operations, providing a quick reference for administrators and power users alike.
This guide reviews fifteen top modern PHP frameworks—including Yaf, Nette, Guzzle, Phalcon, and others—highlighting their performance, security, ease of use, and specialized features such as C‑based extensions, lightweight databases, and behavior‑driven development to help developers quickly build efficient, dynamic web applications.
This article explains how to use the sar (System Activity Reporter) tool on Linux to collect and analyze performance data, covering past and real‑time statistics, CPU, memory, I/O and swap metrics, installation steps, and a full list of command‑line options.
This article explains core performance‑testing concepts such as TPS, response time, think time, and threading, then details how to identify CPU, memory, and disk bottlenecks on Linux using tools like top, vmstat, iostat, and pidstat, linking system resources to overall application performance.
Learn how to create SSH tunnels for forward and reverse connections, set up SOCKS5 proxies, configure Windows SSH tools, and automate persistent connections with scripts like autossh, complete with practical command examples and step‑by‑step guidance for Linux and Windows environments.
This article examines the ongoing debate between SQL and NoSQL databases for big‑data projects, presenting expert arguments on performance, scalability, standardization, and flexibility to help enterprises decide the optimal solution.
Baidu’s speech synthesis system, developed since 2013 to give machines natural Chinese voices, tackles millions of tonal variations through phonetic compression and optimized acoustic models, balances trade‑offs in data and scalability, and offers a free open platform that lets developers integrate high‑quality text‑to‑speech into apps, advancing equal access to information.
