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 on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store