The Hotsos Symposium 2012 Speaker Spotlight is focusing on Baron Schwartz this week. We think you'll find his topic and abstract interesting. If you have not signed up for Symposium yet, you'll want to do so by December 31, 2011 to take advantage of discounted registration pricing. Visit registration to sign up. To view a list of the additional speakers, please go to the Speaker page.
Baron Schwartz is the Chief Performance Architect at Percona. He is the lead author of High Performance MySQL, and creator of Maatkit and other open-source tools for MySQL database administration. He is an Oracle ACE, and has spoken internationally on performance and scalability analysis and modeling for MySQL, PostgreSQL, and on system performance in general.
Presentation Title: Measuring and Forecasting Scalability and Performance form Network Traffic
Abstract: TCP network traffic is a good lightweight way to analyze and model system performance and scalability. This talk demonstrates a variety of performance and scalability analysis techniques on a single sample of TCP packet headers from a production database. No packet payload is necessary; the analysis relies exclusively on correlating inbound and outbound packets and their arrival times. This makes it practical to gather data from nearly any system with a call-and-response TCP protocol, such as the Oracle database or an HTTP web server. Packet headers are not regarded as privileged data in most organizations, which helps avoid red tape.
The talk demonstrates two techniques: time-series analysis of the data to determine whether there are performance problems or opportunities in the server.s behavior, and using the data as input to Neil Gunther's Universal Scalability Law to forecast both scalability and performance at load levels beyond what is measured. Both techniques are accomplished with readily-available open-source tools, including some authored by the presenter. The emphasis is on achieving practical results, not on deep mathematical explanations. The techniques demonstrated can help practitioners assess a server without great expenditures of time and effort.
We hope to see you at Symposium!