Hotsos Symposium Speaker – Baron Schwartz

Baron Schwartz is a new Hotsos Symposium presenter.

Biography

Baron SchwartzBaron 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 From 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.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: