-1

I have a Linux Mysql server cluster where master and slaves are overloaded by a combination of read/write i/o and by SELECT queries load.

We purchased FusionIO cards to replace the hard drives. My question is whether to upgrade the servers themselves, or just replace the hard drives by FusionIO cards in the existing servers.

The existing servers have 266 MHz memory (Xeon E5345 - a bit outdated by now), while we can purchase servers with at least 1333 MHz RAM. We would rather not spend money on new servers, since FusionIO cards are already very costly.

We tested a FusionIO card in a brand new 1333MHz RAM server, and it gave us 4-5x speedup: but we do not know the contribution of RAM speed vs FusionIO.

What are the best practices on Linux to examine whether the RAM speed is a real bottleneck or not?

mercador
  • 101
  • 1
  • 1
    You _bought_ the FusionIO cards before you had any idea whether they would help or not? – Michael Hampton Apr 01 '13 at 02:20
  • @Michael Hampton - how did you make that assumption? I bought two test FusionIO cards and put them in brand new servers with 1333MHz RAM, and that gave us 4x speedup. What we do not know is what was the role of FusionIO versus RAM speedup. Thus the question. – mercador Apr 01 '13 at 02:32
  • Because you never mentioned anything about doing any tests. – Michael Hampton Apr 01 '13 at 02:33

1 Answers1

0

New servers > FusionIO on old servers...

Memory bus speed is probably not your bottleneck. The Intel 5300-series CPUs are four generations behind the currently-available CPUs.

Architectural differences as well a two MAJOR shifts in CPU technology (going from Harpertown to Nehalem and later, Westmere to Sandy Bridge) would account for most of the performance differences you may have experienced.

ewwhite
  • 194,921
  • 91
  • 434
  • 799