All Articles

140391 articles · Page 6978 of 7020
Qunar Tech Salon
Qunar Tech Salon
May 4, 2015 · Databases

Comparing MySQL and PostgreSQL Counter Queries

This article compares two SQL counter queries, presenting a detailed MySQL version with CASE statements and variable counters alongside a concise PostgreSQL version using ROW_NUMBER, and includes an explanation of the differences and a brief author biography.

ComparisonPostgreSQLSQL
0 likes · 3 min read
Comparing MySQL and PostgreSQL Counter Queries

Visualization in Operations: Service Delivery and Service Metrics

The article explains how visualizing both service delivery and service metrics is essential for modern operations, describing the evolution from ITIL processes to DevOps automation, continuous delivery of infrastructure and applications, and data‑driven measurement techniques that enable consistent, agile, and measurable operational performance.

AutomationData-DrivenService Delivery
0 likes · 10 min read
Visualization in Operations: Service Delivery and Service Metrics
Qunar Tech Salon
Qunar Tech Salon
May 3, 2015 · Databases

Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar

The article analyzes a slow PostgreSQL query that joins multiple tables to fetch flight numbers, compares several alternative query formulations with their execution plans, and presents a final solution using array aggregation to achieve sub‑millisecond performance despite existing indexes.

Database PerformanceIndexesPostgreSQL
0 likes · 7 min read
Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
May 3, 2015 · Backend Development

Designing Scalable Netty Push Services: Real‑World IoT Lessons

This article analyzes common push‑service questions, presents a memory‑leak case from an IoT MQTT middleware, and provides detailed Netty design guidelines—including file‑handle limits, CLOSE_WAIT handling, thread and task management, heartbeat tuning, buffer allocation, memory‑pool usage, logging pitfalls, TCP and JVM optimizations—to help engineers build stable, high‑performance million‑connection push servers.

IoTNettyPerformance Tuning
0 likes · 23 min read
Designing Scalable Netty Push Services: Real‑World IoT Lessons
Alibaba Cloud Infrastructure
Alibaba Cloud Infrastructure
Apr 30, 2015 · Operations

Understanding and Tuning Linux TCP Queue and Buffer Parameters

This article explains the Linux TCP connection‑establishment, packet‑receive, and packet‑send paths, categorizes related kernel parameters such as backlog, SYN‑cookie, ring buffers, and socket buffers, and provides practical commands and guidelines for optimizing network performance on servers.

BufferLinuxNetwork Performance
0 likes · 13 min read
Understanding and Tuning Linux TCP Queue and Buffer Parameters
MaGe Linux Operations
MaGe Linux Operations
Apr 30, 2015 · Information Security

How to Build a Private CA with OpenSSL: Step‑by‑Step Guide

This article explains why encrypting network traffic is essential, introduces OpenSSL’s cryptographic components, and provides a detailed, command‑line tutorial for creating a private Certificate Authority, issuing certificates, and handling revocation within a LAN environment.

Certificate AuthorityEncryptionOpenSSL
0 likes · 8 min read
How to Build a Private CA with OpenSSL: Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
Apr 30, 2015 · Fundamentals

What Is DNS? A Complete Guide to the Domain Name System

This article explains the fundamentals of DNS, covering its purpose, hierarchical structure, key concepts like FQDN and resource records, query mechanisms, server types, ports, and the step‑by‑step process browsers use to resolve domain names into IP addresses.

Domain Name SystemFundamentalsInternet
0 likes · 8 min read
What Is DNS? A Complete Guide to the Domain Name System
Suning Technology
Suning Technology
Apr 30, 2015 · Cloud Computing

Suning CloudStack Salon: Open‑Source Cloud, Docker, and Storage Insights

The April 25, 2015 Suning Cloud Computing sharing session in Nanjing gathered around 200 cloud enthusiasts and developers, featuring talks on CloudStack’s open‑source contributions, troubleshooting, Docker adoption, object storage practices, custom network design, and distributed storage systems, followed by Q&A and a group photo.

CloudStackDistributed storageDocker
0 likes · 6 min read
Suning CloudStack Salon: Open‑Source Cloud, Docker, and Storage Insights
MaGe Linux Operations
MaGe Linux Operations
Apr 29, 2015 · Operations

Achieve Real-Time File Sync with rsync + inotify: Step-by-Step Guide

Learn how to replace traditional backup methods with rsync and inotify for fast, secure, incremental file synchronization, covering rsync fundamentals, command options, server and client configuration, inotify monitoring scripts, and testing procedures to achieve real‑time data replication between Linux servers.

Real-time Syncbackupinotify
0 likes · 9 min read
Achieve Real-Time File Sync with rsync + inotify: Step-by-Step Guide