BestHub
Sign in
Tagged articles
51 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Apr 6, 2026 · Operations

How Machine Learning Transforms Database Monitoring: From Fixed Thresholds to Intelligent Anomaly Detection

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.

DBADatabase MonitoringOperations
0 likes · 23 min read
How Machine Learning Transforms Database Monitoring: From Fixed Thresholds to Intelligent Anomaly Detection
ITPUB
ITPUB
Feb 20, 2026 · Databases

Master PostgreSQL Health Checks with Open‑Source SKILL Scripts

This guide introduces a collection of PostgreSQL SKILL scripts for automated health checks and operational analysis, explains the repository layout, shows how to run individual or full daily checks, lists all available skills, and provides a sample report with actionable recommendations.

Database Monitoringhealth checkpostgresql
0 likes · 11 min read
Master PostgreSQL Health Checks with Open‑Source SKILL Scripts
Java Companion
Java Companion
Feb 10, 2026 · Backend Development

Why Successful Payments Vanished: MyBatis Connection‑Pool Pitfalls Explained

A production incident where payment orders appeared successful but were not persisted was traced to a missing commit in a special‑case branch, causing a polluted connection to be reused by Spring's transaction manager, leading to intermittent failures that were resolved by fixing the commit logic and adding connection‑pool health checks.

Connection PoolDatabase MonitoringHikariCP
0 likes · 10 min read
Why Successful Payments Vanished: MyBatis Connection‑Pool Pitfalls Explained
Ray's Galactic Tech
Ray's Galactic Tech
Nov 11, 2025 · Databases

How to Tame MySQL CPU Spikes: A Complete 4‑Step Emergency Guide

When MySQL CPU usage spikes to 500%, this guide walks you through a four‑step emergency process—quickly stopping the overload, diagnosing the root cause, applying targeted SQL and configuration optimizations, and setting up monitoring to prevent future spikes—ensuring service stability and performance.

CPU optimizationDatabase MonitoringSlow query analysis
0 likes · 8 min read
How to Tame MySQL CPU Spikes: A Complete 4‑Step Emergency Guide
Qunar Tech Salon
Qunar Tech Salon
Oct 20, 2025 · Databases

Why Traditional DB Inspections Fail and AI-Powered Anomaly Detection Helps

This article examines the limitations of traditional threshold‑based database inspections, introduces AI‑driven anomaly detection techniques such as DoubleRollingAggregate, SeasonalAD, and LevelShiftAD, and details practical implementations, tuning strategies, and real‑world use cases for MySQL and Redis monitoring.

Database Monitoringanomaly detectionmachine learning
0 likes · 23 min read
Why Traditional DB Inspections Fail and AI-Powered Anomaly Detection Helps
Java Web Project
Java Web Project
Oct 19, 2025 · Databases

How to Install and Use RedisInsight for Redis Monitoring and Management

This guide walks through RedisInsight’s key features, step‑by‑step Linux installation, environment‑variable configuration, service startup, Kubernetes deployment via a yaml manifest, and basic UI operations for monitoring Redis memory, connections, and data, illustrated with concrete commands and screenshots.

CLIDatabase MonitoringInstallation
0 likes · 6 min read
How to Install and Use RedisInsight for Redis Monitoring and Management
Qunar Tech Salon
Qunar Tech Salon
Sep 1, 2025 · Databases

Redesigning Database Monitoring: From Push to Pull for Smarter Alerts

This article analyzes the shortcomings of the legacy database monitoring system, explains the transition from a push‑based to a pull‑based architecture, outlines comprehensive metric collection, intelligent alert strategies, and self‑healing mechanisms, and showcases the performance improvements achieved with the new solution.

AlertingDatabase MonitoringPrometheus
0 likes · 25 min read
Redesigning Database Monitoring: From Push to Pull for Smarter Alerts
MaGe Linux Operations
MaGe Linux Operations
Aug 22, 2025 · Databases

How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study

This article walks through a real e‑commerce incident where order queries took 15‑30 seconds, identifies bottlenecks via system metrics and slow‑query logs, analyzes execution plans, adds composite indexes, rewrites SQL, applies partitioning, read‑write splitting and caching, and ultimately achieves up to a 230‑fold performance boost.

Database Monitoringmysqlperformance tuning
0 likes · 15 min read
How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study
Architect
Architect
Jul 20, 2025 · Databases

Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot

