]]> ]]>

MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic

You are here

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.

February, 2012


Authors

Baron Schwartz

Baron Schwartz

-

Baron is the lead author of High Performance MySQL and the creator of Maatkit, which later became Percona Toolkit.



Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>