[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register 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
?
835 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
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 …
Suggested Courses

649 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