This guide explains how to integrate Alibaba Druid as a Java database connection pool, add Maven dependencies, configure core properties, enable SQL and slow‑SQL monitoring, set up WebStatFilter and Spring AOP monitoring, remove the built‑in advertisement, and retrieve monitoring data via DruidStatManagerFacade.

Connection PoolDatabase MonitoringDruid
0 likes · 15 min read
Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot
JD Tech Talk
JD Tech Talk
Jun 10, 2025 · Backend Development

Instantly Spot Problematic SQL with MyBatis Interceptor Coloring

This article explains how to use SQL coloring in MyBatis by implementing a lightweight interceptor or an AspectJ weave to annotate each SELECT statement with its mapper ID and execution stack, enabling rapid identification of performance bottlenecks during high‑traffic events.

Database MonitoringMyBatisPerformance debugging
0 likes · 29 min read
Instantly Spot Problematic SQL with MyBatis Interceptor Coloring
Senior Tony
Senior Tony
May 29, 2025 · Operations

How to Diagnose and Fix 100% CPU on Database and Application Servers

This guide explains how to identify the root causes of a server's CPU hitting 100%—whether on a database or an application server—by using cloud monitoring, Linux top commands, thread analysis with jstack, and practical Java code fixes such as limiting loops, optimizing locks, and handling GC pressure.

CPU troubleshootingDatabase MonitoringThread analysis
0 likes · 9 min read
How to Diagnose and Fix 100% CPU on Database and Application Servers
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 19, 2025 · Databases

Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement

The article explains why the built‑in MySQL 5.7 Seconds_Behind_Master metric often misrepresents replication delay, analyzes its design flaws, and demonstrates how the Percona Toolkit's pt‑heartbeat tool can reliably measure master‑slave lag with real‑time precision.

Database MonitoringReplicationSeconds_Behind_Master
0 likes · 10 min read
Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement
IT Architects Alliance
IT Architects Alliance
Jun 23, 2024 · Databases

Configuring Druid DataSource Monitoring and Filters in Spring Boot

This guide explains the fundamentals of Druid as a Java database connection pool, how to add required Maven dependencies, configure various Druid properties and filters for SQL and web monitoring, enable slow‑SQL logging, integrate Spring AOP monitoring, remove the default Alibaba advertisement, and retrieve monitoring data via the DruidStatManagerFacade API.

Connection PoolDatabase MonitoringDruid
0 likes · 14 min read
Configuring Druid DataSource Monitoring and Filters in Spring Boot
Architect
Architect
Jun 22, 2024 · Backend Development

Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources

This guide explains how to integrate Alibaba's Druid connection pool into Spring Boot, covering basic concepts, Maven dependencies, essential configuration properties, built‑in filters, monitoring pages, SQL and slow‑query logging, Spring AOP monitoring, ad removal, and programmatic access to Druid statistics.

Connection PoolDatabase MonitoringDruid
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources
Qunar Tech Salon
Qunar Tech Salon
Jan 18, 2024 · Databases

Optimization Journey of Qunar's Database Inspection and Alarm Systems

This article details Qunar's DBA team's systematic analysis of shortcomings in their original database inspection and alarm systems, the design and implementation of comprehensive metric enhancements, risk‑level classification, automated reporting, and alarm noise reduction, and reports the significant improvements in stability, efficiency, and fault‑free operation achieved through these optimizations.

Database Monitoringalarm systeminspection system
0 likes · 15 min read
Optimization Journey of Qunar's Database Inspection and Alarm Systems
Ctrip Technology
Ctrip Technology
Feb 2, 2023 · Databases

MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis

This article details Ctrip's experience migrating MySQL workloads to the distributed OceanBase database, covering the design of an assessment tool, a one‑click migration workflow, comprehensive monitoring dashboards, automated fault‑diagnosis pipelines, encountered compatibility issues, and future roadmap for the platform.

Database MonitoringFault DiagnosisMySQL Migration
0 likes · 17 min read
MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis
MaGe Linux Operations
MaGe Linux Operations
Dec 29, 2022 · Databases

Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide

This article explains how to collect comprehensive MySQL performance data—including connections, buffer cache, locks, statement counts, throughput, server configuration, and slow‑query logs—using only native SHOW commands, providing step‑by‑step SQL snippets, calculation formulas, and best‑practice tips for efficient monitoring.

Database MonitoringPerformance SchemaSHOW commands
0 likes · 10 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
Architecture Digest
Architecture Digest
Nov 23, 2022 · Databases

Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring

