A comprehensive reference of 100 production-ready SQL queries for monitoring, troubleshooting, and managing Oracle 19c Active Data Guard environments, covering configuration, synchronization, role transitions, performance, and daily maintenance with risk annotations.
A comprehensive reference of 100 practical T-SQL commands for SQL Server 2016-2022 DBAs, organized into ten categories covering instance basics, space management, session analysis, locking, performance tuning, indexes, Always On, backup/recovery, permissions, and daily health checks.
This comprehensive guide details nine essential MySQL DBA commands — SHOW DATABASES, SHOW TABLE STATUS, SHOW FULL PROCESSLIST, SHOW ENGINE INNODB STATUS, SHOW VARIABLES, SHOW STATUS, EXPLAIN, SHOW INDEX, and SHOW CREATE TABLE — with syntax examples, key output fields, and practical troubleshooting scenarios for performance tuning and database administration.
The 17th China Database Technology Conference showcased DBA‑AI transformation strategies, highlighting five‑stage evolution paths, lightweight big‑data + AI architectures, and the emerging Agentic Data Stack, while warning of AI hallucination risks and emphasizing human‑AI collaboration for future data engineering.
This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.
This guide outlines step‑by‑step procedures for diagnosing Oracle database performance problems, covering how to collect ADDM, AWR, and ASH reports, capture high‑CPU error stacks, obtain 10046 trace files for single or multiple sessions, and use Oracle hang‑analysis documents to differentiate true hangs from CPU spinning.
This article explains why traditional threshold‑based database inspections are insufficient, introduces machine‑learning‑driven anomaly detection as a second set of eyes, details feature extraction, algorithm choices, tuning, and alert convergence, and showcases three real‑world scenarios with MySQL and Redis metrics.
This article compares the execution‑plan generation, caching, and query‑performance characteristics of Oracle, MySQL, and PostgreSQL, explains how to view plans in each system, and provides practical tips for DBAs to interpret and optimize them effectively.
The article explains the hidden challenges of database migration, demonstrates that large language models alone cannot reliably handle dialect differences, and describes how the SQLShift tool combines domain‑specific fine‑tuning, multi‑stage verification, and human‑AI collaboration to make migration safer and more predictable.
This article compares how Oracle, MySQL, and PostgreSQL generate, view, and interpret execution plans, highlighting differences in hint support, caching, query efficiency, and providing practical commands and visual examples to help DBAs diagnose and optimize database performance.
This article walks through four real‑world SQL performance disasters—chaotic joins, NULL‑value scans, LOB full‑table scans, and massive batch deletions—explaining why they cripple databases and providing concrete, step‑by‑step rewrite and indexing solutions to restore stability and speed.
This article provides a comprehensive, step‑by‑step tutorial on deploying a MySQL master‑slave replication architecture using Docker containers, covering prerequisite checks, container setup, configuration files, replication user creation, master‑slave linking, testing data sync, and troubleshooting common issues.
The article examines China's rapid shift toward domestic databases across finance, government, and energy sectors, highlighting how DBAs must upgrade from reactive fire‑fighting to strategic architects by mastering distributed systems, AI‑driven automation, cloud‑native tools, and open‑source community collaboration.
This tutorial explains why DBAs need security hardening and log analysis, shows how to configure minimal‑privilege roles and precise permissions in PostgreSQL, demonstrates how to detect and revoke redundant privileges, and provides a step‑by‑step guide to installing and using pgBadger for log analysis and automated reporting.
The article argues that, despite common fears, AI and modern management tools like OEM and DB Console empower DBAs to work more efficiently, improve performance, and stay relevant, while highlighting real-world stories of tool adoption and the challenges of AI hallucinations.
The article recounts decades‑long Oracle DBA experiences, describing early‑era crashes, notorious ORA‑1591 and ORA‑600 errors, troubleshooting tactics, and how those hardships forged highly skilled DBAs while highlighting the evolution toward more mature database systems.
The article explains how Oracle DBAs transitioning to PostgreSQL often misinterpret work_mem and cursor sharing, showing how improper settings can drastically change execution plans, increase query time, and cause performance issues, while also highlighting differences in memory management and plan caching between the two systems.
An in‑depth analysis of database change workflows reveals three key players—business developers, DBAs, and change tools—outlines the full lifecycle of a change, illustrates a MySQL VARCHAR length mishap, and argues why the business team should bear primary responsibility while DBAs assume secondary accountability.
This guide introduces a collection of practical MySQL DBA utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit commands such as pt‑duplicate-key-checker, pt‑kill, pt‑mysql-summary, pt‑query-digest, pt‑table-checksum, and pt‑table-sync—showing how to install them, run key commands, and interpret their outputs to streamline database administration tasks.
This article walks through a real‑world Oracle index failure, explains why indexes become UNUSABLE, shows how to clean residual metadata, rebuild the index safely, outlines common causes for both regular and partitioned tables, and provides SQL scripts for monitoring invalid indexes.
In this episode, the AI assistant ChatDBA analyzes frequent MySQL error‑log messages, identifies misconfigured timeout parameters as the primary cause, and guides the DBA through adjusting rpl_semi_sync_master_timeout to resolve the replication delays, while also comparing results with Gemini.
The article explains what constitutes an SQL problem, presents a typical case of performance degradation caused by mismatched character sets, and outlines how the SQLE platform can help developers, testers, and DBAs systematically manage and improve SQL quality throughout the software lifecycle.
When a major operations incident strikes, the safest approach is to prioritize simple, low‑risk actions and accept limited responsibility, as illustrated by real DBA lessons from Oracle RAC failures and a data‑center power‑loss disaster.
The article examines why many organizations avoid upgrading databases despite end‑of‑life warnings, highlighting cultural resistance, skill gaps, security and performance risks, and offers practical strategies for planning and executing safe database upgrades.
OceanBase, a distributed open‑source database, offers a free e‑book and an eight‑session tutorial series covering installation, migration, operation, performance tuning, diagnostics, and ecosystem tools such as OCP, OMS, ODC, and obdiag, aimed at students, developers, and DBAs seeking practical skills and certification.
In this interview, a senior database operations manager shares why building a lightweight, purpose‑built tool is essential, outlines a systematic selection process based on clear operational needs, and highlights key criteria such as usability, security, and controllability while recommending practical solutions.
The article examines how shifting industry trends, cloud adoption, and the rise of domestic databases force Oracle DBAs to choose between staying the course, expanding their skill set, or pivoting entirely, offering practical guidance for each path.
This article, based on an interview with Huolala's database leader Cai Peng, outlines essential criteria for selecting database tools from both developer and DBA perspectives, compares small‑scale versus comprehensive solutions, and emphasizes the need for integrated, platform‑level tooling in modern cloud‑driven environments.
A veteran Oracle DBA recounts the painful history of early Oracle versions, explains classic errors like ORA-1591 and ORA-1578, shares troubleshooting tactics, and reflects on how those hardships forged the expertise needed to master today’s complex database environments.
The article examines how the responsibilities of database administrators are shifting due to massive data volumes, heightened security concerns, cloud adoption, DevOps integration, and emerging AI and IoT technologies, outlining current challenges, recent changes, and key trends shaping the DBA profession.
This article describes a step‑by‑step procedure for safely dropping a massive MySQL history_str table—including creating a new table, renaming, using hard links, staged drops, and a truncate script—to avoid instance hangs, replication lag, and I/O pressure while freeing disk space.
The article analyzes an unusual MySQL replication lag pattern where Seconds_Behind_Master jumps abruptly between 0 and a fixed maximum due to slave clock adjustments, explains the underlying cause, and provides practical steps for time synchronization and IO‑thread handling to resolve the issue.
This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.
The article details Huolala’s comprehensive approach to managing diverse databases across multiple clouds, covering systematic stability engineering, automated SQL governance, Redis and Kafka reliability strategies, cost‑optimization tactics, and the evolving roles of modern DBAs in a complex, high‑scale environment.
Moving databases to the cloud changes DBA tasks but does not eliminate the role; it introduces new responsibilities such as migration planning, cross‑cloud compatibility, performance tuning, and acting as a bridge between cloud providers and enterprises.
This announcement introduces the MySQL DBA Elite Practical Course book, detailing its comprehensive coverage of core and advanced MySQL technologies, and outlines a limited-time giveaway event where readers can win copies by following the community’s participation rules.
This article explains the principles of MySQL semi‑synchronous replication, analyzes how data consistency is maintained during high‑availability failover, presents detailed step‑by‑step transaction flow, discusses scenarios causing GTID divergence, and offers testing methods and remediation techniques for DBA practitioners.
This article demonstrates how to use MySQL Shell's DBA component to deploy multiple MySQL sandbox instances of different versions, customize their deployment directories, and configure instance parameters through command‑line options and MySQL configuration files.
This article outlines practical guidance for DBAs transitioning to Chinese domestic databases, highlighting why standard Oracle benchmark tweaks often fail, the limited relevance of buffer‑hit ratios, the importance of SQL execution efficiency, and specific strategies for handling high‑concurrency workloads.
The article explains how database observability has evolved from visual tools like SpotLight to automated, metric‑driven platforms such as D‑SMART, highlighting diverse DBA needs, practical dashboard designs, and the limits of traditional SNMP‑based monitoring.
The article examines how slow‑query‑induced avalanches arise in MySQL, explains why naïvely killing slow queries is fraught with accuracy, automation and responsibility issues, and proposes a signature‑based timeout mechanism that lets applications safely abort problematic queries.
The article shares a senior DBA's journey from early database engine development to modern MySQL operations, outlining practical methods for improving efficiency, automating monitoring, building data‑driven processes, and redefining the DBA role for proactive, high‑impact service delivery.
Qunar’s DBA team overhauled their MySQL monitoring and alert system—originally built on Nagios and NRPE—by integrating a Kafka‑based pipeline, a custom alarm service, and MySQL‑stored alert templates, achieving flexible thresholds, granular silencing, high‑availability processing, and early‑stage intelligent management of alerts, slow queries, and disk space.
The article describes how Qunar.com upgraded its Nagios/NRPE‑based database monitoring by inserting a Kafka‑driven alarm component, centralizing alert configuration in MySQL, adding flexible shielding and multi‑channel notifications, and exploring intelligent features such as slow‑query and disk‑space management.
A detailed forensic analysis reveals that a MySQL 5.7 instance stalls during startup due to a mismatch between InnoDB flush‑sync settings and truncate‑related redo logs, and the article explains how to diagnose the issue with TOP, stack traces, and source‑code inspection, then offers three practical work‑arounds.
This article explains how MySQL's Seconds_Behind_Master metric is calculated, the underlying replication mechanisms, factors that affect its accuracy, and provides detailed source‑code analysis to help DBA engineers interpret and monitor replication delay effectively.
The article details a step‑by‑step investigation of a MySQL server that ran out of memory due to massive slab cache consumption by inode and dentry objects, showing how Linux commands, scripts, and cache‑dropping techniques resolved the issue and revealed the root cause of excessive partition tables.
This article introduces the 'DBA攻坚指南' book, detailing its Oracle and MySQL performance‑tuning content, author credentials, key chapters, SQL health‑check scripts, usage examples, and the accompanying giveaway event organized by the 爱可生开源社区.
This article explains how DBAs can use PostgreSQL's extensive logging parameters and log_line_prefix settings to locate and reconstruct every SQL statement within a transaction, illustrated with practical cases, command‑line examples, and step‑by‑step log‑analysis techniques for lock troubleshooting.
This article outlines ten practical MySQL development guidelines—from always using InnoDB and simple data types to avoiding SELECT *, ENUM, and low‑cardinality indexes, while emphasizing proper naming, charset choices, NOT NULL constraints, and continuous SQL monitoring with Percona Toolkit.
This article outlines ten practical MySQL development guidelines—from using InnoDB tables and simple data types to avoiding SELECT * and unnecessary ENUMs—helping DBAs and developers collaborate more efficiently and write cleaner, faster SQL.
The article explains how to construct an effective DBA operations team by focusing on reusable infrastructure, clear team standards, a structured training system, a comprehensive knowledge base, and a positive team atmosphere, providing practical tools and methods for each aspect.
This guide compiles the most useful Unix/Linux commands for PostgreSQL administrators, covering background execution, mail queue handling, email with attachments, file searching, cleanup, compression, diffing, remote synchronization, timestamp‑based file moves, and system reboot techniques.
The article examines the evolving role of Database Administrators, tracing their origins from ops engineers to high‑paid specialists, highlighting how cloud‑based Database‑as‑a‑Service and PaaS offerings are automating traditional DBA tasks, causing job declines and prompting DBAs to adapt their skills toward cloud, performance, security, and business‑oriented data management.
Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.
This article examines recent database deletion incidents and offers DBA‑level guidance on strengthening processes, technical safeguards, and security policies, covering backup‑restore design, performance optimization, high‑availability strategies, and self‑service automation to avoid future data loss.
In this interview, senior DBA Ge Haoqiang from Tiancheng Financial discusses the scale of their database clusters, the efficiency gains from automation, DevOps culture, language choices, and how they adapt to new database features, offering insights into modern database operations automation.
Senior DBA Yang Jianrong shares how standardized processes, robust security, and modern optimization—such as partitioning, middleware, and NoSQL—combined with high‑availability designs and self‑service tools like automated slow‑log analysis can streamline large‑scale MySQL operations, migrations, and continuous DBA learning.
In a detailed Q&A session, Minsheng Bank’s database specialist shares 16 practical insights on intelligent database operations, covering data storage choices, monitoring tools like Zabbix and Prometheus, anomaly detection, prediction modeling, SQL metric collection, log analysis, and the evolving role of DBAs in the era of AI‑driven ops.
A production Oracle database suddenly ran queries with an excessively high degree of parallelism, prompting a DBA to investigate, discover an unexpected SYS‑owned SQLPROFILE as the root cause, and reflect on the need for stricter operational oversight.
This article explains how a growing company designed, optimized, and deployed a comprehensive MySQL monitoring and analysis pipeline—moving from Flume‑HDFS‑Hive to ClickTail‑ClickHouse, enriching SQL parsing, and applying practical methods for state statistics, trend analysis, permission management, and data‑skew detection.
The article analyzes how the DBA job market is shrinking as traditional enterprises shift away from legacy systems, cloud adoption reshapes responsibilities, and DBAs face limited advancement unless they transition to architecture or data‑analytics roles, highlighting the growing risk and low reward of staying in pure DBA work.
This article presents a practical guide for Oracle DBAs to quickly diagnose and resolve application‑related database issues by checking OS load, analyzing wait events, querying session and object details, capturing diagnostic dumps, and using scripted commands to kill sessions or restart the database.
In this interview with MySQL expert Huang Yan, the speaker shares practical, down‑to‑earth techniques for DBAs and developers to explore MySQL’s source code, covering tools, history inspection, test‑driven understanding, DTrace probes, and the mindset of an effective DBA.
A collection of vivid DBA anecdotes reveals common pitfalls—from missed alerts and accidental production restarts to unsafe terminal habits—and distills practical safeguards that any database operator can adopt to avoid costly mishaps.
In this interview, DBA leader Zhang Chong shares his hands‑on experience with MySQL high‑availability implementations, middleware design, multi‑database strategies, and practical tips for avoiding common pitfalls while building automated deployment platforms.
The article examines whether Oracle will be completely supplanted by MySQL, comparing industry adoption, DBA role differences, performance versus scalability, cost considerations, and cultural factors that influence database choices in traditional and internet sectors.
The article explains why InnoDB semaphore waits exceeding 600 seconds trigger server crashes, details the lock structures and functions involved, shows how buffer pool pressure and metadata statistics cause contention, and introduces a small DBA utility that parses MySQL error logs to reveal the relationships between threads, locks, and transactions.
This article explains why SQL auditing is essential, outlines its core principles, dimensions, scoring model, and workflow, and provides practical guidance on building a self‑service, visualized, and automated audit solution that improves database reliability and developer productivity.
Meituan’s DBA team progressed from simple scripting through tooling, productization, private‑cloud self‑service and full automation to an emerging intelligent‑operation model that leverages extensive data collection, risk‑driven pre‑warning, AI‑assisted analysis, and self‑healing mechanisms to meet rapid growth, stability and scalability demands.
This talk details Ele.me’s three‑month rollout of a dual‑active (multi‑active) database system, covering design principles, architecture, migration steps, challenges such as data consistency and DDL handling, the tools built (DRC, D‑Bus, DCP, EMHA), and the performance and reliability benefits achieved.
This article outlines the journey of a financial services company from manual DBA tasks through tool‑assisted operations to a fully automated platform, detailing the platform’s technical stack, functional modules, metadata design principles, evolving SQL audit workflow, and future directions for intelligent database operations.
This article details how a DBA team built a standardized, automated MySQL/Redis management platform—covering OS and DB standardization, deployment scripts, a three‑layer web‑task‑module architecture, RESTful APIs, and modular design—to enable a handful of DBAs to manage thousands of instances efficiently.
The article examines how small, workshop‑style development teams blur and eventually eliminate traditional roles such as full‑stack engineers, DevOps practitioners, and DBAs, illustrating the shift from rigid role separation to overlapping responsibilities driven by speed, resource constraints, and modern tooling.
The article explains how to extend MySQL’s built‑in lexer and Bison‑based parser to expose table names, query features, and optimization advice via a simple language‑agnostic service, illustrating core data structures, useless‑condition elimination, feature generation for slow‑query analysis, and practical learning tips.
This article outlines Didi's MySQL database architecture, the challenges of managing thousands of instances, and the step‑by‑step automation framework—including dbproxy, high‑availability, backup, monitoring, and deployment modules—that reduces manual DBA work by over 70%.
This article explains the challenges of MySQL SQL auditing, compares semi‑automated and manual review methods, and introduces Inception—a MySQL‑compatible automated auditing, execution, and rollback system that addresses many of the pain points faced by DBAs.
This article walks through a real‑world case of MySQL 5.7 replication delay after switching to TokuDB, presenting a step‑by‑step methodology that examines network, hardware, large transactions, locks, configuration parameters, and multi‑threaded replication to identify and resolve the root cause.
This guide reviews five essential open‑source MySQL utilities—Mycli, Gh‑ost, phpMyAdmin, Sqlcheck, and Orchestrator—detailing their key features, licensing, contributor statistics, and practical usage scenarios to help database administrators streamline management, migrations, monitoring, and high‑availability tasks.
This guide shares a seasoned DBA's practical checklist covering environment awareness, hardware considerations, runtime monitoring, data security, routine operations, fault‑prevention plans, architecture insights, and the right mindset to help database professionals reduce errors and improve system stability.
This comprehensive guide shares a seasoned DBA's practical advice on environment awareness, hardware considerations, security, routine operations, architecture, and mindset to help database professionals avoid common pitfalls and improve reliability in MySQL production systems.
This comprehensive guide shares a senior DBA's hard‑learned lessons on MySQL environment setup, data security, routine operations, architecture insights, online execution tips, and the right mindset, helping database professionals prevent common pitfalls and improve reliability.
This article provides a comprehensive, step‑by‑step guide on MySQL backup strategies, security hardening, SQL coding standards, and system planning, offering practical recommendations, verification methods, and actionable checklists to help DBAs build resilient and well‑managed database environments.
The article shares a DBA's real‑world experiences—from a risky MySQL restart that exposed hidden issues, through practical learning advice and MySQL technical nuances, to a detailed Oracle migration case—offering actionable insights for database professionals seeking robust data management and performance optimization.
This guide shares a senior DBA’s hard‑learned lessons on mastering MySQL environments, ensuring data security, handling routine operations, designing robust architectures, and adopting the right mindset to reduce costly mistakes and improve reliability in production systems.
This article outlines practical steps DBAs can take to prevent data leakage and loss, covering user and profile management, privilege minimization, audit logging, vulnerability patching, high‑availability solutions like RAC and Data Guard, and effective backup and recovery drills.
The article explains why a MySQL UPDATE statement took five seconds by examining binlog entries, distinguishing slow‑query scans from lock‑waits, and using a Bash script to identify long‑running transactions that reveal hidden lock contention.
This article discusses DBA career advancement, outlining typical salary increase mechanisms, promotion pathways, and proposes a seven‑level DBA competency framework to help professionals plan growth and negotiate better compensation within the industry.
This article offers comprehensive advice on MySQL DBA interview preparation, covering the book’s positioning, essential technical topics such as replication and InnoDB internals, desired personal qualities, interview strategies, and practical tips for both interviewers and candidates.
SQLAdvisor, an open-source MySQL optimization utility from Meituan-Dianping, analyzes a given SQL statement—parsing its lexical structure, WHERE clauses, field selectivity, aggregations and multi-table joins—to automatically recommend missing indexes, supporting INSERT/DELETE/UPDATE/SELECT operations, filtering existing indexes, and inviting community contributions on GitHub.
This guide presents a comprehensive set of MySQL DBA standards covering change approvals, backup procedures, schema modifications, high‑availability architecture, security policies, indexing strategies, table and column design, and SQL writing techniques to ensure stable, performant, and secure database operations.
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 outlines common Oracle migration pitfalls—including architectural constraints, resource impacts, application coordination issues, and diverse database problems—drawn from real‑world projects, and offers practical guidance to help DBAs anticipate and mitigate these challenges during system cut‑overs, upgrades, and consolidations.
A GitLab.com database accident caused the loss of 310 GB of data, exposing multiple failed backup mechanisms and prompting a detailed analysis of technical, operational, and managerial lessons for reliable data protection.
This guide outlines the critical tasks DBA teams should perform before, during, and after the Chinese New Year holiday, including daily security practices, pre‑holiday inspections, on‑call rotations, post‑holiday reviews, and detailed checklist scripts to ensure database reliability and prevent incidents.
This article explains the origins, structure, and practical uses of MySQL's sys schema—including its view hierarchy, comparisons with Oracle data dictionary, performance‑monitoring capabilities, and step‑by‑step examples for troubleshooting locks, analyzing schema statistics, and backing up or rebuilding the sys database.
This article recaps a DBAplus community session where a seasoned DBA shares common operational scenarios, diagnostic techniques, lock‑handling strategies, and step‑by‑step SQL optimization methods, while unveiling the DPM platform that automates inspection, data collection, and performance analysis for Oracle databases.