Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have installed MySQL 5.3 and I don't know why it's eating all of my resources. These are some screenshots of my memory usage.

enter image description here

enter image description here

What can I do to diagnose this problem? My Server is having: Ram:2GB, RedHat5/Apache2/PHP5/Mysql5.1

share|improve this question

migrated from stackoverflow.com Sep 24 '11 at 22:11

This question came from our site for professional and enthusiast programmers.

closed as not a real question by mailq, Ben Pilbrow, Ward, John Gardeniers, jscott Sep 24 '11 at 23:23

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
This is waay to broad; we can't answer your question without knowing anything about your software or hardware setup. –  Bojangles Sep 24 '11 at 22:10
2  
Wait, you're complaining that the queries are being served from cache?? Please tell me I'm misunderstanding you.... –  Ben Pilbrow Sep 24 '11 at 22:20

1 Answer 1

Download and run the MySQL Tuning Primer script (I think you need to edit some things in the top of the script first).

This is a very useful little script that will analyze your my.cnf configuration file and suggest changes etc.

share|improve this answer