This technical session highlights three benchmark tools that MySQL users and web developers can use to compare, test, and tune MySQL performance.

SPECjAppServer2004 is an industry standard workload that generates an oltp web workload and allows comparisons of database performance using industry published results.

EAStress is a low cost version of SPECjAppServer2004 that facilitates in-house performance comparisons between databases and database configurations.

FABAN is a transaction-oriented benchmarking tool that allows easy development of sophisticated web application workloads and, hence, allows for performance and scalability testing of MySQL.

This session will discuss each workload and how to use the workload to obtain optimum performance and tuning data for your MySQL implementation. A demonstration of creating and running an example benchmark with Faban will be shown, as well as some analysis of the Faban output that is valuable for tuning MySQL.

Tom Daly

Sun Microsystems, Inc.

Tom Daly is a senior performance engineer in Sun’s ISV Engineering organisation. Based in Adelaide Australia Tom has been working with independent software vendors and open source communities to improve java and database performance specifically performance of the Java Enterprise Edition (JEE) application platform used in conjunction with open source datasbases. Tom is a member of the team that has created the industry standard J2EE performance benchmark SPECjAppServer (www.spec.org) and is Sun’s representative the the SPEC osgjava subcommittee.