A front‑end login slowdown was traced to a MySQL UPDATE that ran for 40 seconds because a varchar column’s charset conversion forced a full‑table scan, and the article walks through the logs, tests, and the fix of unifying the column charset to UTF‑8.
Optimistic locking replaces heavyweight pessimistic locks with a version‑based approach, allowing concurrent reads and only checking a version or timestamp during updates, which reduces lock contention, improves performance under high concurrency, but requires careful handling of external updates to avoid dirty data.
This article explains Flink's core execution‑resource concepts—including operator chaining, task slots, slot‑sharing groups and co‑location groups—detailing their conditions, API controls, internal implementation, and how they together maximize throughput and resource utilization in stream processing.
This article explores the broad concept of user experience, explaining how the system, user, and environment interact, and examines how usage context, habits, and website design elements such as usability, usefulness, findability, accessibility, desirability, credibility, and value collectively determine whether a product feels satisfying and effective.
The article details the design, components, and operational challenges of Youzan's unified log platform, describing its multi‑layer architecture, ingestion methods using rsyslog/logstash and Flume‑NG, Kafka‑based log center, processing pipelines with Storm/Spark, and storage in HDFS and Elasticsearch.
This article presents a comprehensive set of MySQL performance optimization techniques for web applications, covering query cache usage, EXPLAIN analysis, LIMIT 1, proper indexing, join optimization, avoiding ORDER BY RAND(), selective column retrieval, proper primary keys, ENUM usage, PROCEDURE ANALYSE, NOT NULL fields, prepared statements, unbuffered queries, IP storage as unsigned int, fixed‑length tables, vertical partitioning, batch DELETE/INSERT, column size reduction, storage engine selection, ORM usage, and careful handling of persistent connections.
This article details Medium’s evolution from its initial AWS‑based backend stack to a sophisticated, service‑oriented architecture that leverages Node.js, Go, DynamoDB, Redis, Aurora, Neo4j, Spark, and CI/CD pipelines to support millions of users.
The article introduces MyCat, an open‑source distributed database middleware that provides transparent sharding, multi‑backend support, AI‑driven catlet extensions, and advanced read‑write splitting to enable low‑cost migration of single‑node databases to cloud environments while addressing performance and scalability challenges.
This article explains how Uber built a full‑stack data‑visualization team that uses open‑source React and WebGL libraries to turn massive GPS streams into real‑time map analytics, public data stories, and reusable visual components for internal and external users.
The article explains why Oracle bad block incidents demand scenario‑driven handling, outlines interview questions, describes the pitfalls of inspecting each alert log, and advocates promptly switching to disaster‑recovery and using backups to restore service, while sharing real‑world cases and practical DBA advice.
This article compares the open‑source Ceph storage system and Huawei's OceanStor 9000 commercial SDS, detailing their service components, software stacks, OpenStack compatibility, and differing strengths in scalability, client architecture, and management for cloud and enterprise storage scenarios.
A MySQL fatal error citing Errcode 28 can stem from inode exhaustion caused by a flood of cron-generated emails, not just lack of disk space, and the article walks through diagnosing the issue with df, df -i, and locating the offending Postfix maildrop directory.
This tutorial details the complete process of moving a single‑node DB2 v9.7 PHSDB database to K‑DB11G, covering schema‑to‑user mapping, object conversion, constraint handling, identity column emulation, manual adjustments for views/functions, and the export‑import scripts required for data migration.
This article compiles a comprehensive set of Oracle SQL queries that monitor wait events, rollback segment contention, tablespace and file system I/O ratios, SGA hit rates, dictionary cache efficiency, MTS activity, fragmentation, and other critical performance metrics, often with recommended threshold values.
Learn how to create stunning CSS3 3D effects—from basic flip‑card animations to full‑page book‑turning and pop‑up book designs—by mastering perspective, transform‑style, and proper 3D hierarchy, while understanding browser support limits and performance considerations.
Frame‑by‑frame animation, also known as sprite animation, can be implemented on the web using three main techniques—GIF, JavaScript, and CSS3 animation—each with its own workflow, advantages, and limitations, and the article walks through practical examples, code snippets, and tips for optimal performance.
This article details Uber's transition to a modular microservice architecture, the RFC process for new services, and the design, implementation, and operational lessons learned from creating Tincup, a high‑performance currency and exchange‑rate service supporting dozens of currencies worldwide.
This article explains how TiKV implements multi-version concurrency control (MVCC) on top of RocksDB and details its two‑phase commit transaction model, including Prewrite and Commit phases, Percolator‑style optimizations, lock handling, conflict resolution, and garbage‑collection strategies.
This article examines three common TCP issues—missing client‑side socket timeouts leading to monitor‑killed processes, excessive TIME_WAIT sockets after service failures and their kernel tunables, and 40 ms keep‑alive latency caused by Nagle and delayed ACK—explaining kernel behavior and offering practical configuration fixes.
The article traces the progressive evolution of a mobile app's architecture—from an initial MVC structure that quickly becomes tangled, through modular designs using CocoaPods, to advanced decoupling techniques like the middleman pattern and URL routing—highlighting practical lessons for small teams and larger enterprises.
