MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic
The TCP network traffic conversation between a client and a MySQL server is a rich source of data for many types of analysis. In this paper, we show how the simplest type of traffic packet headers with no payload can provide a surprising variety of information about the system’s performance. The techniques that we demonstrate are quick, require only readily available open source software, and permit “black box” analysis of a system without any a priori knowledge.
Our MySQL white papers are free and require no registration to download. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.