BestHub
Sign in
Showing 100 articles max
Latest Popular
MaGe Linux Operations
MaGe Linux Operations
May 30, 2026 · Databases

How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide

This article walks through the entire MySQL performance troubleshooting workflow from an operations perspective, covering architecture basics, slow‑query‑log configuration, analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN interpretation, index design and optimization, configuration tuning, replication monitoring, real‑time diagnostic commands, risk mitigation, rollback procedures, and backup strategies.

Performanceconfigurationindexing
0 likes · 40 min read
How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide
Su San Talks Tech
Su San Talks Tech
May 30, 2026 · Databases

Why PostgreSQL Beats MySQL for AI‑Driven Applications

The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.

DatabaseFull-Text SearchJSONB
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
JD Tech
JD Tech
May 27, 2026 · Databases

DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases

DongSQL V1.2.0 introduces a suite of kernel upgrades—including group‑commit unicast, semi‑sync replication tweaks, plan‑cache, single‑point query enhancements, massive‑table fast startup, SIMD acceleration, hotspot‑row updates and high‑volume testing support—delivering significant performance and stability improvements across diverse retail workloads.

Database PerformanceDongSQLHigh‑Volume Testing
0 likes · 24 min read
DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases
Ops Community
Ops Community
May 26, 2026 · Databases

How to Safely Clean Up MySQL Binlog When Disk Space Is Critical

This guide walks through why MySQL binlog can fill disks, explains its structure and formats, and provides a step‑by‑step, risk‑aware process—including preparation, safe PURGE commands, automatic expiration settings, verification, and monitoring—to clean binlog without breaking replication or losing data.

Monitoringbackupbinlog
0 likes · 34 min read
How to Safely Clean Up MySQL Binlog When Disk Space Is Critical
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

IndexesOptimizationOracle
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
DataFunSummit
DataFunSummit
May 23, 2026 · Databases

Data Revolution in the AGI Era: Shifting from Human‑Managed to AI‑Governed Paradigms

As AI agents begin generating hundreds of lines of code and rapidly iterating database changes, traditional DBA manual review becomes obsolete; NineData’s AI‑native cloud‑native platform leverages intelligent SQL generation, automated review, and ChatDBA to boost development efficiency tenfold, cut repetitive work by 90%, and deliver high‑availability, secure, multi‑cloud data management at enterprise scale.

AI databasesCloud NativeDevOps
0 likes · 15 min read
Data Revolution in the AGI Era: Shifting from Human‑Managed to AI‑Governed Paradigms
MaGe Linux Operations
MaGe Linux Operations
May 23, 2026 · Databases

Why MySQL Replication Lag Isn’t Just a Network Issue

The article explains MySQL master‑slave replication fundamentals, shows how to monitor replication status, enumerates common delay causes such as network latency, master write pressure, SQL thread bottlenecks, large transactions, missing primary keys, slave overload, replication conflicts and GTID quirks, and provides scripts, configuration tips, and real‑world case studies for troubleshooting and prevention.

LagMonitoringPerformance
0 likes · 28 min read
Why MySQL Replication Lag Isn’t Just a Network Issue
Architect's Guide
Architect's Guide
May 23, 2026 · Databases

SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s

This article walks through a MySQL 5.6 case study where a sub‑query that originally took over eight hours is accelerated to a few milliseconds by analyzing the execution plan, adding single‑column and composite indexes, rewriting the query as EXISTS or JOIN, and applying best‑practice indexing techniques.

JoinSQL optimizationexecution plan
0 likes · 13 min read
SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s
ITPUB
ITPUB
May 22, 2026 · Databases

Quick Oracle DBA Guide: How to Pinpoint Database Hangs and Slowdowns

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.

10046 TraceADDMASH
0 likes · 10 min read
Quick Oracle DBA Guide: How to Pinpoint Database Hangs and Slowdowns
Ops Community
Ops Community
May 22, 2026 · Databases

How a Single Slow Query Triggered a Database Avalanche – Full SQL Optimization Walkthrough

A real‑world MySQL incident where a batch UPDATE with an IN‑subquery caused a full‑table scan, connection pool exhaustion, and a system‑wide outage, and the step‑by‑step investigation, emergency mitigation, and comprehensive optimization that reduced query time from 45 seconds to 0.3 seconds.

MonitoringPerformance tuningSQL optimization
0 likes · 20 min read
How a Single Slow Query Triggered a Database Avalanche – Full SQL Optimization Walkthrough
Architect's Guide
Architect's Guide
May 22, 2026 · Databases

How Indexes Speed Up Database Queries: A Clear Explanation

The article explains how database indexes work by comparing them to a book’s table of contents, describes underlying storage mechanisms, demonstrates binary search on sorted records, and discusses the benefits, trade‑offs, and common pitfalls of using clustered and non‑clustered indexes.

