DFW Mustangs    

Go Back   DFW Mustangs > General > Technology Rules

Technology Rules iPhone suxx, Q/A for all computer, networking, phone, and gaming issues

Reply
 
Thread Tools Display Modes
Old 03-18-2017, 12:13 PM   #1
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default Need some high ghz cpu advice

I run a database server that is used primarily for analytics queries. Since sort statements are single threaded, more GHZ is preferred over more cores. Currently I am using Xeon processors that turbo to 3.8GHz, but I would like to get more performance out of the database servers. Unfortunately overclocking on the Dell's I have is not possible. I have extremely high IO throughput so feel safe from that perspective ( right now I'm using a Intel 750 1.2Tb pcie card ), and my CPU's typically have 1-3 maxed cores at any given time which would indicate a CPU bottleneck.

I would like to try overclocking my desktop CPU's, I have an i7-4790K and a i7-5820k that I can use to test with. Google searching has many results, but wondered if any of you had tried and true methods that I could go off of.

Also, what the hell is the fastest stable processor out on the market right now. I see AMD is sporting some ridiculous clock speeds, but does that really spill over into performance?
abecx is offline   Reply With Quote
Old 03-18-2017, 12:20 PM   #2
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

As for OCing your desktop cpu's, first thing do you have adequate cooling, if you're using the stock heat sink and fan, it's not gonna be enough for the extra heat. If you do, the method is the same, just depends on the mobo. Easiest way is set the multiplier to manual and enter a number in the slot. If you're gonna do a modest OC, leave the voltage at its default level, set multi, F10 save and exit, try booting. If it boots, stress it and monitor temps. If it's stable during the stress test and temps are within safe range, you're good.

As for fastest clocked cpu, the amd 8 cores from the previous gen are really high clocked, but they're deprecated. Iirc, the i7-7700k is the king of clocks and IPC for single threaded loads.

If you want help over the phone, I can pm you my number.
Tx Redneck is offline   Reply With Quote
Old 03-18-2017, 12:26 PM   #3
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default

I have a mother board that is overclock ready with dual bios images and a corsair water cooler. I am unsure what temperatures are at with it. I will start with mine first since the 4770k and 4790k I have are both air cooled.

Does anyone have one of those AMD's I could test out? I'd bring an SSD over and boot off that and run some sql queries basically.
abecx is offline   Reply With Quote
Old 03-18-2017, 12:28 PM   #4
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

If you're talking about the AM3 socket cpu, they're bandwidth limited for io, so I can assure you it's not worth your time to test.

What OS are you using?
Tx Redneck is offline   Reply With Quote
Old 03-18-2017, 01:59 PM   #5
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default

Linux
abecx is offline   Reply With Quote
Old 03-18-2017, 02:13 PM   #6
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

http://gkrellm.srcbox.net is what used on my old Linux box.
Tx Redneck is offline   Reply With Quote
Old 03-18-2017, 06:31 PM   #7
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default

lol fucking gkrellm so old school.

abecx is offline   Reply With Quote
Old 03-18-2017, 06:45 PM   #8
zora04
Lifer
 
Join Date: Mar 2005
Location: South of Heaven
Posts: 1,030
Default

//zero*cool/
__________________
The hand that feeds, bleeds.
zora04 is offline   Reply With Quote
Old 03-18-2017, 09:10 PM   #9
black2002ls
Lifer
VIP Member
 
black2002ls's Avatar
 
Join Date: Dec 2004
Posts: 7,659
Default

Quote:
Originally Posted by zora04 View Post
//zero*cool/
Mess with the best, die like the rest

Sent from my SAMSUNG-SM-G930A using Tapatalk
__________________
Quote:
Originally Posted by Leah View Post
Best balls I've had in my mouth in a while.
black2002ls is offline   Reply With Quote
Old 03-19-2017, 12:16 AM   #10
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default

Is there some sort of database for CPU's and their stable overclock speeds?
abecx is offline   Reply With Quote
Old 03-19-2017, 12:23 AM   #11
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

No sir, it's all bin lottery. Some silicon oc's better than others all within a product line. http://www.tomshardware.com/answers/...n-lottery.html

Just as this is true for cpu's, different mobos OC better. Your psu also plays into the equation.
Tx Redneck is offline   Reply With Quote
Old 03-19-2017, 12:46 AM   #12
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

What OC were you able to get? I run my 3770k @4.3ghz 24/7
Tx Redneck is offline   Reply With Quote
Old 03-19-2017, 03:06 PM   #13
FunFordCobra
Lifer
 
