Jumping off point for my.cnf 48GB 8-core system

Posted on 2010-01-10
Medium Priority
Last Modified: 2012-05-08
We have a Joomla / Social Networking site that we're moving to a new server serving approx 250,000 pages per day (wish I had more detailed stats handy but unfortunately I don't at this moment).  CentOS 64-bit, dual Xeon 5520 quad-cores, 48GB RAM, PHP 5.2.12, MySQL 5.0.87.

I'm looking for a good jumping off point for a complete my.cnf for such a system.  Realize that's a little light on details - but can provide more upon request.

Question by:rovermedia
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

Accepted Solution

pauly5 earned 2000 total points
ID: 26280824
Hi There,
MySQLTuner is a really great tool for finding ways to optimise your MySQL Server. It shows you ways you can optimise the server, and hints for settings to put in your my.cnf file. I hope this helps...

Checkout http://blog.mysqltuner.com/

Author Closing Comment

ID: 31675141
Excellent tool!

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

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…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month12 days, 18 hours left to enroll

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