Server Performance

Posted by sb12 on Server Fault See other posts from Server Fault or by sb12
Published on 2012-09-21T21:48:45Z Indexed on 2012/09/22 3:39 UTC
Read the original article Hit count: 572

I know very little about performance tuning of servers etc... so i thought i'd put this up here as i start some research on it, just to get some direction.

I am in the process of migrating from my old server to a new one - both are 64 bit machines. One is a few years old, the other brand new (PowerEdge R410).

The old server spec is: 2 cpus, 3.4GHz Pentiums, 8G of RAM, Fedora 11 currently installed

The new server spec is: 16 cpus, 3.2 GHz Xeon, 16G of RAM, CentOS 6.2 installed. Also RAID10 is on the new server - no RAID on the old one.

Both servers currently have the same database (MySQL) with the same data migrated.

I wrote a Perl script that simply steps through each row of a table in the database (about 18000 rows) and updates a value in that row. Every row in the table is updated.

Out of curiosity i ran this perl script on both machines, just to see how the new server would perform vs. the old one, and it produced interesting results: The old server was twice as fast as the new one to complete.

Looking at the database, both are configured exactly the same (the new one being a dump of the old one...)...

Anyone any ideas why this would be given the hardware gap between both?

As i said i'm about to start some digging, but thought i'd put this up here to maybe get some good direction....

Many thanks in advance..

© Server Fault or respective owner

Related posts about mysql

Related posts about Performance