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

phpinfo_perconamysql5155

whmcpanel_perconamysql5155

phpmyadmin_perconamysql5155

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

phpinfo_perconamysql558

whmcpanel_status_perconamysql558

phpmyadmin_perconamysql558


Previous:
Next:



MaxCDN Site Acceleration

Get Cost Effective Content Delivery
Unbeatable speed, stats, & price
http://www.maxcdn.com



Leave a Comment