When MySQL's query optimizer cannot use a suitable index for a GROUP BY, it reads the needed rows, creates a temporary table, and performs sorting, which can degrade performance unless sort_buffer_size is properly configured and large result sets are avoided.
This article presents a comprehensive collection of useful Linux command-line utilities—including dstat, screen, tmux, multitail, rsync, and many others—explaining their purposes, typical use cases, and where to obtain them, helping system administrators and developers improve productivity and monitoring.
This article outlines the most common web application security threats—including XSS, SQL injection, CSRF, transmission hijacking, credential leaks, brute‑force attacks, and token theft—and provides practical mitigation techniques such as proper escaping, CSP, parameterized queries, CSRF tokens, HTTPS, HSTS, HPKP, encrypted password storage, two‑factor authentication, and robust token handling.
Worktile’s architecture combines a single‑page AngularJS front‑end with a Node.js/Express backend, leveraging MongoDB, Redis, and ejabberd for real‑time messaging, illustrating how SPA design, modular services, and long‑connection techniques enable a stable, high‑performance team collaboration platform.
This article explains how to implement a scalable timeline for a subscription feed by combining MongoDB storage with a Redis list cache, detailing the data model, query challenges, Redis operations for pushing and trimming statuses, rebuilding strategies, and handling data integrity trade‑offs.
This article demonstrates how to build a minimal TCP server on Unix by configuring inetd or xinetd to redirect socket traffic to a shell script that reads from standard input and writes to standard output, illustrating core networking and scripting concepts.
This article shares practical Docker tips covering CLI enhancements, Dockerfile best practices, networking, volume management, and security measures, helping developers who already know the basics to improve container workflows, reduce image size, and secure their Docker deployments.
This article summarizes a comprehensive ops security talk that breaks down network segmentation, system hardening, and permission management into layered defenses, offering practical guidance on VLANs, ACLs, least‑privilege principles, and account auditing for robust enterprise protection.
This article explains why GROUP BY requires sorting like ORDER BY, how a suitable index can satisfy both operations, and outlines the precise conditions—including single‑table queries, left‑most index prefixes, constant values, and limited aggregates—that allow MySQL to execute GROUP BY using an index scan.
This article provides a comprehensive introduction to Backbone.js, describing its lightweight MVC architecture, core components such as Models, Collections, Views, Events, Sync, Router, and History, and discusses its advantages, suitable scenarios, comparisons with other frameworks, and a real‑world implementation in the Wandoujia PC client.
This article outlines the step‑by‑step design of a friend‑status broadcast service, starting with simple MongoDB queries, moving to message‑driven delivery, adding asynchronous processing with a job queue, and finally handling inactive users through caching and expiration strategies.
This article explains how Google App Engine Datastore works from a programmer's perspective, covering its entity‑based data model, hierarchical structure, query capabilities, comparison with relational databases, and the underlying implementation built on BigTable including entities, indexes, transactions, and backup mechanisms.
The 2015 Suning Big Data Meetup in Nanjing gathered industry experts and researchers to showcase Suning's data platform architecture, Intel's Spark advancements, ZTE's DAP system, and a unified Octopus programming model, emphasizing open knowledge sharing and practical big‑data solutions.
This article explores how Software‑Defined Networking (SDN) has moved from theory to large‑scale deployment in public‑cloud environments, detailing overlay technologies like VXLAN, integration with NFV, practical migration challenges, and real‑world use cases—including automated path probing and controller‑based solutions—while also highlighting a company’s own SDN products.
Learn how to accelerate MySQL sorting by increasing the max_length_for_sort_data parameter, removing unnecessary columns, and enlarging sort_buffer_size, ensuring the server uses the more efficient in‑memory sorting algorithm while avoiding costly data segmentation and temporary tables.
This article explains the motivations behind key‑value stores, compares Redis with the newly created QDB, and details the architecture, dynamic resharding, high‑availability mechanisms, and future improvements of the distributed database solution RebornDB.
This article explains the purpose of the Unix xargs command, demonstrates basic usage for concatenating log files, shows an advanced example for renaming text files to log files using the -I placeholder, and provides a step‑by‑step breakdown of how the command pipeline works.
This guide explains how to use Gearman for Map/Reduce tasks, assign workers to specific CPU cores with taskset, and configure Nginx worker processes with CPU affinity to fully exploit multi‑core servers and improve overall system efficiency.
This article explains what processes and threads are, how they relate, their key differences, and the advantages and disadvantages of each, helping readers grasp why multithreading can boost efficiency while processes offer stronger isolation and fault tolerance.
This guide explains step‑by‑step how to enable the Telnet service on a Huawei switch, set up a time‑range, create a basic ACL that permits a single host, and apply the ACL to the VTY lines to restrict access.
