JAEN

SQL

SHOW STATUS / VARIABLES

SafeServer status & variables

SHOW GLOBAL STATUS LIKE '<pattern>';

Runtime stats and config values. Comparing Threads_connected to max_connections finds exhaustion.

Examples

  • SHOW GLOBAL STATUS LIKE 'Threads_connected';Current connections

Syntax

SHOW [GLOBAL] STATUS|VARIABLES [LIKE 'pattern'];

Before you run it

Read only.

Used when you see

Slow database queries
4
Review server status variables too
See the whole flow →
Can't connect to the database
3
Compare current vs max connections
See the whole flow →
Replication lagging or stopped
3
Use status variables to find the bottleneck
See the whole flow →

Related commands

The same reference, with no signal at all

Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.

Get it free on the App Store