BestHub
Sign in
Tagged articles
35 articles
Page 1 of 1
Ops Community
Ops Community
Oct 4, 2025 · Databases

How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps

Facing a MySQL that suddenly becomes unresponsive in production? This article walks through the exact five‑step investigative process—checking process status, examining connections, locating lock waits, analyzing slow queries and system bottlenecks, and applying emergency recovery—illustrated with real‑world examples and command‑line snippets.

OperationsProduction Incidentdatabase troubleshooting
0 likes · 19 min read
How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

JSONSQL ModeSchema Migration
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
Sohu Tech Products
Sohu Tech Products
May 21, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating MySQL deadlock logs, analyzing their contents to pinpoint transaction timing, order, and lock details, and identifying the root cause of the deadlock, including special locking scenarios that can trigger deadlocks.

InnoDBSQLdatabase troubleshooting
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
Sohu Tech Products
Sohu Tech Products
May 14, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating the deadlock log, analyzing its contents to determine the time, order, and involved SQL statements, and pinpointing the root cause of MySQL InnoDB deadlocks, including special locking scenarios and how to interpret lock structures.

InnoDBLock AnalysisSQL
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2025 · Databases

Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution

This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.

InnoDBLock WaitSQL
0 likes · 9 min read
Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2023 · Databases

Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL

This article analyzes the MySQL ERROR 1499 caused by exceeding partition limits in OceanBase, examines server parameters, recycle‑bin settings, and tenant memory usage, and provides calculations and recommendations to expand memory or limit partition counts to prevent the error.

OceanBasedatabase troubleshootingmemory calculation
0 likes · 11 min read
Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL
ITPUB
ITPUB
Nov 3, 2022 · Databases

How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production

This guide explains how to detect MySQL deadlock exceptions, retrieve and interpret InnoDB deadlock logs and binlog files, and use the information to pinpoint conflicting SQL statements and fix the underlying lock issues in live systems.

BinlogInnoDBSQL
0 likes · 9 min read
How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production
Xiaolei Talks DB
Xiaolei Talks DB
Jun 6, 2022 · Databases

Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag

This article explains how to streamline TiDB 6.0 fault diagnosis by replacing manual screenshot and log collection with PingCAP's Clinic service and the TiUP Diag tool, covering data collection, upload procedures, security considerations, and additional diagnostic capabilities.

ClinicTiDBTiUP
0 likes · 19 min read
Master TiDB 6.0 Troubleshooting with PingCAP Clinic and Diag
Xiaolei Talks DB
Xiaolei Talks DB
Aug 25, 2021 · Databases

Fixing Aerospike Cluster Outage: Network Glitches, Memory Limits, and Rebalancing

After a network disruption caused Paxos messages to be ignored and memory shortages prevented data migration, this article details how the Aerospike cluster became unavailable, the diagnostic logs, and the step‑by‑step remediation involving node restarts, memory tuning, and adding new nodes for load balancing.

AerospikeData RebalancingMemory Management
0 likes · 12 min read
Fixing Aerospike Cluster Outage: Network Glitches, Memory Limits, and Rebalancing
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 23, 2020 · Databases

Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases

The article describes a puzzling MySQL 5.7 situation where any password works, investigates the cause as the auth_socket authentication plugin, provides exact SQL commands to fix the issue, and explains the plugin's security characteristics and appropriate deployment scenarios.

auth_socketauthentication plugindatabase troubleshooting
0 likes · 5 min read
Resolving MySQL 5.7 Login Issue Caused by the auth_socket Plugin and Exploring Its Use Cases
Youzan Coder
Youzan Coder
Apr 29, 2020 · Databases

MySQL Slow Query Analysis: Root Causes and Optimization Strategies

The article examines why MySQL queries become slow, detailing system‑level issues such as network latency, I/O bottlenecks, and CPU settings, alongside database‑level problems like missing indexes, type conversion, poor execution plans, lock contention, skewed data, and inefficient SQL patterns, and offers optimization strategies.

Database PerformanceIndex OptimizationInnoDB
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
FunTester
FunTester
Jul 31, 2019 · Databases

Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It

The author describes a sudden 30,000‑second slowdown in a simple MySQL join query, details systematic diagnostics—including network, server load, and query testing—and ultimately discovers a missing index on the user_info table, restoring it to bring response times back to sub‑second levels.

Index OptimizationSQL Joindatabase troubleshooting
0 likes · 4 min read
Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It
MaGe Linux Operations
MaGe Linux Operations
Oct 30, 2018 · Databases

Top 10 MySQL Error Cases and How to Fix Them

This article presents ten classic MySQL error scenarios—from connection limits and replication conflicts to permission issues and character‑set problems—explaining their root causes, diagnostic commands, and step‑by‑step solutions to help beginners and DBAs troubleshoot efficiently.

Error HandlingSQLdatabase troubleshooting
0 likes · 16 min read
Top 10 MySQL Error Cases and How to Fix Them
dbaplus Community
dbaplus Community
Feb 15, 2017 · Databases

How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB

This article walks through a real‑world Galera cluster outage, explains the replication and flow‑control mechanisms, details the step‑by‑step analysis of thread‑running spikes and wsrep delays, identifies a network‑induced port latency as the root cause, and describes the recovery actions taken to restore the Percona XtraDB Cluster.

Flow ControlGaleraNetwork Latency
0 likes · 9 min read
How to Diagnose and Fix a Galera Cluster Node Failure in Percona XtraDB
dbaplus Community
dbaplus Community
Dec 26, 2016 · Databases

Why Do Oracle RAC Nodes Crash? Uncovering Memory Leak Bugs in ocssd.bin

An Oracle RAC deployment across four identical clusters repeatedly experienced node crashes, each traced to ocssd.bin failures caused by a memory leak bug in CRSD/OCSSD processes (Bug 11704113), with analysis of logs, kernel parameters, and recommended patches and configuration tweaks to prevent recurrence.

CRS bugOracle RACdatabase troubleshooting
0 likes · 13 min read
Why Do Oracle RAC Nodes Crash? Uncovering Memory Leak Bugs in ocssd.bin
ITPUB
ITPUB
Aug 9, 2016 · Databases

Why Does Oracle RAC Throw ‘IPC Send timeout’ and How to Fix It?

The article explains the common Oracle RAC “IPC Send timeout” error, shows real alert‑log examples, analyzes root causes such as network loss, resource exhaustion, or bugs, and provides step‑by‑step troubleshooting methods including monitoring tools and configuration checks.

ClusterwareIPC Send timeoutNetwork Monitoring
0 likes · 11 min read
Why Does Oracle RAC Throw ‘IPC Send timeout’ and How to Fix It?
ITPUB
ITPUB
Apr 25, 2016 · Databases

Common MySQL Errors and How to Fix Them: A Practical Guide

This guide lists frequent MySQL error messages, explains their underlying causes, and provides step‑by‑step solutions—including configuration tweaks, permission adjustments, and server‑side fixes—to help developers quickly resolve database connectivity and query issues.

Error HandlingMySQL configurationSQL
0 likes · 25 min read
Common MySQL Errors and How to Fix Them: A Practical Guide
dbaplus Community
dbaplus Community
Feb 15, 2016 · Databases

How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes

This guide walks through a rapid 10‑minute troubleshooting workflow for MySQL and Oracle databases, covering resource checks, log inspection, wait‑event analysis, SQL identification, and feedback best practices to quickly pinpoint performance problems without relying on external monitoring tools.

OraclePerformance MonitoringSQL Analysis
0 likes · 9 min read
How to Diagnose and Report MySQL/Oracle Issues Within 10 Minutes