Querysniffer can be used to gather production data from your MySQL Server.

Requirements:

• perl
• libpcap

You have to run querysniffer as the root user. This is required to use the pcap library.
Options:
Usage: ./querysniffer.x64 [-i] [interface]
-i show IP addresses
-q generate output suitable for query{bench,parse} (implies options -est)
-e end queries with NULL
-s only print SELECTs (and USE db)
-t print timing data
-d debug

the [interface] lets you specify a ethernet port you want to listen on.

Download:

querysniffer source and binaries