In general, the performance of a database is based on several critical factors. The factors include, but not limited to, hardware, operating system, data schema, concurrency, volume of data, type of application, data access pattern and database configuration. To meet the business demands, your database application must address three vital constraints – Performance, Scalability and Reliability – each of which needs customization of different but correlated elements. In this whitepaper, we are going to explore different strategies to considerably optimize the performance of MySQL in HP-UX 11.23 IPF.

The most common technique for measuring performance is to take a black box approach that measures the Transactions Per Second (TPS) an application is able to execute against a database. In this scenario a “Transaction” is a unit of execution that a client application invokes against a database. This could be a simple read query or a grouping of updates done in benchmark applications. SysBench benchmark tool was used to measure MySQL’s performance in HP- UX 11.23 IPF.

Download