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
790 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Echo Multiple values from multiple records 19 55
Checking https returns 301 21 54
Google Dork query 7 56
How do use '  ' within this code? 4 24
This article discusses four methods for overlaying images in a container on a web page
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

679 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