Which distro for multi-cpu multi-core x64 and MySQL ONLY?
I'm looking for the fastest and most stable distro for multi-cpu multi-core x64 platform that will host only one program - MySQL. No other services/applications will be running, with exception of [may be] running KDE env for a few minutes to configure MySQL (and then close KDE).
I need distro to be compatible with Supermicro X7QC3 and it's onboard LSI 1068e SAS controller (well, if that's impossible, I can live with X7QCE and some other plugged-in SAS controller). It needs to be 64-bit distro. It is planned to utilize all 4-cpu spots with 4-cores CPUs, plus on-board 92GB memory.
Another separate question: may be there is another SQL server for UNIX that is faster than MySQL in the following conditions: low volume one writing thread + many (~500 - 700) simple [by syntax] parallel queries that access almost all data in the DB to get a result, but results are of low volume also (~100Kb per query max). I need fastest result output possible.
Thank you in advance!