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