Analyze Your InnoDB Status
Paste the output of SHOW ENGINE INNODB STATUS below, or drag & drop a .txt/ .log file. Everything runs in your browser — no data is sent to any server.
Your text is analyzed instantly in your browser and is never sent to any server.
What is SHOW ENGINE INNODB STATUS?
SHOW ENGINE INNODB STATUS is a MySQL and MariaDB diagnostic command that outputs a detailed snapshot of the InnoDB storage engine's internal state. It covers buffer pool usage, active transactions, redo log metrics, file I/O throughput, semaphore contention, and the most recent deadlock — all in a single text block.
DBAs and backend engineers rely on this command during performance investigations, capacity planning, and incident response. Understanding the output is essential for diagnosing slow queries caused by lock contention, identifying deadlocks, and tuning buffer pool memory for optimal MySQL performance.
This tool parses the raw text from that command and presents each section as structured, visual data — so you can focus on fixing the problem instead of reading dense diagnostic output line by line.
What This Tool Analyzes
Buffer Pool Health
Hit rate, dirty pages, free buffers, memory allocation — visualize how efficiently InnoDB is using its in-memory cache.
Deadlock Detection
Identify the transaction victim, lock waits, and involved queries from the latest recorded deadlock.
Transaction Analysis
History list length, active transactions, and purge lag — spot long-running transactions before they become incidents.
Redo Log & Checkpoint
Monitor LSN, checkpoint age, and log I/O throughput to avoid redo log exhaustion under heavy write workloads.
Semaphore Waits
OS waits, spin rounds, RW-shared vs RW-excl contention — understand internal mutex pressure at a glance.
File I/O Performance
Reads/writes per second, pending flushes, and fsync stats to identify storage bottlenecks.
InnoDB Guides & Deep-Dives
Browse all guides →New to InnoDB diagnostics, or looking for a deeper explanation of a specific metric? Our guides cover every section of SHOW ENGINE INNODB STATUS — from deadlock anatomy to buffer pool tuning.
Locks & Concurrency
Transactions & MVCC
Memory & Buffer Pool
Supported MySQL & MariaDB Versions
- MySQL 5.7 — classic InnoDB status format
- MySQL 8.0 — updated log and transaction fields
- MySQL 8.4 LTS — latest long-term support release
- MariaDB 10.x — compatible format with minor differences
Format differences between MySQL and MariaDB versions are detected and handled automatically. You do not need to specify which version you are using.
Privacy & Security
This tool is 100% client-side. Your InnoDB status output is parsed entirely in your browser — no data is ever transmitted to any server. There are no network requests, no analytics, no cookies, and no tracking of any kind.
IP addresses found in the status output are automatically redacted, and SQL query literals are anonymized before being stored in memory. You can safely paste production diagnostics without risk of data leakage.