Skip to content

Instantly share code, notes, and snippets.

@altmind

altmind/gist:2296439

Created April 3, 2012 23:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save altmind/2296439 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save altmind/2296439 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
USE test;
CREATE EVENT PROF ON SCHEDULE EVERY 1 SECOND DO INSERT INTO test.PROF(COMMAND,HOST,STATE,INFO) SELECT COMMAND, SUBSTRING(HOST,1,INSTR(HOST,':')-1) as HOST, STATE, INFO FROM INFORMATION_SCHEMA.PROCESSLIST WHERE DB='product' AND Command!='Sleep'AND STATE IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment