Results 1 to 9 of 9
  1. #1

    E6600 is slower than P4 2.8G??

    i had an p4 2.8g db server, centos4+mysql4.1. the cpu usage went up to 9X% at peak time (web pages loaded within 2~3sec), so i decide to swtich to a new server with a faster cpu. the new box is core 2 duo e6600, centos5+mysql5.0, having same RAM and HD with the old box. surprisingly , the cpu usage keeps above 150% almost all the time, and web pages cost 10+seconds to load at peak time.

    how is it possible? what is the problem here? is the cpu, os, or mysql?

  2. #2
    Join Date
    Aug 2002
    Posts
    484
    The E6600 is much, much faster than the Pentium 4 2.8 GHz.

  3. #3
    Join Date
    Jun 2004
    Location
    Tampa Florida
    Posts
    428
    Remember that Mysql 5 is a good deal slower than 4.1 So that is going to cause more load. You will want to look over what is running on the OS. As a web server, when apache and mysql arent running, there should only need to be about 10 to 20 processes running on the system. By default, CentOS5 has a lot of stuff running taking up CPU time.
    Rock solid hosting and dedicated servers since 1998!
    StabilityHosting Where stability and uptime are king!

  4. #4
    Join Date
    May 2006
    Location
    NYC, US
    Posts
    27
    Hello,

    - Centos 5 in your new box, is it 64 Bit ?
    - Are old rams ok for new server's main board ?

  5. #5
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,309
    I dont have E6600, but my E6300 is running much better than the old P4 3GHz.

  6. #6
    Join Date
    Dec 2006
    Posts
    480
    Remember that Mysql 5 is a good deal slower than 4.1
    What are you basing that on? When I was looking at a new box, I load tested a site using 3.23, 4.0, 4.1 and 5.0 with identical configuration settings when a feature was present in both versions, and found each newer version to be faster than its predecessor.

    bjhuang: Check the mysql configuration file for both servers - maybe you aren't allocating enough memory to it in the new box or run mysqlreport from hackmysql.com

  7. #7
    Join Date
    Mar 2005
    Location
    Maine, USA
    Posts
    311
    Try installing the SMP kernel and see if that makes a difference. Also could try the 64bit version, but I am not sure if you need to reinstall to do that.

  8. #8
    Code:
    # uname -a
    Linux dbserver 2.6.18-8.1.8.el5.centos.plus #1 SMP Sun Jul 15 12:09:29 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
    ram is more than enough. ram usage keeps at 800M while the box has 2G.

    there are no other unnecessary stuff running. mysqld takes 100%~200% of cpu in the TOP result all the time.

    the my.cnf was copied from old to new box.

    the apache service is running on the other box with centos4 and php4. could this be the problem? i mean php4+mysql5...?

  9. #9
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,309
    you can not use the same my.cnf for every box, especially with different hardware. Try to optimize it again with your current box

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •