Skip to content

Instantly share code, notes, and snippets.

@strokirk

strokirk/queries.mysql

Last active May 29, 2018 08:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save strokirk/3a49ef20391935e59346f1aba34005fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save strokirk/3a49ef20391935e59346f1aba34005fc to your computer and use it in GitHub Desktop.
Download ZIP
Database Information
Raw
queries.mysql
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `INFO` IS NOT NULL;
SELECT id, user, host, db, command, time, state, SUBSTRING(info, 1, 119) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `INFO` IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment