Steps to optimize mysql server

[divinequran]

My mysql webserver utilize more process and memory in my server? How do I optimize mysql server?

[zulugrid]

If you are using Linux, you can use the MySQL tuning primer: http://www.day32.com/MySQL/

It is a shell script that analyzes your database settings and current performance, and makes suggestions that can help your database perform better.