Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2009
    Location
    Vancouver, BC
    Posts
    38

    Where's the bottleneck?

    We have two database systems, and a particular large query is 20 seconds on one, and about 45 seconds on the other. The query is just a lookup of all the accounts with a particular master account id, which is the primary key. It returns about 35,000 lines.

    What do you think may be the bottleneck in the slower of the two systems, as described below?:

    System 1 SLOWER:
    Oracle Linux in Oracle VM. Box not taxed by other vms.
    Oracle 10g DB
    LSI hw raid 6, enterprise SATA drives
    actual datastore is on a netapp FAS270, FC drives, raid 4, connected by nfs, 100baseT

    System 2, FASTER:
    Oracle Linux in Oracle VM. Box not taxed by other vms.
    Oracle 10g DB
    software raid 6 (mdadm) enterprise SATA drives

  2. #2
    Software RAID is slower than hardware raid since it is done on the OS level. How about the memory installed on those servers and the utilization.

    ./arun

  3. #3
    Join Date
    Oct 2009
    Location
    Vancouver, BC
    Posts
    38
    Quote Originally Posted by arunns View Post
    Software RAID is slower than hardware raid since it is done on the OS level.
    I would love to see data supporting this. Not assertions, but hard data.

  4. #4
    Join Date
    Oct 2009
    Location
    Vancouver, BC
    Posts
    38
    Quote Originally Posted by arunns View Post
    Software RAID is slower than hardware raid since it is done on the OS level. How about the memory installed on those servers and the utilization.

    ./arun
    Anyway, the software raid system is the FASTER one. That's why I put FASTER in capital letters in its description.

  5. #5
    If you system is utilized badly that can impact the software RAID performance unlike the hardware raid. The performance of software RAID always depends on the system resources and CPU. Google for some benchmarking done.

  6. #6
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    2,955
    Local disks especially with RAID (even with SW RAID) always beats NFS. Even more so for the fact that NFS store is connected via 100. How much data are you pulling from the DB? You mentioned 35000 lines. What's the byte size?

    Regards
    Joe / UNIXy
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    [ cPanel Varnish Nginx Plugin ] - Enhance LiteSpeed and Apache Performance
    www.unixy.net - Los Angeles | Houston | Atlanta | Rotterdam
    Love to help pro bono (time permitting). joe > unixy.net

Similar Threads

  1. Where's the bottleneck in my VPS?
    By jsp_1983 in forum VPS Hosting
    Replies: 4
    Last Post: 05-03-2011, 07:59 PM
  2. Where's the Bottleneck?
    By MrNiceGuy in forum Dedicated Server
    Replies: 3
    Last Post: 11-16-2007, 01:30 PM
  3. Finding the Bottleneck
    By xxclixxx in forum Dedicated Server
    Replies: 7
    Last Post: 11-07-2007, 03:49 AM
  4. VPS Bottleneck?
    By totenmaske in forum VPS Hosting
    Replies: 10
    Last Post: 04-17-2005, 03:06 AM
  5. Where is the bottleneck?
    By jojo235 in forum Hosting Security and Technology
    Replies: 4
    Last Post: 06-29-2004, 01:30 AM

Posting Permissions

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