Data Management

MySQL 5.0 Performance Protocol Comparison

Date Added: Jun 2010
Format: PDF

The purpose of this paper is to present test results that clearly demonstrate the high performance of NetApp storage for typical 100GB MySQL Enterprise databases running on RedHat Enterprise Linux4 servers. To support these results, database Online Transaction Processing (OLTP) transaction throughput measurements for the major storage protocols are used: NFS, FCP, iSCSI. This paper includes a discussion of MySQL "Best Practices" for database layout and parameter settings in a NetApp storage environment.