… reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to… default, now it’s on by default. If the IO::Socket::SSL Perl module is installed (easily available through your package… and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… use tcpdump on a database server to take a peek into a network stream and filter for packets that go to MySQL. Those packets contain queries. Here’s my quick one-liner which I will write in multiple lines: garfield ~ # tcpdump -i… communicate with MySQL through TCP sockets. When localhost (not to be confused with 127.0.0.1) is used as a MySQL host…
Comment: Gathering queries from a server with Maatkit and tcpdump
July 2, 2009 By 23 Comments
… tcpdump on my local dev server, but as far as I can see no packets are going through interface lo. Although mysql is connecting to localhost via PHP, I think it’s trying to use the unix socket rather than tcp/ip. Is there anyway to sniff packets from the socket to use the same…
