Solved

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

Posted on 2008-06-11
3
771 Views
Last Modified: 2013-12-13
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
0
Comment
Question by:sprabhu2008
3 Comments
 
LVL 3

Accepted Solution

by:
Xorlev earned 500 total points
ID: 21767240
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question