This article explains how Oracle's parallel processing feature can accelerate data‑intensive queries by configuring session, table, or hint‑based parallelism, shows the degree‑of‑parallelism formula, and presents experimental results that compare execution times under different settings.
During a beta release, a .NET system faced slow page responses, time‑outs, high server load, and database deadlocks, prompting a systematic performance‑tuning process that covers mindset, problem reproduction, classification, tool‑based diagnosis, and concrete code, SQL, and algorithm optimizations with detailed case studies.
This article explains how Stack Overflow handles hundreds of millions of page views each month with only 25 servers by using vertical scaling, extensive caching layers, efficient .NET code, careful database design, and robust deployment and monitoring practices.
A developer recounts a MySQL master‑slave replication lag issue that caused approved activity data to disappear, walks through the investigation steps, shows the faulty PHP code, and offers practical fixes to avoid similar pitfalls in future database designs.
An in‑depth case study of a no‑card payment system reveals common backend pitfalls—database deadlocks, long‑running transactions, thread‑pool misuse, excessive logging, and missing monitoring—and demonstrates practical fixes using Redis locks, refined transaction scopes, controlled thread pools, and optimized logging to dramatically improve scalability and reliability.
This guide explains Oracle SEQUENCE objects—how they generate numeric IDs, the full CREATE SEQUENCE syntax, practical usage with NEXTVAL and CURRVAL, alteration options, querying via data‑dictionary views, and safe removal—complete with runnable SQL examples.
This article explains MySQL's transaction fundamentals, the ACID properties, common concurrency problems such as dirty reads, non‑repeatable reads and phantom reads, and demonstrates each isolation level with step‑by‑step command‑line examples and recommendations for real‑world applications.
This article explains how WCDB for Android simplifies encryption with SQLiteCipherSpec, enables seamless data migration, provides a custom FTS3/4 tokenizer with dynamic ICU loading, and offers log redirection and performance monitoring tools, plus an optimized cursor implementation for high‑performance mobile apps.
After initially focusing on a distributed MySQL system, the author describes why open‑source HA solutions like MHA were unsuitable, then details the design and implementation of a 4‑layer NAT‑based proxy (RDS) and a more advanced 7‑layer application‑level proxy, highlighting features such as authentication, load balancing, read/write splitting, and multi‑datacenter awareness.
This article explains how to design concise Redis keys that enable multi‑condition and fuzzy queries by using a structured naming convention, demonstrates the implementation within a Java SSM project, and provides code snippets for key assembly, querying, and deletion.
This article explains core database concepts—including entities, attributes, relationships, the three normal forms, primary and foreign key rules, and the five main constraints—providing clear examples and visual diagrams to help developers design robust relational schemas.
This article introduces Common Table Expressions (CTE) in SQL, explains how they improve query readability and enable writable temporary tables, demonstrates multi‑table modifications, advanced CRUD scenarios, implements a ring‑buffer using CTE, and discusses performance benefits and potential pitfalls.
This article explains why Redis high‑availability is essential, details the inner workings of Redis Sentinel, compares several HA architectures—including Sentinel with DNS or VIP, client‑side Sentinel, Keepalived/Haproxy, Redis Cluster, Twemproxy, and Codis—lists their pros and cons, and shares practical best‑practice recommendations for building reliable Redis deployments.
This comprehensive guide explains what a database is, distinguishes relational and non‑relational types, walks through MySQL client‑server architecture, details SQL syntax for creating, querying, altering, and dropping databases, tables, and data, and resolves common Chinese character‑set and collation issues with practical commands and examples.
This article provides a comprehensive guide to Oracle Listener, covering its core functions, how to operate it via lsnrctl commands on Windows, detailed configuration of listener.ora for static and dynamic registration, and best practices for ensuring high availability and load balancing.
Oracle character sets define how byte data maps to symbols, with NLS_LANG controlling client language, territory, and charset; this guide explains the components, naming conventions, differences between database and client sets, export/import conversion processes, and methods to view or modify character sets safely.
This comprehensive SQLite tutorial walks beginners through what SQLite is, how to install it on Windows and Linux, essential syntax, CRUD operations, database objects, functions, and language-specific programming interfaces, providing step‑by‑step instructions and visual aids for practical mastery.
This article compiles 38 practical Oracle SQL tuning techniques—from ordering tables and rewriting WHERE clauses to using indexes, avoiding SELECT *, leveraging DECODE, replacing HAVING with WHERE, and preferring TRUNCATE over DELETE—each illustrated with clear examples to help developers write faster, more efficient queries.
This article explains Oracle instance recovery, detailing when it is needed, how checkpoints and SCNs are recorded during clean and abnormal shutdowns, and the step‑by‑step forward‑roll and rollback process performed by SMON to restore database consistency after a crash.
This article explains MySQL InnoDB deadlocks, describes how the engine detects and resolves them by rolling back a transaction with error 1213, and walks through real‑world examples and log analyses to illustrate the causes and troubleshooting steps.
This guide details the step‑by‑step process of moving a Windows‑based Oracle 11g RAC cluster to a Linux environment, focusing on building DataGuard between a single‑instance source and a RAC target, adjusting IPs, updating parameter files, handling tnsnames.ora, password files, RMAN backups, and finalizing the standby configuration.
This guide demonstrates how to configure a highly available Redis deployment using master‑slave replication, Redis Sentinel for automatic failover, and virtual IP (VIP) migration, covering environment setup, configuration files, firewall adjustments, testing procedures, and client connection strategies.
This article examines common performance and reliability problems encountered in Redis master‑slave deployments—such as AOF and SAVE settings, key count mismatches, client output buffer limits, replication backlog size, and node liveness checks—and provides concrete configuration commands and tuning strategies to improve stability, especially in cloud environments.
This article explains how Oracle's bind variable peeking influences execution plan selection, demonstrates the performance differences between full table scans and index scans with skewed data distributions, and provides practical methods—including 10046 events, v$sql_bind_capture, and AWR views—to capture and analyze bind variable values for better SQL tuning.
This article explains what NoSQL means, compares it with traditional SQL databases, and walks through creating a lightweight Python key‑value store with TCP/IP commands, illustrating schema design, indexing, query examples, and the full source code for a toy NoSQL system.
This article details Alibaba's middleware team's exploration of time‑series data characteristics, real‑world monitoring scenarios, the limitations of traditional databases, and the evolution of their custom HiTSDB solution that combines inverted indexing, high‑compression algorithms, and distributed aggregation to meet massive write and query demands.
The article explains high‑availability concepts, compares typical MySQL HA architectures—including replication, clustering, and Paxos‑based solutions—and presents UDB’s dual‑master semi‑synchronous design with a Proxy layer that ensures automatic failover, data consistency, and operational resilience.
This article presents an A‑to‑Z glossary of common big‑data terminology, offering concise definitions for concepts such as aggregation, algorithms, analytics, AI, cloud computing, databases, machine learning, and more, to help readers quickly grasp the core vocabulary of the big‑data ecosystem.
This article examines common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery‑driven updates, mixed ordering, EXISTS clauses, condition push‑down, early result narrowing, and intermediate result push‑down, and provides rewritten SQL examples that dramatically reduce execution time from seconds to milliseconds.
This article explains how Oracle uses various lock types—including DML, DDL, and internal locks—to protect shared resources, details the lock manager workflow, describes the three lock components and lock modes, and shows practical SQL examples of transaction handling and blocking detection.
This article reviews core database high‑availability technologies—including IBM DB2 HADR, HACMP clustering, SQL and Q replication, storage‑level disaster recovery, and DPF considerations—explaining their mechanisms, suitable scenarios, and practical deployment tips for enterprise environments.
WeChat reduced its SQLite chat‑record corruption rate by over 50% by optimizing storage space, enforcing full file synchronization (including iOS fullfsync), and implementing a dual‑backup strategy for the master table with CRC checks and pre‑allocated space, dramatically improving repair success.
The Meituan‑Dianping technical salon showcases its DevOps automation philosophy by presenting three core tools—DB automation platform, service tree, and Puppet web management—while also featuring Shanghai Zhaogang Network’s CMDB experience, illustrating how rapid O2O growth drives the need for fast, reliable, and scalable operational automation.
This article explains Greenplum's MPP architecture, master‑segment design, high‑availability, interconnect network, rich management tools, parallel query planning, data loading techniques, and additional capabilities such as LDAP authentication and resource queues, demonstrating why it is a strong next‑generation big‑data query engine.
This guide walks through preparing three CentOS 6.7 machines, installing MySQL 5.7.17, configuring my.cnf, disabling firewalls and SELinux, creating replication users, exporting databases, setting up multi‑source replication with GTID, and verifying data consistency across two masters and one slave.
This guide presents practical Linux and server administration commands, covering log cleanup, nginx IP analysis, tcpdump capture, Python date formatting and string reversal, subprocess execution, multiprocessing, iptables port forwarding, cron scheduling, file relocation, RAID concepts, Oracle backup strategies, port checking, Apache MPM modes, and monitoring tool comparisons.
This guide walks through the evolution of a small .NET‑based e‑commerce system, covering its initial LAMP‑style setup, detailed backend architecture, logging and monitoring solutions, master‑slave database design, shared‑storage image server, mobile M‑site construction, capacity estimation methods, and caching strategies.
To prevent duplicate operations such as repeated inserts, updates, or message sends in high‑traffic applications, this article explains the concept of idempotency and outlines practical techniques—including read‑only APIs, MVCC with optimistic locking, deduplication tables, distributed locks, safe deletes, unique indexes, UUID‑based request tracking, and state‑machine safeguards.
This article explains how MySQL binlog timestamps are derived from the THD start_time, why all events in a transaction share the same timestamp, how exec_time is calculated, and demonstrates the effect of autocommit and manual commit on binlog timing through concrete examples and source code analysis.
Learn how to store, retrieve, and manipulate JSON data in Redis using the ReJSON module, covering basic commands, advanced field operations, numeric updates, and step‑by‑step installation on Redis 4.0+, with practical code examples and configuration instructions.
This article provides a comprehensive overview of RocksDB, covering its origin, design goals, core architecture components, key features such as APIs, compression strategies, durability mechanisms, backup and replication support, as well as tooling, testing, and performance characteristics.
This tutorial demonstrates how to build a single, reusable SQLite library in Free Pascal using CodeTyphon, covering platform‑specific APIs, export conventions for Android, iOS, PC, and detailed compilation and usage examples across Android, iOS, macOS, Linux, and Windows.
This article explains the logical and physical execution order of SQL statements, offers practical tips for returning only needed data, reducing redundant work, using temporary tables wisely, optimizing subqueries and indexes, and provides concrete code examples to improve query performance.
The article recounts a troubleshooting session where a 12c Oracle standby database failed to connect via TNS, presenting the ORA-12514 error, analyzing listener and tnsnames configurations, uncovering an outdated 11g ORACLE_HOME, and detailing the steps to switch homes and restart the listener to resolve the issue.
This article explains why Redis data must be persisted, compares the two built‑in methods—RDB snapshotting and Append‑Only File (AOF)—and provides practical configuration tips, command usage, performance considerations, and verification tools for reliable backup and recovery.
The benchmark shows that while InnoDB delivers roughly 30 % higher insert throughput than TokuDB, the TokuDB engine achieves 10‑16× storage compression with comparable import times, minimal impact from log‑sync settings, and zlib emerging as the preferred compression algorithm for balanced performance and CPU usage.
This article introduces Redis's five core data structures—String, List, Set, Hash, and Sorted Set—detailing their characteristics, common commands, additional operations, and typical use cases, providing a comprehensive guide for developers working with Redis.
This article explains Redis as an open‑source in‑memory data store, compares its main deployment modes—single instance, Redis Cluster, and Redis Sentinel—detailing their architectures, replication, sharding, failover mechanisms, client options, and backup strategies such as RDB and AOF.
This article presents the motivation, architecture, functional and interface layers, storage design, and performance evaluation of CFL, a MySQL plug‑in storage engine created by Ctrip to provide a high‑throughput, SQL‑based time‑series database while preserving existing MySQL operational practices.
This article explains the fundamental ACID properties of database transactions, details the four isolation levels—READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE—illustrates common concurrency issues like dirty, non‑repeatable, and phantom reads with examples, and shows how Spring’s transaction propagation and additional features can be leveraged to manage them effectively.
This article presents the design, architecture, and performance evaluation of CFL, a MySQL time‑series storage engine developed by Ctrip, detailing its functional and interface layers, storage strategy, and benchmark results compared with InnoDB, MyISAM, and other engines.
In this interview, veteran database director Zhou Yanwei shares his ten‑year MySQL journey, the founding of the China MySQL User Group, his views on why MySQL thrives, the essential DBA spirit, learning strategies, and predictions for MySQL’s future in enterprise environments.
This article provides a comprehensive, step-by-step tutorial for downloading, installing, and configuring three MySQL 5.7.17 instances on a single server, creating users, setting up Group Replication, adding members, and verifying data synchronization across the replication group.
This article dissects YouTube's massive infrastructure, detailing the basic platform, web and video services, thumbnail handling, database evolution, CDN usage, and data‑center strategies that enable over half a billion daily video clicks with a surprisingly small engineering team.
This article examines the surprising behavior of Oracle when adding NOT NULL columns with default NULL values, explains how different Oracle versions handle the constraint, demonstrates test cases, and clarifies the underlying data‑dictionary mechanism that leads to unexpected query results.
This comprehensive guide explains every major SQL join type—including CROSS, INNER, OUTER, FULL, SEMI, ANTI, LATERAL, and MULTISET—detailing their logical behavior, practical use‑cases, alternative syntaxes, performance implications, and visual examples across PostgreSQL, Oracle, and SQL Server.
This article walks through a puzzling MySQL InnoDB deadlock case, showing the table schema, the conflicting transactions, how to read the SHOW ENGINE INNODB STATUS output, and the reasoning that reveals why the deadlock occurs and how to diagnose similar issues.
This guide walks through building a SQL Server Failover Cluster on QCloud, covering architecture choices, network layout, required roles like DTC, step‑by‑step installation on two nodes, configuration of virtual IPs, and recommendations to prefer AlwaysOn or PaaS solutions for production reliability.
This guide explains why production SQL errors appear despite successful local tests, shows how to proactively log and monitor PHP‑MySQL errors, and provides concrete solutions for frequent MySQL error codes with example code and step‑by‑step troubleshooting tips.
A production page stalled because a complex SQL query took over 20 seconds, leading the author to dissect joins and nested subqueries, pinpoint the bottleneck, validate assumptions with quick tests, and share practical lessons on query optimization and table‑size effects.
Learn the fundamentals of Object‑Relational Mapping (ORM) and how to use Python’s SQLAlchemy library to define models, initialize sessions, create tables, and perform CRUD operations, with clear examples and code snippets that illustrate switching databases and advanced query techniques.
In this step‑by‑step guide, Microsoft MVP Li Sida shows how to build a two‑node SQL Server cluster on Tencent Cloud by creating a private VPC, setting up an Active Directory domain controller, configuring shared storage, joining the SQL nodes, and addressing common Chinese‑cloud quirks such as sysprep and SID duplication.
This article presents a detailed benchmark comparing PostgreSQL 9.6 and MySQL 5.7 on identical high‑end hardware using pgbench and SysBench, describing the test methodology, configuration tweaks, performance results for point selects and OLTP workloads, and concluding that both systems scale to modern demanding workloads.
The latest MySQL release introduces a transactional data dictionary, role‑based account permission management, multiple InnoDB enhancements—including stable auto‑increment counters, memcached multi‑key support, dynamic deadlock detection, shared temporary tables, and NOWAIT/SKIP LOCKED options—plus advanced JSON operators, aggregation functions, pretty‑print utility, and optimizer features such as hidden and descending indexes.
The article analyzes the massive scale of Chinese New Year red‑packet activity on WeChat, presents usage statistics, and explains the backend architecture—including distributed KV storage, cache‑layer atomic operations, and database transaction handling—that enables high‑throughput red‑packet distribution.
Alibaba's Double 11 festival broke sales records with 120.7 billion RMB, and the article details the backend engineering challenges and solutions—such as database sharding, SQL optimization, multi‑level caching, and modular architecture—that enabled the platform to handle millions of orders per second while preserving data consistency and performance.
This article examines Youku's massive scale by detailing its front‑end framework, server hardware, MySQL replication, vertical partitioning, sharding, and caching strategies, illustrating how the platform achieved high performance and reliability for billions of daily page views.
The 2016 China Oracle Database Usage Report, based on health‑check data from 1,841 instances across 18 industries, provides a multi‑dimensional analysis of version distribution, operating system choices, host and storage configurations, data scale, high‑availability setups, and top failure types, offering a comprehensive view of Oracle adoption and challenges in the Chinese market.
The 2016 China Oracle Database Usage Report, based on health checks of 1,841 Oracle instances from 485 users across 18 industries, provides a multi‑dimensional analysis of version distribution, system configurations, data scale, high‑availability adoption, and common fault patterns.
This article explains MySQL's asynchronous, semi‑synchronous, and Group Replication mechanisms, compares their trade‑offs, details Group Replication’s certification‑based full‑sync workflow, lists its features and limitations, and provides a complete configuration and maintenance guide for a three‑node cluster.
This article presents five useful Oracle SQL techniques—including string concatenation, DISTINCT, WHERE clauses, flexible COUNT usage, and selecting only necessary columns—to improve query readability, eliminate duplicate rows, and enhance overall database performance.
This article dissects the InnoDB transaction structure defined in storage/innobase/include/trx0trx.h, detailing each of the 63 variables—including their types, purpose, and interaction with MySQL’s transaction coordinator—so readers can grasp how InnoDB ensures data consistency and manages transaction state.
This article explains why MySQL master‑slave replication is essential for high availability, describes the replication mechanism, provides detailed configuration commands for both master and slave servers, and shows how to test and recover synchronization when inconsistencies occur.
This article comprehensively explains MySQL's sorting mechanisms, including various sorting modes, index-based optimizations, external sorting algorithms, trace analysis, and configuration parameters, providing practical guidance for developers to diagnose and improve query performance.
The article dissects Redis’s architecture by examining its single‑threaded reactor network model, core data structures and memory‑management tactics, AOF/RDB persistence mechanisms, and master‑slave, Sentinel, and Cluster multi‑node strategies, highlighting how each design choice balances speed, memory usage, and system complexity.
MariaDB Columnstore, the newly integrated InfiniDB storage engine, brings column‑store analytics to MySQL, offering P‑scale data handling, distributed deployment, and impressive performance gains over InnoDB, with detailed installation steps, kernel tuning, command‑line administration, and optimization tips for production environments.
This article explains how MariaDB, a community‑driven fork of MySQL, maintains full compatibility while adding new storage engines, advanced replication, performance‑boosting features like XtraDB and thread pools, and why many organizations consider it a superior replacement for Oracle‑owned MySQL.
This article walks through a real‑world MySQL performance case where a complex view caused slow queries, explains step‑by‑step analysis, shows how redundant joins and Cartesian products were eliminated with CTEs and EXISTS, and demonstrates how the execution time dropped from 2.5 s to 1.8 s.
The article presents a serverless‑style solution that replaces a heavy backend with a lightweight, automatically generated CRUD layer, detailing RESTful API conventions, extensions for batch operations, query parameters, foreign‑key handling, and a Rails‑based code‑generation pipeline to streamline development of a high‑availability supply‑chain system.
This guide explains the two main database career tracks—DBA (database administration) and database development—covers the challenges for fresh graduates, discusses certification value, and offers practical methods for mastering database theory and hands‑on skills.
This article explains Oracle 12c's In‑Memory Column Store feature, its compression levels, step‑by‑step testing results for full scans and joins, a real‑world production case from Zhejiang Mobile, and practical maintenance commands to keep the in‑memory area healthy.
This guide explains how to use the Perl‑based MMM tool to monitor and manage MySQL master‑master replication, covering its advantages, working principle, detailed server configurations, connection steps, master‑slave testing, and high‑availability failover demonstrations.
The article presents a comprehensive set of performance‑optimization strategies—from code‑level refactoring, SQL tuning, and caching patterns to asynchronous processing, NoSQL selection, JVM and multithreading tuning—alongside real‑world cases that cut job runtimes from over 50 minutes to under 15 minutes and dramatically reduce database load.
This guide from the 360DBA team explains how to select the appropriate MongoDB PHP driver version based on PHP and server releases, shares real‑world case studies of version issues, and provides step‑by‑step instructions for downloading, compiling, installing, and verifying the driver.
This article summarizes common Redis cache update problems, compares four update approaches—including proactive, passive, and pre‑loading methods—and recommends a pre‑load strategy with key versioning to avoid data loss, improve performance, and reduce memory waste.
This guide walks through the reasons for sharding in MongoDB, explains the sharding architecture, and provides detailed commands to configure config servers, shard servers, and mongos, add shards, enable sharding on databases and collections, insert test data, and verify successful data distribution across shards.
An in‑depth overview of NoSQL databases explains the limitations of traditional relational systems, details ACID properties, introduces the CAP theorem and BASE model, compares RDBMS with NoSQL, outlines advantages, disadvantages, history, classifications, and real‑world usage examples.
This article explains MongoDB’s key features, compares its advantages and disadvantages, and provides a detailed, step‑by‑step guide to installing, configuring, and verifying a replica set on CentOS 6.6, including commands for package installation, configuration file editing, service startup, node addition, and data synchronization verification.
This guide walks through extending MySQL 5.6.32 by adding a new SQLCOM_STOP_SLAVES command that stops all replication slaves, detailing modifications to lex.h, sql_cmd.h, sql_yacc.yy, sql_parse.cc, and mysqld.cc, along with compilation tips and troubleshooting steps.
This article compiles frequently used MySQL SQL commands—including data migration, multi‑table updates, conditional updates, aggregation inserts, and various ALTER TABLE operations such as adding indexes, dropping and adding columns—to serve as a practical reference for database developers.
This article examines the common causes of high read latency in HBase—such as full GC, region‑server imbalance, low write throughput, and inefficient client settings—and provides concrete optimization steps for the client, server, column‑family design, and HDFS layers to dramatically improve performance.
The 2016 Global Agile Operations Summit in Shanghai concluded with a series of expert sessions covering agile DevOps trends, cloud‑native automation platforms, database performance tuning, container orchestration, and real‑world case studies from leading companies, followed by the award ceremony honoring ten MVPs who drove innovation across operations and infrastructure.
Greenplum is an open‑source, massively parallel processing (MPP) database built on PostgreSQL, offering ANSI‑SQL compliance, distributed ACID transactions, linear scalability, polymorphic storage, advanced optimizers, and extensive ecosystem integrations, making it suitable for large‑scale data warehousing, analytics, and big‑data workloads.
This guide walks you through configuring a simple Redis master‑slave setup, covering the benefits, step‑by‑step file modifications, essential replication directives, testing procedures, and common pitfalls to ensure high availability and read/write separation.
When an Oracle DBMS_JOB’s NEXT_DATE jumps to the far‑future date 4000‑01‑01, it indicates the job has failed repeatedly and been marked broken; this article explains the underlying reasons, examines error logs, and provides step‑by‑step commands to diagnose and restart the job.
The article uses a warehouse‑robot analogy to illustrate how SQL injection works, showing how mixing user‑supplied data with commands lets attackers alter database queries, and explains that parameterized queries separate code from data to prevent such vulnerabilities.
This guide compiles a comprehensive set of Oracle SQL statements and explanations for detecting fragmented tables, index fragmentation, high clustering factor tables, session and process mapping, DML lock analysis, DDL lock inspection, active SQL tracking, resource usage statistics, and various performance‑related metrics, helping DBAs diagnose and tune database behavior efficiently.
A real‑world case study shows how a seemingly simple intersect query that took 20 seconds was optimized to 10 seconds by analyzing execution plans, rewriting the SQL, exploring parallel execution, and ultimately redesigning the business logic with a new timestamp column to enable incremental checks.
This guide provides a comprehensive checklist and scripted procedure for safely downgrading Oracle Database 12c (Standard or Enterprise Edition) to prior releases such as 11.2.0.3, 11.2.0.2, or 11.1.0.7, covering prerequisites, command‑line steps, post‑downgrade validation, and common pitfalls.
This article compiles over forty practical Oracle SQL queries covering date manipulation, server information, data dictionary lookups, database administration, performance monitoring, and utility functions, providing developers with ready-to-use commands to streamline everyday database tasks.
