This guide explains how to view MySQL temporary table statistics, interpret key metrics such as created_tmp_tables and created_tmp_disk_tables, and adjust tmp_table_size to keep temporary tables in memory, thereby improving query performance and reducing disk I/O.
This article walks you through preparing Docker, building a csphere/php-fpm:5.4 image with custom configuration files, creating a csphere/mysql:5.5 image, using ONBUILD, managing volumes, and running containers to demonstrate persistent data across container lifecycles.
Facebook’s data warehouse, storing over 300 PB and growing by 600 TB daily, transitioned from the RCFile format to an optimized ORCFile implementation, achieving 5‑8× better compression and up to three‑fold faster write performance while maintaining high read efficiency.
This article explains what power testing is, why it matters for mobile apps, and provides step‑by‑step hardware and software methods—including custom measurement devices, Android battery stats, and adb commands—to evaluate and optimize an app's energy usage.
This guide explains how the thread_cache_size setting in MySQL caches idle threads, how to monitor thread creation with Thread_created, and why increasing the cache size can reduce resource consumption and improve response times.
This article explains the three types of SQL joins—inner, outer, and cross—detailing their variations such as equi‑join, non‑equi‑join, natural join, left/right/full outer joins, and provides clear example queries and result illustrations to help readers understand how to combine tables effectively.
This article explains how to configure ACLs and NAT on a campus router, including static global NAT, outbound NAT with Easy‑IP, loopback interface setup, and verification steps to ensure internal users can reach the server via the public IP address.
The article summarizes DockerCon 2015, detailing Docker's rapid growth, roadmap for multi‑container management, plugin and networking architectures, security practices, vendor showcases, and the emerging Open Container Project, providing a comprehensive view of Docker's direction and ecosystem.
First Round Review compiles thirty practical pieces of advice for startup founders, covering personal mindset, product development, team scaling, hiring, marketing, communication, goal setting, and leadership to help entrepreneurs build sustainable and high‑performing companies.
This article objectively examines the concept, definition, origins, development, applications, and potential universality of micro data‑center modules, evaluating their technical advantages, cost implications, and suitability for both large internet enterprises and traditional data‑center environments.
This article explains how retailers can replace costly ETL‑driven vendor systems with a centralized MongoDB‑based service architecture, detailing data models for products, variants, store‑specific pricing, and multi‑facet search, and showing query and indexing techniques to achieve fast, reliable catalog access.
An in‑depth recap of Hong Xiaojun’s QCon presentation reveals how Meipai’s architecture evolved from a minimalist design to a highly scalable, high‑availability system, tackling MySQL bottlenecks, cache challenges, monitoring, CDN resilience, and technology migrations to support rapid growth to over a hundred million users.
The article outlines four key dimensions of operations value—efficiency, quality, cost, and security—explaining how each contributes to business outcomes, the challenges of implementation, and why investing in operations is essentially buying insurance against costly failures.
This guide explains the meaning of MySQL's Open_tables and Opened_tables status variables, shows how to check them, and provides recommended ratios and steps to adjust the table_cache setting for better database performance.
The article outlines practical techniques for debugging live Java systems, emphasizing comprehensive distributed logging, global exception handling, proactive JStack usage, BTrace tracing, and custom JVM agents to quickly identify and resolve production issues.
This article explains MySQL architecture design for 24/7 online services, covering business analysis of read‑write patterns, common deployment models, consistency levels, data migration, sharding strategies (vertical, horizontal, and business‑level), and cluster scaling for high availability.
This article explains how logs—simple, append‑only, time‑ordered records—serve as the core abstraction behind databases, distributed systems, data integration pipelines, and modern stream‑processing platforms such as Kafka and Hadoop, illustrating their design, scalability, and practical challenges.
The article analyzes the challenges of scaling network devices to handle ten‑million concurrent connections (C10M) and describes Alibaba's AGW solution, which uses lock‑free data planes, hugepages, NUMA‑aware memory placement, and user‑space NIC drivers to achieve high‑performance four‑layer load balancing.
This article details a practical case study of using Docker to build a continuous delivery pipeline for a logistics‑industry portal, covering project background, challenges, Docker‑based CI integration, automated deployment strategies, image layering, role‑based scripts, and a private registry setup.
This guide explains the two main causes of MySQL error 1040—excessive traffic and a low max_connections setting—shows how to check current and historical connection limits, and provides a rule of thumb for configuring an optimal connection threshold.
