BestHub
Sign in
Tagged articles

SHOW commands

3 articles · Page 1 of 1
Architect Chen
Architect Chen
Sep 6, 2026 · Databases

2026 MySQL DBA Command Reference: 9 Essential Commands Explained

This comprehensive guide details nine essential MySQL DBA commands — SHOW DATABASES, SHOW TABLE STATUS, SHOW FULL PROCESSLIST, SHOW ENGINE INNODB STATUS, SHOW VARIABLES, SHOW STATUS, EXPLAIN, SHOW INDEX, and SHOW CREATE TABLE — with syntax examples, key output fields, and practical troubleshooting scenarios for performance tuning and database administration.

DBADatabase AdministrationEXPLAIN
0 likes · 6 min read
2026 MySQL DBA Command Reference: 9 Essential Commands Explained
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 MonitoringSHOW commandsSQL optimization
0 likes · 10 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
dbaplus Community
dbaplus Community
Oct 10, 2022 · Databases

How to Collect Comprehensive MySQL Metrics Using Only Built‑In SHOW Commands

This guide explains how to gather extensive MySQL monitoring data—including connections, buffer cache, locks, SQL activity, statement counts, throughput, server variables, and slow‑query analysis—solely with MySQL's native SHOW statements, providing low‑overhead, real‑time insight for database administrators.

MySQLSHOW commandsdatabase metrics
0 likes · 10 min read
How to Collect Comprehensive MySQL Metrics Using Only Built‑In SHOW Commands