> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Query Latency p50 (ms), MySQL

> Query Latency p50 (ms) for MySQL instances. Tracked live in Vortex IQ Nerve Centre. How to read it, why it matters, and how to act on it.

**Card class:** [Non-Hero](/nerve-centre/overview#card-classes-explained)  •  **Category:** [Performance](/nerve-centre/connectors#connectors-by-type)

## At a glance

> **Query Latency p50 (ms)** is the median statement execution time: half of all queries in the window finish faster than this number, half slower. It is the "typical experience" latency, the steady baseline against which the tail percentiles (p95, p99) are read. A stable, low p50 means the common path is healthy; a rising p50 means the whole workload is slowing down, not just the outliers.

## What it tracks

The card reports the median query latency in milliseconds over a real-time, 5-minute view (`RT/5m`). It is derived from statement timing in MySQL's Performance Schema, principally `events_statements_summary_by_digest`, where each digest carries timing buckets that the engine aggregates into a percentile distribution. The p50 is the 50th-percentile point of that distribution across all statements executed in the window.

Read p50 as the baseline of the workload. Because it is the median, it is resistant to a handful of slow outliers: one runaway report does not move it. That is exactly why it pairs with the tail cards. If p50 is flat but [Query Latency p95 (ms)](/nerve-centre/kpi-cards/mysql/query-latency-p95-ms) and [Query Latency p99 (ms)](/nerve-centre/kpi-cards/mysql/query-latency-p99-ms) are climbing, the problem is in the tail (lock waits, a few un-indexed paths). If p50 itself rises, the common path has degraded and the cause is usually systemic: buffer-pool pressure, disk saturation, or a sustained throughput surge. This card carries no alert threshold; the tail cards hold the alerting, and p50 supplies the baseline that makes their movement interpretable.

## Reconciling against the source

Confirm on the instance with `SELECT AVG_TIMER_WAIT/1000000000 AS avg_ms, DIGEST_TEXT FROM performance_schema.events_statements_summary_by_digest ORDER BY SUM_TIMER_WAIT DESC;` (timer values are in picoseconds, so divide by 1e9 for milliseconds), or use `sys.statement_analysis` for a friendlier view. On Amazon RDS, Performance Insights surfaces per-digest latency; on Cloud SQL and Azure, read the equivalent Performance Schema views directly.

***

### Tracked live in Vortex IQ Nerve Centre

*Query Latency p50 (ms)* is one of hundreds of KPI pulses Vortex IQ tracks across MySQL and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

[Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.