need my.cnf configuration advice for mysql 5.0 fedora 5, running on Xeon Quadcore 2.0GHz with 2GB RAM

need my.cnf configuration advice for  mysql 5.0 fedora 5,  running on  Xeon Quadcore 2.0GHz with 2GB RAM

basically all the parameters i need to set for an ideal performance

We are a mostly read-only system

Our largest table has 11 Million records
sprabhu2008Asked:
Who is Participating?
 
XorlevConnect With a Mentor Commented:
My advice is to give yourself a large query cache, and a large key cache. Perhaps around 160mb of query cache space. It depends on how many unique queries you get...it could be that enabling the QC will have precious little effect. What kind of site is it? Ideal performance needs some functions. Is it a datamine with a search input? Or are the queries usually the same? Are there a lot of joins?
0
All Courses

From novice to tech pro — start learning today.