Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Are the given PC specifications (below) appropriate for a MySQL database that is to be used for analytical type queries on the given database specifications (also below)?

(I understand that both the table planning/structure, as well as the choices made when writing queries will impact query time significantly, this would not be included in the scope of this question)

Is having a lot of RAM important for example? How about processor(s)? Are there other physical hardware considerations that I normally wouldn't look for in a PC?

Here are the machine specs I have been able to gather so far:

OS: Ubuntu Server 12.04.2 LTS
Processor(s) Specs: Intel Core i7 3770 Quad Core Hyperthreading Processor LGA1155 3.4GHZ Ivy Bridge 8MB
RAM: Kingston HyperX Blu Black Series 16GB 2X8GB DDR3-1600 CL10 DIMM Dual Channel Memory Kit
HDD Size: Western Digital Red 3TB SATA3 64MB Cache 3.5in Internal Hard Disk Drive HDD
HDD Speed: 6 Gb/s | 7,200RPM

Please ask for any additional qualifiers if needed and I'll get them if I can

Also aware that there are more setup/configuration considerations to be made, while this isn't the core of this particular question any references to this would be appreciated

I'm asking this in light of being introduced to the term "Massively Parallel Processor"


To answer comment questions regarding the DB:

It's a local copy to do analytical queries on that won't impact the production server's performance, but it will not necessarily mirror the production DB, but will be re-imagined to account for weaknesses / data issues in the existing DB

It'll have mostly numeric and date fields, some varchar information but very minimal, and some tables will probably have no varchar at all

For size it's estimated to be about 6,000,000+ rows total, spread across 10+ tables; the largest tables may get up to about 2,000,000 rows max


Finally, there will be 2-4 users max – almost never more than one concurrently though

share|improve this question
2  
Why a desktop PC? That doesn't make a whole lot of sense. –  Michael Hampton Oct 18 '13 at 22:07
    
How large is the dataabse? What is this being used for? –  sciurus Oct 18 '13 at 22:37
    
Ok question updated accordingly. What kind of alternative machine would you suggest for a local in house server @MichaelHampton? There will only be perhaps 2-4 users (rarely if ever concurrently) using this DB btw –  Drewdavid Oct 18 '13 at 23:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.