Advertisement:

Author Topic: New SQL Server  (Read 316354 times)

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: New SQL Server
« Reply #120 on: May 02, 2009, 02:14:26 PM »
Yes, we use a *very* customized LAMP setup.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool
     

Offline neetusharma

  • Newbie
  • *
  • Posts: 6
Re: New SQL Server
« Reply #121 on: May 04, 2009, 06:10:00 AM »
hi gd news

Offline ოկtђ

  • Sr. Member
  • ****
  • Posts: 858
  • Gender: Male
  • Burak
Re: New SQL Server
« Reply #122 on: May 30, 2009, 08:21:46 AM »
Wow its great.

Offline /\takan

  • Jr. Member
  • **
  • Posts: 116
  • Gender: Male
    • Atakan USLU Kisisel Web Sitesi
Re: New SQL Server
« Reply #123 on: June 22, 2009, 04:42:31 AM »
Thanks..

Offline Eliana Tamerin

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,611
  • Gender: Female
Re: New SQL Server
« Reply #124 on: June 22, 2009, 12:21:50 PM »
Yes, we use a *very* customized LAMP setup.

So customized, that when one of Amy's dogs sing, the server does a fsck. :P
Do NOT PM me for support.

SimplePortal 2.3.6 is OUT!
SimplePortal Project Manager
Download | Docs
SimplePortal: Power of Simplicity!

Offline Ben K

  • Jr. Member
  • **
  • Posts: 384
  • Gender: Male
  • Netstat going crazy, war begain, chips going down!
Re: New SQL Server
« Reply #125 on: August 16, 2009, 04:31:11 PM »
Can some one upload a picture of that "monstor" ? :D

Offline dschwab9

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,320
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #126 on: August 20, 2009, 10:45:05 PM »
Can some one upload a picture of that "monstor" ? :D

Not very clear. but here's a couple of pics.

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #127 on: August 20, 2009, 10:48:24 PM »
Wow....do you have people sitting there or somethin' :P
Yigal V.
Contact me by PM

do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

Offline dschwab9

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,320
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #128 on: August 20, 2009, 10:52:21 PM »
Wow....do you have people sitting there or somethin' :P

No, but I keep updated pics of the rack layout in case I have to walk someone through handling an issue remotely  ::)

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,695
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New SQL Server
« Reply #129 on: August 21, 2009, 12:58:32 AM »
Wow....do you have people sitting there or somethin' :P

No, but I keep updated pics of the rack layout in case I have to walk someone through handling an issue remotely  ::)

That's really a good idea. :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,072
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
Re: New SQL Server
« Reply #130 on: August 21, 2009, 11:03:59 AM »
No, but I keep updated pics of the rack layout in case I have to walk someone through handling an issue remotely  ::)

That's really a good idea. :)

Great idea indeed, but that wouldn't have helped at the previous data center my company was with.

They banned all cameras from the data center floor. Then again, they were the main peering point for the fiber loop in the region and had companies like Bandai (there was a full-size Power Ranger / Super Sentai doll in their cage), Washington Mutual, and Yahoo! on the floor so it may have been justified for privacy.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Offline Amacythe

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,060
  • Gender: Female
Re: New SQL Server
« Reply #131 on: August 22, 2009, 04:38:32 AM »
Wow....do you have people sitting there or somethin' :P

Of course we do... dschwab9 is kept chained in the cage ;)

Offline ѕησω

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,432
  • Gender: Male
  • Nisi credideritis, non intelligetis.
    • wade.poulsen93 on Facebook
    • acans on GitHub
    • https://www.linkedin.com/profile/view?id=145186638 on LinkedIn
    • @imacans on Twitter
    • Acans
Re: New SQL Server
« Reply #132 on: August 22, 2009, 09:01:41 AM »
Wow....do you have people sitting there or somethin' :P

Of course we do... dschwab9 is kept chained in the cage ;)

Who comes to feed him now the oldiess is in marketing
"The Book of Arantor, 17:3-5
  And I said unto him, thy database query shalt always be sent by the messenger of $smcFunc
  And $smcFunc shall protect you against injections and evil
  And so it came to pass that mysql_query was declared deprecated and even though he says he is not dead yet, the time was soon to come to pass when mysql_query shall be gone and no more."

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #133 on: August 23, 2009, 10:09:51 PM »
We have an automatic system that feeds it him.  xD
Yigal V.
Contact me by PM

do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

Offline Bas

  • Jr. Member
  • **
  • Posts: 371
  • Gender: Male
  • Ex MSI forum Admin.
    • HardwareGurus.net
