Enterprise-level professional community for Database, BigData, and AIOps. Daily original articles, weekly online tech talks, monthly offline salons, and quarterly XCOPS&DAMS conferences—delivered by industry experts.
During Pinterest’s migration of its custom search platform Manas to the PinCompute Kubernetes environment, a rare latency spike—one request per million taking 100 times longer—was traced to cAdvisor’s memory‑intensive smaps scans, revealing hidden resource contention and prompting a targeted fix.
The article recounts a MySQL production incident where an INT auto‑increment column reached its maximum value, causing insert failures, and walks through analysis, three remediation options, a stored‑procedure cleanup, a conversion to BIGINT, performance monitoring, and lessons on concurrency and schema design.
Faced with minutes‑long posting delays and exploding review costs in a fast‑growing social app, the team introduced 24‑hour shift staffing, a local blacklist stored in MySQL, an in‑memory Trie + Aho‑Corasick matcher, Redis‑driven hot updates and a machine‑audit fallback with a feedback loop, dramatically cutting latency, cost and false‑positives.
This guide explains why traditional Retrieval‑Augmented Generation (RAG) struggles with precision, introduces the Model Context Protocol (MCP) as a standardized way for large language models to interact with external data sources, and provides step‑by‑step instructions for integrating MCP with MongoDB using Cherry Studio and VSCode +Cline.
During peak traffic like Double‑11, a message queue can accumulate millions of messages, and simply adding consumer instances only offers temporary relief; this article explains the partition model limits, how to calculate proper partition numbers, fast remediation tactics, and deep consumer‑side optimizations for robust, scalable processing.
The article explains why teams mistakenly use databases merely as storage, shows a real‑world Node.js dashboard that suffered severe latency, demonstrates how moving aggregation and filtering into SQL queries eliminated N+1 and filtering issues, and presents dramatic performance gains and best‑practice guidelines.
From the painful days of hand‑written assembly to the birth of Fortran, the rise of GCC, and the modular revolution of LLVM, this article traces six decades of compiler history, highlighting key breakthroughs, influential figures, and the lasting impact on modern software development.
Netflix built a distributed write‑ahead log (WAL) system to guarantee data consistency, durability, and high‑throughput across services, tackling challenges like data loss, cross‑store entropy, multi‑partition updates, replication, and reliable retry for real‑time pipelines.
This article examines whether Redis can serve as a reliable message queue by comparing its List, Pub/Sub, and Stream features against professional solutions like Kafka and RabbitMQ, covering usage patterns, code examples, performance trade‑offs, persistence, and handling of message loss and backlog.
By rethinking resource requests, eliminating unused workloads, downsizing node types, fine‑tuning autoscaling, and trimming log storage, a team reduced their Kubernetes bill by 40% while keeping the same cloud provider, demonstrating that most cost overruns stem from misconfiguration rather than the platform itself.