This article explains how to collect a wide range of MySQL performance metrics—including connections, buffer pool usage, locks, SQL statistics, statement counts, throughput, server variables, and slow‑query logs—using only MySQL's native SHOW commands and performance_schema tables, while also offering practical tuning tips and analysis tools.

Database MonitoringPerformance SchemaSlow Query Log
0 likes · 11 min read
Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring
Programmer DD
Programmer DD
Aug 16, 2022 · Databases

Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide

This article explains how to collect comprehensive MySQL performance metrics—including connections, buffer cache, locks, statement counts, throughput, server variables, and slow‑query analysis—using only MySQL's native SHOW commands, providing a fast, low‑overhead monitoring solution.

Database MonitoringMetricsSlow Queries
0 likes · 11 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
Qunar Tech Salon
Qunar Tech Salon
Nov 2, 2021 · Databases

Improving Qunar.com Database Monitoring and Alert System with a Kafka‑Based Alarm Program

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.

DBADatabase Monitoringalert system
0 likes · 13 min read
Improving Qunar.com Database Monitoring and Alert System with a Kafka‑Based Alarm Program
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 21, 2021 · Databases

Diagnosing a MongoDB Shard Connection Storm that Caused Replication Lag and Automatic Failover

The article details a MongoDB 3.4 sharded cluster incident where a sudden connection storm overwhelmed the primary, leading to replication lag, automatic failover, and how monitoring, log analysis with mtools, and a custom log‑rotation script were used to diagnose and resolve the issue.

Connection StormDatabase MonitoringMongoDB
0 likes · 8 min read
Diagnosing a MongoDB Shard Connection Storm that Caused Replication Lag and Automatic Failover
Efficient Ops
Efficient Ops
Jun 6, 2021 · Databases

How We Built a Scalable Database Monitoring System for Real‑Time Alerts

This article details the design and implementation of a comprehensive database monitoring platform that automatically adapts to cluster changes, aggregates host and DB metrics, offers flexible alert templates and strategies, stores data in InfluxDB, and provides customizable dashboards for real‑time insight and incident response.

AlertingDatabase MonitoringInfluxDB
0 likes · 12 min read
How We Built a Scalable Database Monitoring System for Real‑Time Alerts
dbaplus Community
dbaplus Community
Nov 21, 2019 · Databases

How to Build a Real‑Time MySQL Statistics Platform with ClickHouse

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.

DBADatabase MonitoringSQL Analytics
0 likes · 16 min read
How to Build a Real‑Time MySQL Statistics Platform with ClickHouse
dbaplus Community
dbaplus Community
May 9, 2019 · Databases

Exporting Redis Slowlog to Elasticsearch with a Customized rsbeat

This guide explains how to overcome Redis slowlog retention limits by modifying rsbeat to collect and ship slowlog entries—including sentinel and cluster support—to Elasticsearch, where Kibana can be used for detailed analysis and visualization.

BeatsDatabase MonitoringElasticsearch
0 likes · 7 min read
Exporting Redis Slowlog to Elasticsearch with a Customized rsbeat
dbaplus Community
dbaplus Community
Nov 28, 2018 · Databases

Boost MySQL Performance: How to Use the PHP Rebuilt Percona PT‑kill with Email & WeChat Alerts

This guide introduces a PHP‑based reimplementation of Percona’s PT‑kill tool that not only terminates long‑running MySQL queries but also adds email and WeChat notifications, explains installation prerequisites, detailed command‑line options, example usages, configuration steps, and how to customize alerts and logging.

AlertingDatabase MonitoringPHP
0 likes · 8 min read
Boost MySQL Performance: How to Use the PHP Rebuilt Percona PT‑kill with Email & WeChat Alerts
dbaplus Community
dbaplus Community
Oct 9, 2018 · Operations

Automate Database Monitoring with Zabbix and Ansible – A Complete Guide

This article walks through building an automated database monitoring system using Zabbix and Ansible, covering Zabbix core automation features (LLD, API, trapper), standardizing monitoring conventions, deploying with Ansible, and implementing a Python‑based DBA_Monitor project for Oracle, MySQL, Redis, and MongoDB.

AnsibleDatabase MonitoringLLD
0 likes · 14 min read
Automate Database Monitoring with Zabbix and Ansible – A Complete Guide
dbaplus Community
dbaplus Community
Feb 22, 2018 · Databases

How to Build Effective MySQL Performance Management and Analysis

This article outlines the real‑world demand for MySQL performance management, critiques traditional monitoring approaches, and presents a product‑focused design that emphasizes lightweight data collection, incremental recording, metric‑driven drill‑down, and comprehensive analysis techniques such as AS/PS and QRTi.

