Performance questions regarding dual Xeons.
Hi,
I have recently been looking to buying a new dedicated server for my MySQL
database. My current installation runs on the same machine as my webserver
which you might realise isn't very optimal.
The specifics of my environment are; quite low number of queries per
second, at the moment around 6-7, this number is however quite limited by
the fact that many of my queries take up to 4 or 5 seconds to run
(fulltext searches in a 1 million row table + a couple of simple joins.
Data is about 1 gb large). Most of these queries are reads, but I also have
tables where there are plenty of inserts. And at the same time there are
inserts into my "main" table, which has at some times caused lockups.
(INSERT DELAYED crashes MySQL after a few hours for instance).
Also, I want something to grow with, and have several other projects, so I
can afford to spend [some] money on extra hardware at this moment. If there
are unused resources I can always utilise them for other projects while my
main one grows.
I have been looking at the DELL Poweredge 1800/50 since the 2800-series are
a little bit to pricy for me. Most likely I will be running SCSI since I
have understood that SATA doesn't come thru when there is more IO.
However I have noticed several benchmarks really throwing 64bit Xeons off
the chair. Namely
http://www.anandtech.com/IT/showdoc.aspx?i=2447&p=5 and
http://www.tomshardware.com/cpu/20030422/opteron-17.html.
After viewing the webinar at
http://www.mysql.com/news-and-events/on-demand-webinars/mysql-performance-tuning.php
I however felt somewhat better about dual CPUS and HT. According to
http://www.dell.com/downloads/global/solutions/mysql_network_2800.pdf
there is alot to gain from adding an extra CPU.
- Is there anyone here running dual setups and could let me know if my
money is well spent on a Xeon dual setup at around $4000 where I perhaps
get 50% extra performance at the cost of about $1400 compared to a single
Opteron?
- Am I do the right choice going for dual Xeons instead of dual Opterons?
Ofcourse reliability is a huge issue here.
- Are the above benchmarks really appropriate in a production environment?
- Thoughts and comments, feel free to let me know what you think.
Regards,
Hjalmar Wåhlander