Skip to content

Instantly share code, notes, and snippets.

@carltondickson

carltondickson/useful.sql

Last active February 3, 2016 09:51
Show Gist options
  • Save carltondickson/c0e2ba76c9f752ef8f76 to your computer and use it in GitHub Desktop.
Save carltondickson/c0e2ba76c9f752ef8f76 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL useful queries
Raw
useful.sql
# Show running queries
SHOW FULL PROCESSLIST;
# Show who is connected
SHOW STATUS LIKE '%onn%';
# Search stored procedures for a string
SELECT * FROM information_schema.`ROUTINES` r WHERE r.`ROUTINE_DEFINITION` LIKE '%string%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment