Dual Xeon / Opteron for Dedicated MySQL server ?

[hichew]

Dual Xeon / Opteron for Dedicated MySQL server ?

Dual Xeon 2.8 800 FSB w/HT and 64EMT - SCSI
Dual AMD Opteron 246 - SCSI

Which one is good for MySQL server ? Both with 2 Gig RAM
2000-3000 users accessing vBulletin with 3000 cookies session

[AlfonsoC]

Opterons for sure... I work daily with some large Opteron DB servers and are the best for rolling over DB's. Opterons have lots of Bandwidth from CPU to memory (in fact, with DDR400 memory only one Opteron processor has almost the same bandwidth than a Dual Xeon system).

Databases love memory bandwidth, not pure CPU power. But don't panic, with Opterons you have too raw CPU power along lots of Mem BW.

3000 connections to a DB? huh, that's a lot of connections, which kind of stats you have and which forum stats you have for needing such quantity of connections? Post more info, please and we can give you more insight regarding the machine you should need.

[hichew]

yes... i had 2000-3000 users online with 3000 cookies timeout ...
right now lots of vB features have been disabled to accomodate this.

and i turned off the log stats & daily backup.
we had roughly 14.277.437 page views/month

So what do you think If I get
- Opterons 246 with SCSI HD & 2 Gb for Database Server
- Dual Xeon 2.8 with 80 IDE & 2 Gb for Webserver

Do you think it will sufficient enough?

[eva2000]

Dual Xeon / Opteron for Dedicated MySQL server ?

Dual Xeon 2.8 800 FSB w/HT and 64EMT - SCSI
Dual AMD Opteron 246 - SCSI

Which one is good for MySQL server ? Both with 2 Gig RAM
2000-3000 users accessing vBulletin with 3000 cookies session
read http://www.vbulletin.com/forum/showthread.php?t=160103 dual opteron 246 is more equivalent to around dual p4 3.4ghz xeons

is this same forum as http://www.vbulletin.com/forum/showthread.php?t=163795 ? as there you state 500-1000 vB users over 1500s cookie time out ? from that thread you're only using 273 mysql concurrent connections so seems the load you're currently experiencing is more apache/web end than database end

i'd use dual opterons for both web and database end if you can as http://www.vbulletin.com/forum/showthread.php?t=160103 shows apache concurrency tests but mysql concurrency is as high a boost if not higher than apache for opterons over xeons

web
dual opteron 248
2gb ram
scsi disk

db server
dual opteron 248
3gb ram
scsi disks

[hichew]

yes it's the same server.
let me clarify the users online & cookies time out

time out for cookie is : 3500
user online right now : 3153 users

00:48:10 up 13 days, 3:07, 2 users, load average: 1.80, 3.41, 4.04
545 processes: 544 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 1.6% 31.5% 3.7% 0.0% 1.8% 6.4% 54.7%
cpu00 1.9% 31.6% 4.9% 0.0% 6.9% 5.7% 48.7%
cpu01 0.3% 29.8% 2.3% 0.0% 0.0% 10.0% 57.3%
cpu02 1.5% 37.8% 3.1% 0.0% 0.3% 4.5% 52.4%
cpu03 2.5% 26.7% 4.5% 0.1% 0.0% 5.5% 60.3%
Mem: 3082360k av, 2341596k used, 740764k free, 0k shrd, 76972k buff
1634540k actv, 428048k in_d, 47340k in_c
Swap: 2096440k av, 308148k used, 1788292k free 909792k cached


and the server is really slow... *just installed APC*

[eva2000]

380MB of disk swapping will slow down your server!

[hichew]

any suggestion eva2000 ? please..

[AlfonsoC]

Seeing the actual data, and breaking some rule of mine... I'll give you a hardware config.

- Dual Opteron 248. Look for a MB with memory banks for each processor (8 memory DIMMS is the usual), try to avoid MB's with 6 or 4 memory banks.

- 4Gb RAM (4*1Gb DIMM). Registered w/ECC Memory. Don't lose your time looking for speedy memory here, the bes memory you can get is DDR400 with 3,3,3,6 timings. Reliability is the king here.

- SCSI RAID Controller on RAID10. (A good one: LSI Logic MegaRaid 320-2X). A stripe size of 32Kb or 64Kb is fine. Don't go under those values (8 or 16Kb stripe size) or you will go with too much overhead. This controller has 128Mb of RAM (upgradeable) but doesn't come with a Battery backup unit. Double check that write-back caching is active without the battery - much possibly you'll need to force it from the setup program of the controller.

This controller has 2 independent channels, save the second channel for a future time (put up to 8 disks max per channel - over here starts loosing performance).

- 4 SCSI 36Gb Ultra320 Disks. (Some real fine: Fujitsu MAU3036NP 15krpm). This will give you 72Gb of net space - 144Gb before RAID.
You can add more disks to reduce the load over them and for growing the space and I/O capability - disks are needed to be added in pairs). You can perform RAID online migration or add the disks totally on-line without downtime, plug and power them, add them to the RAID volume and will be done in background.

You can go for 10Krpm disks to save a little, but I prefeer to have such extra of I/O capability, doesn't hurt anything to have such margin.

Don't know if this fits on your pocket, but asked for a hardware config and this will serve you without any problems. I use a similar hardware config at work and I'm quite confident of their capabilities.

[kontrabass]

Thought I'd chime in as a dual Opteron user. I've never seen a faster system. I've got average 500 users online (90 sec cookie), and my database server, with nearly every feature setting in vbulletin turned on, never goes above 0.2 load average. 15k rpm drives in Raid 1 really help too (or raid 10).

I'm just sorry I wimped out and went with a P4 for the front end... It's bogging me down.

[hichew]

Where I can get an opteron dedicated from ?
ThePlanet doesnt offering Opteron.

[eva2000]

best place to check what's out there is http://webhostingtalk.com/