This article explains Oracle's database architecture, detailing the division between instance and database, the structure of SGA memory, and the roles of key background processes that together enable user interactions and ensure data consistency and recovery.
This guide explains MySQL's four transaction isolation levels, how to change them globally or per session, the impact of autocommit, the different lock types, and provides step‑by‑step InnoDB examples that illustrate the behavior of READ‑UNCOMMITTED, READ‑COMMITTED, REPEATABLE‑READ, and SERIALIZABLE.
The article explains why operators should start from clear goals rather than events, defines meaningful metrics such as user retention and API call volume, shows how to break down and evaluate these metrics, and offers practical advice on data collection, benchmarking, and continuous improvement.
This article presents Meituan Dianping's data‑driven precise marketing architecture, detailing a layered pyramid system, user profiling, budget monitoring, and two real‑world cases—potential user mining and a smart coupon engine—demonstrating how big‑data techniques improve marketing efficiency and ROI.
This article explains how Java exceptions provide a consistent mechanism for identifying and responding to errors, and outlines three key principles—specificity, early throwing, and delayed catching—illustrated with a fictional JCheckbook class to demonstrate robust, user‑friendly debugging practices.
This article explains the motivations behind adopting a hybrid framework for Android apps, outlines the overall architecture, details the WebView loading flow, jump protocol, resource interception, asynchronous image handling, cache version management, and interaction mechanisms, providing practical code examples.
This article explains how to accelerate HTTPS access, reduce computational load, and harden security by applying protocol‑level tweaks such as TCP Fast Open, HSTS, session resumption, OCSP stapling, false start, SPDY/HTTP2, as well as practical deployment strategies like full‑site HTTPS, domain planning, connection reuse, and handling common migration issues.
The author reflects on his journey from senior roles at Baidu and leading tech teams to handing out flyers at a subway station, sharing personal anecdotes about former protégés, hard‑earned entrepreneurial lessons, and why strategic choices like housing and opportunity timing can make or break a career.
This article explains how Netflix uses the open‑source EVCache system, built on Memcached and Kafka, to provide highly reliable, low‑latency caching for its micro‑services architecture across multiple AWS regions, handling billions of objects and millions of requests per second.
This guide explains the complete boot sequence of CentOS 5, 6, and 7, covering GRUB stages, initrd, rc scripts, chkconfig, and the transition to systemd with its units, targets, and systemctl commands, providing practical commands and configuration examples.
Octopux is an open‑source bandwidth monitoring platform designed by Baishan Cloud to deliver 99.9% data integrity, cross‑operator and cross‑country coverage, minute‑level granularity, and horizontal scalability for tens of thousands of devices, addressing the limitations of traditional tools like Cacti.
This comprehensive guide explains Oracle's memory‑management evolution, compares manual SGA/PGA sizing with ASMM, AMM and PGA automatic management, details key parameters and hidden settings, shows how to size SGA, PGA and large pages, and offers practical best‑practice recommendations for DBAs.
This guide explains why the official Redis Cluster tools lack password support, outlines the security risks of an unauthenticated cluster, and introduces a custom management utility that adds password authentication, automates slot migration, and simplifies adding or removing nodes, complete with step‑by‑step testing procedures.
The article explains Diamond, Alibaba’s internal distributed configuration management system, covering its purpose, core features, persistence and disaster‑recovery mechanisms, architectural diagram, and detailed client‑side implementation including subscription workflow and key code components.
This article analyzes why redirecting MySQLdump output can crash the client, explores a GTID_PURGED bug that breaks AUTO_POSITION replication, examines GTID gaps caused by replicate‑do‑db filtering, and explains why TokuDB's OPTIMIZE TABLE appears to increase table size.
This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.
Closing database connections promptly is essential for performance and availability, and this guide explains practical rules, connection‑pool benefits, safe coding patterns, exception handling, and how to diagnose lingering connections using MySQL's SHOW PROCESSLIST command.
This article explains how the Tencent Game DBA team uses Percona's pt-table-sync to detect and automatically repair MySQL replication inconsistencies, achieving up to 30‑fold speed improvements, reducing resource usage, and enabling a data self‑healing service for large‑scale gaming databases.
Discover five surprisingly useful Unix commands—man ascii, cal, xxd, ssh, and mdfind—along with clear examples, output snippets, and practical tips that reveal hidden capabilities for everyday terminal work.
This article explains how to improve HTTPS performance and security by optimizing protocol features such as TCP Fast Open, HSTS, session resumption, OCSP stapling, False Start, and SPDY/HTTP2, discusses computational enhancements like ECC and OpenSSL upgrades, and provides practical deployment guidance for large‑scale web sites.