Binary SearchClustered IndexDatabase Indexes
0 likes · 12 min read
How Indexes Speed Up Database Queries: A Clear Explanation
Architecture & Thinking
Architecture & Thinking
May 22, 2026 · Databases

Redis Persistence Options Explained: RDB, AOF, and Hybrid Mode – Principles and Production Configurations

Redis, a high‑performance in‑memory database, offers three persistence mechanisms—RDB snapshots, AOF logs, and the hybrid RDB+AOF mode—each with distinct principles, performance trade‑offs, and configuration nuances, and the article provides detailed analysis, production case studies, and Go code examples to guide optimal selection.

AOFGoHybrid Mode
0 likes · 21 min read
Redis Persistence Options Explained: RDB, AOF, and Hybrid Mode – Principles and Production Configurations
dbaplus Community
dbaplus Community
May 21, 2026 · Databases

Is count(*) Really the Slowest? MySQL COUNT Performance Debunked

The article explains how MySQL implements COUNT(1), COUNT(*), COUNT(primary_key) and COUNT(column), showing that COUNT(*) and COUNT(1) have identical performance, COUNT(column) is the slowest, and provides indexing and approximation tips for large InnoDB tables.

COUNTInnoDBOptimization
0 likes · 9 min read
Is count(*) Really the Slowest? MySQL COUNT Performance Debunked
James' Growth Diary
James' Growth Diary
May 21, 2026 · Databases

Building a Neo4j Knowledge Graph: Entity Modeling, Cypher Queries, and LangChain Integration

This article walks through why graph databases excel at multi‑hop queries, compares Neo4j with relational and vector stores, explains core concepts of nodes, relationships and properties, shows Docker setup, demonstrates six common Cypher patterns, integrates LangChain for LLM‑generated queries, and shares production‑grade modeling tips and pitfalls.

CypherGraph DatabaseLangChain
0 likes · 19 min read
Building a Neo4j Knowledge Graph: Entity Modeling, Cypher Queries, and LangChain Integration
DataFunTalk
DataFunTalk
May 21, 2026 · Databases

How the Agent Paradigm Is Redefining Enterprise Data Infrastructure

The article examines how the rise of AI agents is reshaping enterprise data infrastructure, tracing software evolution from rule‑based systems to lakehouses and arguing that real‑time OLAP engines with sub‑second latency, hybrid search, and semantic schemas will become the core of the new Agent‑centric stack.

AgentData InfrastructureHybrid Search
0 likes · 13 min read
How the Agent Paradigm Is Redefining Enterprise Data Infrastructure
dbaplus Community
dbaplus Community
May 20, 2026 · Databases

Stunning SQL Queries: From Tetris Game to Real‑Time Funnels

This article showcases a collection of impressive SQL queries—including a PostgreSQL Tetris implemented with a recursive CTE, window‑function session analysis, a ClickHouse real‑time funnel, dynamic WHERE clause generation, and a recursive employee hierarchy—while discussing performance tips and engine choices.

ClickHouseData WarehouseHive
0 likes · 25 min read
Stunning SQL Queries: From Tetris Game to Real‑Time Funnels
IT Services Circle
IT Services Circle
May 20, 2026 · Databases

Why Can Redis Sustain Over 100k QPS? A Deep Technical Dive

The article explains how Redis achieves more than 100,000 queries per second by leveraging in‑memory storage, highly optimized data structures, a single‑threaded core with epoll‑based I/O multiplexing, optional I/O multithreading, and performance tricks such as pipelining and careful key sizing.

Data StructuresI/O MultiplexingIn-Memory Database
0 likes · 9 min read
Why Can Redis Sustain Over 100k QPS? A Deep Technical Dive
DataFunSummit
DataFunSummit
May 20, 2026 · Databases

Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search

Apache Doris 4.1 introduces a systematic evolution for AI and search workloads, adding low‑cost massive vector storage, unified structured, full‑text and vector search, 100 MB JSON document support, Segment V3 metadata decoupling, sparse column optimizations, lakehouse lifecycle management, and a suite of performance‑boosting features such as aggregate push‑down, condition cache, and spill‑to‑disk, all backed by detailed benchmark results.

AIApache DorisLakehouse
0 likes · 30 min read
Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

DatabaseIndexesPerformance tuning
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
May 20, 2026 · Databases

Deep Dive into Apache Doris’ Multimodal Capabilities: Architecture and Enterprise Deployments

Apache Doris 4.0 introduces native vector indexes, built‑in AI functions, and hybrid search, turning the OLAP engine into an AI‑centric analytics hub; the article details the technical design, performance optimizations, and real‑world deployments at ByteDance, Squirrel AI, NetEase and a security vendor, highlighting storage savings, query speedups and reduced operational complexity.

AI FunctionsApache DorisEnterprise Case Study
0 likes · 19 min read
Deep Dive into Apache Doris’ Multimodal Capabilities: Architecture and Enterprise Deployments