Re: New SQL Server
« Reply #134 on: September 01, 2009, 02:31:18 PM »
Hey guys, just wanted to give everyone an update on the site status.

We have just completed migrating our SQL databases to a brand new box. The new machine is a 2.5GHz 8 core machine with 12GB of RAM and 6 146GB 10,000 RPM SAS drives in RAID 10. This should dramatically improve the speed of the forums.

The number of cores is unimportant for database servers, sorry but it doesn't do much.
And 10K SAS drives? Do they still make those?
I would use 15K SAS drives and put them in RAID5.
As for the CPU, bad choice, you better have gone 2~4 AMD DUAL/QUAD core in NUMA config, that will give you a memory bandwidth that's incredible.
Cores only help if you have enough memory-speed to support it, databases typical need a lot of memory speed, CPU speed is second to that.
12GB, sorry, useless, as your memory speed is too slow for 8 cores to keep busy at all, I bet most cores are idle.
Greetings Bas.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,816
    • StoryBB/StoryBB on GitHub
Re: New SQL Server
« Reply #135 on: September 01, 2009, 06:11:21 PM »
Actually, the number of cores does make a difference; MySQL scales differently on different cores. Plus when you have sufficient RAM to cache things in memory (and/or have MEMORY based tables in MySQL), ability to process in parallel is actually kind of important too.

Remember, how this site is configured is not the same as other forums, and likely has a lot pushed into memory-based storage.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline rsw686

  • Sophist Member
  • *****
  • Posts: 1,008
    • The Reptile File
Re: New SQL Server
« Reply #136 on: September 01, 2009, 08:30:33 PM »
The number of cores is unimportant for database servers, sorry but it doesn't do much.
And 10K SAS drives? Do they still make those?
I would use 15K SAS drives and put them in RAID5.
As for the CPU, bad choice, you better have gone 2~4 AMD DUAL/QUAD core in NUMA config, that will give you a memory bandwidth that's incredible.
Cores only help if you have enough memory-speed to support it, databases typical need a lot of memory speed, CPU speed is second to that.
12GB, sorry, useless, as your memory speed is too slow for 8 cores to keep busy at all, I bet most cores are idle.

I agree with the 15k drives. The more IOPs you can push the better. However whats the point of 15k drives if you want to run them in RAID 5. RAID 5 has a write overhead that RAID 10 doesn't have. The IOP load of a database server will benefit from RAID 10.

12GB of memory should be more than sufficient for this site. If each post averaged 2KB the database with 2 million posts would be around 4GB plus indexes, which doesn't even come close to 12GB. As long as it is running a 64bit OS mySQL should have plenty of memory to cache with.
The Reptile File
Everything reptile for anyone reptile friendly

Aquaria Talk
Community for freshwater and saltwater aquariums enthusiasts

Offline dschwab9

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,320
  • Gender: Male
    • Technology, Ministry and Other Ramblings
Re: New SQL Server
« Reply #137 on: September 03, 2009, 08:56:31 PM »
Guys, I hate to be the bad guy, but that is incorrect. Processing cores and memory trump everything with the type of workload we have here. MySQL multithreads very will and the load stays distributed fairly evenly. We are currently running 16 MySQL threads and performance is great.

Disk speed - yeah, faster is always better, but the difference in performance between a 10K and a 15K drive is minimal and not worth the added cost in our situation. We have a relatively small dataset - around 10GB with lots of traffic - over 300 queries per second at times. Why would you want to have no memory and fast disks that you thrash constantly? Having lots of RAM and heavily using the query and table caches outperforms fast disks by a long shot. The bottleneck is the GigE connecting everything together, not disk, memory, or CPU speed. Just checked the server and we are currently using about 11GB of RAM.

Also, yes, RAID 5 isn't the best for a database server. However, we are not running RAID 5.  ;D

Offline Kill Em All

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,144
  • Gender: Male
  • Something has to go wrong. Just has to.
    • KEAGaming
Re: New SQL Server
« Reply #138 on: September 04, 2009, 12:47:49 AM »
Genius! Very excellent post dschwab9! Well informative. :)
My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Offline Hell Raiser

  • Jr. Member
  • **
  • Posts: 384
  • Gender: Male
Re: New SQL Server
« Reply #139 on: September 04, 2009, 06:54:21 AM »
11GB RAM

Short it down to 8GB and let me borrow other 3GB's of RAM for my PC :P
Need Help with SMF ? Ask me may be i can help you out