Skip to content

Instantly share code, notes, and snippets.

@geraldvillorente

geraldvillorente/gist:94e9bd953c01a4ce8dad

Last active October 26, 2017 05:07
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geraldvillorente/94e9bd953c01a4ce8dad to your computer and use it in GitHub Desktop.
Save geraldvillorente/94e9bd953c01a4ce8dad to your computer and use it in GitHub Desktop.
Download ZIP
MySQL show processlist in realtime
Raw
gistfile1.txt
watch -n1 'mysql -uUSER -pPASSWORD --execute="SHOW PROCESSLIST"'
@tunggnu
Copy link

tunggnu commented May 8, 2017

watch -n1 'mysql -uroot --execute="SHOW FULL PROCESSLIST"'
(tested with mysql 5.7)

I think the proper option is --execute not --exec

@geraldvillorente
Copy link
Author

Oh yes. Thank for pointing out @tunggnu.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment