boris/watch_query.d

Created August 26, 2013 15:15

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/boris/6342565.js"></script>
Save boris/6342565 to your computer and use it in GitHub Desktop.

Download ZIP

This script will print all the queries executed by mysqld process. It should be run passing the PID of mysqld: dtrace -s watch_query.d -p `pgrep -x mysqld`

Raw

watch_query.d

	#!/usr/sbin/dtrace -q

	pid$target::mysql_parse:entry
	{
	printf("Query: %s\n", copyinstr(arg1));
	}

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