This article explains the classification of Oracle data dictionary objects, demonstrates how to query static and dynamic dictionary tables and views, lists common view families and permission views, and provides numerous SQL examples for inspecting users, tables, indexes, sequences, constraints, and PL/SQL objects.
This guide compiles a comprehensive list of Java interview topics covering fundamentals, object‑oriented features, collections, concurrency, web technologies, databases, Spring framework, ORM tools, Linux, Redis, and project management, providing a solid study roadmap for backend developers.
A DBA on call discovers a sudden traffic spike caused by a few massive hot keys on a storage server, quickly isolates the issue, migrates data, applies throttling and caching, and outlines automation ideas to prevent future overloads, illustrating practical database operations and incident response.
Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.
This article explains the concept of NoSQL, contrasts it with traditional SQL databases, and walks you through building a minimal key‑value NoSQL server in pure Python, covering schema basics, indexing, message parsing, command handling, and practical code examples.
This guide explains how to manually export and import MySQL databases using mysqldump and mysql commands, and provides a Bash script with crontab scheduling for automated daily backups, including necessary path adjustments and usage notes.
This guide walks you through using MySQL's native JSON data type—creating tables with JSON columns, inserting simple and complex JSON values, updating nested structures, generating indexed columns from JSON fields, converting strings to JSON, and a comprehensive list of built‑in JSON functions.
This guide presents thirty‑four practical Oracle SQL optimization techniques—from choosing the most efficient table order and rewriting WHERE clauses to leveraging indexes, avoiding SELECT *, using DECODE, and replacing costly operations—helping developers dramatically improve query speed and resource usage.
This guide walks you through building custom MySQL Docker images, configuring master and slave my.cnf files, launching the containers, creating a replication user, and synchronizing the slave using Docker commands and a ready‑made shell script, all with detailed code examples.
This article explains the concepts of synchronous and asynchronous execution, common concurrency problems such as dirty reads and non‑repeatable reads, and presents practical solutions using Java synchronized blocks, database pessimistic and optimistic locks, Hibernate lock modes, and performance‑optimizing techniques for high‑traffic web applications.
This article walks through a real MySQL case where a simple SELECT query runs slowly despite an existing index, explains why the optimizer chooses a full‑table scan, and demonstrates how adding a covering composite index reduces execution time from 260 ms to 13 ms.
This guide explains MySQL B+Tree index structures, their advantages, how to create primary, unique, ordinary, full‑text, composite and prefix indexes, and provides practical rules and tips for designing efficient indexes, query patterns, and sorting strategies to dramatically improve database performance.
PostgreSQL 10, released after months of beta testing, brings logical replication, declarative table partitioning, higher query concurrency, notable performance gains, stronger SCRAM‑SHA‑256 authentication, and enhanced monitoring and control capabilities, marking a significant evolution for the open‑source database.
Oracle provides several powerful recovery mechanisms—logical backups with the import tool, physical file restoration with incomplete recovery, LogMiner analysis of redo logs, and Flashback Query—each illustrated through a scenario where a mistaken update to the TFUNDASSET table is corrected using step‑by‑step procedures and commands.
The article describes Qunar's 99.99% high‑availability goal for MySQL databases, outlines its HA designs (MMM, PXC, QMHA), compares hot and cold backup methods, discusses common backup challenges, and details Qunar's comprehensive backup and recovery solution including Percona XtraBackup, dedicated backup nodes, centralized management, and consistency verification.
A sudden rain‑triggered alert cascade exposed a mis‑tested data‑migration tool that overwrote production routing, causing a DB success‑rate drop to zero; the incident narrative details detection, root‑cause tracing, and a set of DevOps tool‑development standards to prevent future outages.
This article investigates the performance degradation and lock timeout issues observed in MySQL 5.7.18 partition tables, reproduces the problem with test cases, analyzes InnoDB lock behavior through source code debugging, validates the root cause related to partition scan locking, and confirms it as a regression bug in MySQL 5.7.
This article compiles a comprehensive set of MySQL interview questions covering replication mechanisms, differences between MyISAM and InnoDB, character type nuances, transaction logging, binlog formats, performance tuning, backup strategies, monitoring, consistency checks, and handling large datasets, providing concise answers for each topic.
This article examines the client‑server architecture of Memcached, the slab‑based memory management of both Memcached and Redis, compares their performance, memory efficiency, persistence, data structures and networking models, and presents practical Redis use cases such as caching, ranking, pub/sub, queues, and real‑time analytics.
This guide introduces Django’s fundamentals, explains its MTV architecture, walks through project and app setup, URL routing, views, models, admin customization, database configuration, and essential commands, providing a practical roadmap for quickly building web applications.
This guide explains how to create a reliable MySQL backup solution by checking disk space, setting up a backup directory, writing a shell script for mysqldump (with optional compression), granting execution rights, scheduling the script with crontab, and verifying the job, while also covering crontab syntax and examples.
This article explains how Couchbase, a distributed NoSQL database, enables personalization, real‑time big‑data processing, and flexible content management for large enterprises, highlighting key requirements, solutions, and real‑world case studies from AOL, PayPal, and a Fortune‑500 media company.
This article presents the design and implementation of a smooth migration solution that moves Baidu's internal bdrp service from Redis 2.6/2.8 to Redis 3.0 by extending the AOF mechanism, enabling real‑time data synchronization, improving service stability, and supporting future upgrades.
This guide explains why database backups are essential, walks through checking disk space, creating a backup directory, writing a Bash script to dump and compress MySQL data, granting execution rights, and scheduling the script with crontab to ensure reliable, automated backups.
This article explains how to design and implement a Java‑based flash‑sale (seckill) system that can handle tens of thousands of concurrent requests, covering entity modeling, DAO methods, service logic, controller handling, a concurrency simulation test, and an improved locking strategy to prevent overselling.
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.
