Sun reports that the open source MySQL 5.0.18 database running an online transaction processing (OLTP) workload on the SolarisTM 10 Operating System (Solaris OS) and Sun FireTM V40z servers powered by dual-core AMD Opteron Model 875 processors executed functions up to 64 percent faster in read/write mode and up to 91 percent faster in read-only mode than when it ran on the Red Hat Enterprise Linux 4 Advanced Server Edition OS.
"MySQL and Sun have worked to optimize the performance of MySQL Network software certified for the Solaris 10 OS," said Zack Urlocker, vice president of marketing for MySQL AB. "This benchmark demonstrates Sun's continued leadership in delivering a world-class operating environment that provides excellent MySQL performance for our mutual enterprise customers."
The MySQL Innodb SysBench OLTP benchmark testing generated data points at 11 different load levels, starting with one concurrent user connection (CUC) and gradually doubling that number, up to a high of 1024 CUC.
The primary difference between the 8-way Sun Fire V40z servers and Red Hat Enterprise Linux 4 Advanced Server Edition OS was in the underlying operating system, Sun reports, keeping the hardware configuration and database properties the same. During the read/write test, both systems reached their saturation point at eight CUC, at which point the the server running the Solaris 10 OS was 30 percent faster. Additionally, the Sun Fire V40z server running the Solaris 10 OS was running database queries at a 64 percent better rate on average, when compared to the server running Linux.
The read-only test magnified the Solaris 10 OS advantage where performance exceeded the Linux test case by 91 percent. Peak performance under the Solaris 10 OS was achieved with 16 CUC, while Red Hat Linux tapered off at eight CUC. Despite running at twice the load during the peak phase, the Solaris 10-based server was performing 53 percent more transactions per second than the Linux-based server.
Read More ...