AS/PSDatabase MonitoringMetrics
0 likes · 16 min read
How to Build Effective MySQL Performance Management and Analysis
dbaplus Community
dbaplus Community
Jul 25, 2017 · Databases

How to Build a MySQL Connection & SQL Analyzer for Fast Issue Diagnosis

This article explains how to create a lightweight MySQL tool that extracts connection details from information_schema.processlist, groups them by user, host, database, command and state, fingerprints SQL statements, and correlates them with InnoDB transaction data to quickly pinpoint performance problems.

Connection AnalysisDatabase MonitoringIncident Diagnosis
0 likes · 12 min read
How to Build a MySQL Connection & SQL Analyzer for Fast Issue Diagnosis
dbaplus Community
dbaplus Community
Jul 4, 2017 · Databases

Mastering Oracle Performance: A Guide to AWR, ASH, ADDM, and More

This article explains Oracle database performance tuning by introducing the five key performance reports—AWR, ASH, ADDM, AWRDD, and AWRSQRPT—detailing how to obtain them, what metrics to focus on, and how to apply them in real‑world case studies for both simple and complex optimization scenarios.

ADDMASHAWR
0 likes · 22 min read
Mastering Oracle Performance: A Guide to AWR, ASH, ADDM, and More
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Feb 28, 2017 · Databases

How to Use MySQL Sniffer for Real-Time MySQL Traffic Capture

MySQL Sniffer is a command‑line tool that captures MySQL protocol traffic in real time, displaying timestamps, users, source IPs, databases, query latency, row counts and SQL statements, while offering flexible options such as multi‑port capture, daemon mode, log splitting and output to files.

Database Monitoringcommand-linemysql
0 likes · 8 min read
How to Use MySQL Sniffer for Real-Time MySQL Traffic Capture
Java High-Performance Architecture
Java High-Performance Architecture
Nov 7, 2016 · Databases

How to Monitor MySQL & PostgreSQL Replication Lag with pt-heartbeat

pt-heartbeat, a Percona Toolkit utility, enables precise monitoring of MySQL and PostgreSQL replication lag by creating a heartbeat table on the master, updating timestamps, and comparing them with slaves, with detailed installation steps, usage examples, and configuration guidance for reliable replication health checks.

Database MonitoringReplication Lagmysql
0 likes · 5 min read
How to Monitor MySQL & PostgreSQL Replication Lag with pt-heartbeat
dbaplus Community
dbaplus Community
Nov 1, 2016 · Databases

Understanding Oracle Wait Events: Types, Causes, and Optimization Strategies

This article explains the evolution of Oracle performance metrics, categorizes wait events into idle and non‑idle types, details common wait events with their parameters and causes, and provides practical guidance on using Oracle views to monitor and tune these events for better database performance.

Database MonitoringI/O bottlenecksOracle
0 likes · 22 min read
Understanding Oracle Wait Events: Types, Causes, and Optimization Strategies
ITPUB
ITPUB
May 20, 2016 · Databases

Essential Oracle Monitoring Queries for Performance Tuning

This article compiles a comprehensive set of Oracle SQL queries that monitor wait events, rollback segment contention, tablespace and file system I/O ratios, SGA hit rates, dictionary cache efficiency, MTS activity, fragmentation, and other critical performance metrics, often with recommended threshold values.

Database MonitoringOracleSGA
0 likes · 10 min read
Essential Oracle Monitoring Queries for Performance Tuning
dbaplus Community
dbaplus Community
Jan 10, 2016 · Databases

Essential Free Tools Every Oracle DBA Should Master

A practical guide introduces nine free Oracle DBA utilities—including OS Watcher, oratop, ora, SQL Developer, AWR/ASH/ADDM, ORAchk, RDA, RMAN, and OEM CC—detailing their installation, usage, and key features for effective database monitoring and maintenance.

DBA toolsDatabase MonitoringOracle
0 likes · 10 min read
Essential Free Tools Every Oracle DBA Should Master
ITPUB
ITPUB
Nov 12, 2015 · Operations

Automate DB Monitoring Reports with Zabbix and Orabbix

This guide explains how to extract Zabbix graphs using screenid and graphid, download them via Python, store them temporarily, and attach the images to email reports for efficient database server monitoring.

Database MonitoringOrabbixReporting
0 likes · 6 min read
Automate DB Monitoring Reports with Zabbix and Orabbix