BestHub
Sign in
Tagged articles

SQL Monitoring

8 articles · Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Oct 8, 2025 · Databases

Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot

This guide explains Druid—Alibaba's Java database connection pool—covering its core concepts, Maven dependencies, property configuration, built‑in filters, SQL and slow‑SQL monitoring, Spring AOP integration, ad removal, and how to retrieve runtime statistics via DruidStatManagerFacade, all with complete code examples.

Database Connection PoolDruidJava
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot
Java Tech Enthusiast
Java Tech Enthusiast
Sep 2, 2025 · Backend Development

Build a Real‑Time SQL Call Tree Visualizer for SpringBoot & MyBatis using D3.js

This article presents a SpringBoot‑MyBatis solution that captures SQL execution via an interceptor, builds a hierarchical call tree, visualizes it with D3.js, and provides REST APIs for real‑time monitoring, performance statistics, and configuration, helping developers debug complex queries and identify slow SQL.

D3.jsMyBatisSQL Monitoring
0 likes · 24 min read
Build a Real‑Time SQL Call Tree Visualizer for SpringBoot & MyBatis using D3.js
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 12, 2017 · Databases

Inside Alibaba’s Database Hacks That Quadrupled Double‑11 Query Speed

The article details how Alibaba’s database team engineered multiple breakthroughs—PK_Access query optimization, a high‑performance Memcached plugin, batch‑processed inventory hotspot handling, full‑scale SQL collection, and an upgraded Data Replication Center—to dramatically boost Double‑11 transaction throughput, cut latency, and enhance overall system resilience.

AlibabaDatabase OptimizationHigh Concurrency
0 likes · 14 min read
Inside Alibaba’s Database Hacks That Quadrupled Double‑11 Query Speed
Meituan Technology Team
Meituan Technology Team
Dec 19, 2016 · Databases

MTDDL: Meituan Distributed Data Layer Middleware Overview

MTDDL, Meituan’s in‑house client‑side sharding middleware, was created to address rapid product‑database growth by offering dynamic data‑source routing, read‑write separation, distributed ID generation, configurable database‑and‑table sharding, connection‑pool management, SQL monitoring, and live configuration updates via annotations and extensible strategies.

Dynamic Data SourceJavaSQL Monitoring
0 likes · 12 min read
MTDDL: Meituan Distributed Data Layer Middleware Overview
dbaplus Community
dbaplus Community
Apr 22, 2016 · Databases

Mastering Oracle Parallel Query: How It Works and When to Use It

This article explains Oracle's parallel query feature, covering its benefits, resource costs, required conditions, various data‑distribution methods such as broadcast, replicate and hash, how to read parallel execution plans, and practical monitoring techniques to avoid performance pitfalls.

Hash JoinOracleParallel Query
0 likes · 31 min read
Mastering Oracle Parallel Query: How It Works and When to Use It
dbaplus Community
dbaplus Community
Dec 28, 2015 · Databases

Mastering Oracle Real‑Time SQL Monitoring for Faster Performance Diagnosis

This guide explains Oracle Real‑Time SQL Monitoring, covering terminology, activation conditions, how to access it via Enterprise Manager Cloud Control, and detailed walkthroughs of its various panels, metrics, and practical examples for diagnosing and optimizing long‑running queries and index builds.

DBAOracleSQL Monitoring
0 likes · 29 min read
Mastering Oracle Real‑Time SQL Monitoring for Faster Performance Diagnosis