FunFordCobra's Avatar
 
Join Date: Jul 2001
Posts: 7,139
Default

I was gonna say the 7700k are averaging 5.0Ghz

4770k and 4790k are not that great. 5.0 is very rare. If you can pull a 4.5 out of them you did pretty good.

My 8 core 5820k is a golden chip at 4.8 @ 1.22v, I was pushing 1.32v @ 5.0g for about a year and burned up that output of a 1200w psu lol. Most don't go much higher than turbo speed, maybe 4.2.

Just watch your voltage. Once you start hitting 1.25 or1.3 for any of these chips it gets pretty counter productive. I've also seen them all do 5.0 on around 1.2 just depends on the chip hunting you want to do.

You don't have to hunt if you're just wanting to buy a gold chip, use silicon lottery. The 5820k I have was from them and it was only 100 extra.

Don't use prime 95 to burn stability.
Intel cpu burn or something.

You can delid and achieve all these unless you are very unlucky and just get a crap chip and then its delid so you cant return it. Silicon lottery will delid too if its possible. 5820k and such cannot.
__________________

FunFordCobra is offline  
Reply With Quote
Old 03-20-2017, 04:53 PM   #14
Ratt
Any eye L
 
Ratt's Avatar
 
Join Date: Sep 2004
Location: Frisco
Posts: 19,966
Send a message via AIM to Ratt
Default

Didn't someone post a link at one point where you can buy (maybe de-lidded) CPUs that they guaranteed would overclock to a certain GHz? I swear I saw that floating around somewhere.
Ratt is offline   Reply With Quote
Old 03-20-2017, 05:10 PM   #15
Silverback
Bourbon and 'Lacs
 
Silverback's Avatar
 
Join Date: Mar 2000
Location: #brokesohard
Posts: 18,424
Default

write better queries and shit
Silverback is offline   Reply With Quote
Old 03-20-2017, 05:26 PM   #16
Tx Redneck
Wannabe puter fixor
VIP Member
 
Tx Redneck's Avatar
 
Join Date: Nov 2005
Location: On the straight and narrow,stumbling at best, only by Gods grace.
Posts: 13,926
Send a message via Skype™ to Tx Redneck
Default

Quote:
Originally Posted by Ratt View Post
Didn't someone post a link at one point where you can buy (maybe de-lidded) CPUs that they guaranteed would overclock to a certain GHz? I swear I saw that floating around somewhere.
https://siliconlottery.com
Tx Redneck is offline   Reply With Quote
Old 03-20-2017, 05:36 PM   #17
Craizie
Cracka
VIP Member
 
Craizie's Avatar
 
Join Date: Jun 2004
Posts: 11,554
Default

Quote:
Originally Posted by Tx Redneck View Post
Yup. Our IT guy went this way on his gaming PC. They even provided a spec sheet to show what components were used to hit that GHZ. I think for $50-75 extra they will pod the lid, clean it and add a much better thermal compound.
Craizie is offline   Reply With Quote
Old 03-20-2017, 05:50 PM   #18
FunFordCobra
Lifer
 
FunFordCobra's Avatar
 
Join Date: Jul 2001
Posts: 7,139
Default

see post #13. I went silicon lottery with my 5820k.

p.s. anyone gona play mass effect Andromeda?
__________________

FunFordCobra is offline  
Reply With Quote
Old 03-20-2017, 05:51 PM   #19
Chas_svo
86 SVO 344rwhp 'n gaining
VIP Member
 
Chas_svo's Avatar
 
Join Date: Jan 2011
Location: Driving the car that just passed you...
Posts: 4,130
Default

Quote:
Originally Posted by Silverback View Post
write better queries and shit
This...in most respects.


Sorry, I can't help with hardware.
__________________
13 DIB Premium GT, M6, Track Pack, Glass Roof, Nav, Recaros - Daily
86 SVO
'03 F150 supercrew
01 TJ - new toy (gone)
65 F100 (460 + C6) - Sold, 3/21/13
Chas_svo is offline   Reply With Quote
Old 03-20-2017, 09:42 PM   #20
abecx
Sup.
 
abecx's Avatar
 
Join Date: Oct 2011
Location: Dallas, Tx
Posts: 1,918
Send a message via AIM to abecx
Default

Quote:
Originally Posted by Silverback View Post
write better queries and shit
You can only preaggregate the data before hand in order to lower the amount of rows the sql engine has to chug through. Unfortunately that is solution for a reporting platform, not an analytical one.
abecx is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 05:00 AM.



Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.