Troubleshooting MySQL Slow Queries with Tcpdumps

"MySQL has a wonderful facility for capturing slow queries called the slow query log. However if yours is not enabled when trouble occurs, and restarting the database is not an option, you'll need another solution. This is where a tcpdump can come in handy. It can be used to watch a network interface and display the packets and traffic. What Is A Tcpdump?

"Tcpdump is a Linux command for watching a network interface, and displaying traffic that moves across it.

"On my Mac, the airport network interface (en1) is my main connection to the internet. You may well want to use eth0 there. So, I can do some packet sniffing with tcpdump as follows:"

Complete Story

Related Stories:

• Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Fedora 14(Dec 20, 2010)
• Oracle Releases MySQL 5.5(Dec 15, 2010)
• Optimizing MySQL Query Retrieval Speed Through Table Joins(Dec 10, 2010)
• The state of MySQL forks: co-operating without co-operating(Dec 06, 2010)
• MySQL vs. PostgreSQL, Part 1: Table Organization(Dec 01, 2010)
• Comparing MySQL and Postgres 9.0 Replication(Nov 18, 2010)