WHM/Cpanel – Percona 5.1.55 & 5.5.8 MySQL Installation
Tried and tested MySQL 5.5.10 on WHM Cpanel server, so next up is Percona 5.1.55 rel 12.6 and Percona 5.5.8-20 Beta installations. The purpose is in preparation for MySQL benchmarks on Quad Intel Xeon L7555 Nehalem-EX Octo-Core server (64 cpu cores) with 64GB DDR3 memory.
I’ll end up comparing MySQL 5.0.92, MySQL 5.1.55, MySQL 5.5.10, MariaDB 5.2.5 and Percona 5.1.55 and 5.5.8 beta for both MyISAM and InnoDB performance and how each respective version scales from 1 to 64 cpu cores. Interesting results when you benchmark against different linux schedulers – cfq, deadline and noop.
Follow me on twitter for notice when the benchmarks come out.
Percona 5.1.55 rel12.6 MySQL
mysqladmin Ver 8.42 Distrib 5.1.55, for unknown-linux-gnu on x86_64 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.1.55-rel12.6 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.200
Percona 5.5.8-20 Beta MySQL
mysqladmin Ver 8.42 Distrib 5.5.8, for Linux on x86_64 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.5.8-55 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 min 34 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 9 Queries per second avg: 0.32