Skip to content

Instantly share code, notes, and snippets.

@victorpendleton

victorpendleton/identify_blocked_replication.sql

Created June 5, 2017 15:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save victorpendleton/d6bf500812891258c47917829f64e023 to your computer and use it in GitHub Desktop.
Save victorpendleton/d6bf500812891258c47917829f64e023 to your computer and use it in GitHub Desktop.
Download ZIP
Replication blocked
Raw
identify_blocked_replication.sql
SELECT p.id
, p.user
, p.host
, p.command
, p.time
, p.time/60 as minutes
, p.state
, substring(p.info, 1, 80) as snippet
FROM information_schema.processlist p
WHERE p.user IN ('system user')
AND p.state LIKE 'Waiting for table metadata lock'
ORDER BY p.time;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment