Technology exchange and sharing for quality engineering
A recent order‑fulfillment outage was traced to a MySQL query that used the primary‑key index because an ORDER BY id ASC LIMIT 350 forced a full scan, but tweaking the ORDER BY or removing it reduced execution time from 20 seconds to under one second.
Parallel testing overlaps development and testing to dramatically shorten delivery cycles, shift quality checks earlier, and improve overall software quality, while the supply‑chain case study shows layered testing, automated interface tests, CI pipelines, and practical tips for stable automation and low‑coupling design.
This article examines a production incident caused by using the ES5 for...in loop to iterate over arrays, explains its pitfalls such as prototype pollution and string indexes, and demonstrates why switching to the ES6 for...of construct provides safer, more predictable array traversal.
An order system retrieved incorrect product size data due to master‑slave database lag causing stale Redis cache, and the article explains the original flawed flow, the revised solution that writes to cache during sync, and best practices for cache updates, read‑through, and QA testing.
This article details a 50‑hour experiment that simulates network packet loss between geographically separated RabbitMQ clusters and clients, showing how packet drops affect ACKs, socket buffers, and latency, and ultimately demonstrating that no messages were lost during the test.
This article explains how a Janus service gateway ran out of memory due to unreleased Netty off‑heap ByteBufs, how enabling Netty's leak detection and adjusting JVM parameters helped reproduce the issue, and how to fix the leak by explicitly releasing the buffers.
This article explains why a Janus gateway’s QPS stalled under large payloads, how enabling NIC multi‑queue and binding interrupts to specific CPUs (IRQ affinity) resolves the bottleneck, and provides practical commands and a script for Linux network interrupt tuning.
This article introduces Vipshop’s VTP (VIP Test Platform), detailing its architecture, fine‑grained TestNG support, integration with Jenkins, CI and QAMP, and the platform’s features for scheduling, reporting, and future scalability in a rapidly growing e‑commerce environment.
