[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
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
Medium Priority
?
842 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
1 Comment
 
LVL 3

Accepted Solution

by:
Xorlev earned 2000 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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Suggested Courses
Course of the Month18 days, 22 hours left to enroll

834 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