Server Optimization

[G56Ace]

Hello, I need help optimizing mysql, however i notice that my my.cnf file is blank. Nothing.
With is probably the reason why my site is slow.
Unfortunately, i have never configured/optimized mysql and this is the part where i need some help.

This the the spec of the server im using.
Intel(R) Pentium(R) Dual CPU E2200 @ 2.20GHz
Ram: 2GB

Now, what do i need to do to configure mysql, from scratch?
Help is much appreciated!!!

G56Ace Reviewed by G56Ace on 14th Jun 2009. Server Optimization Hello, I need help optimizing mysql, however i notice that my my.cnf file is blank. Nothing. With is probably the reason why my site is slow. Unfortunately, i have never configured/optimized mysql and this is the part where i need some help. This the the spec of the server im using. Intel(R) Pentium(R) Dual CPU E2200 @ 2.20GHz Ram: 2GB Now, what do i need to do to configure mysql, from scratch? Help is much appreciated!!! :) Rating: 5

[Plutost]

Google is your best friend.
Try searching at google and you will find the solution..

[Viz0n]

The following should be helpful: http://blog.highspeedweb.net/2008/07...log-for-mysql/ http://www.linuxweblog.com/tune-my.cnf

Also, once the database has ran for 48hrs+ google for MySQLTuner script (theres 2 well known ones). they will give you an idea on what should be done.

MySQL Tuning can take anywhere from a week to over a month to tune it correctly. If not done right, it is possible to cause a server crash from I/O over use(over tuning).

[G56Ace]

Google is your best friend.
Try searching at google and you will find the solution..

Yeah, like i havent been doing that for the pasts three days...

The following should be helpful: http://blog.highspeedweb.net/2008/07...log-for-mysql/ http://www.linuxweblog.com/tune-my.cnf

Also, once the database has ran for 48hrs+ google for MySQLTuner script (theres 2 well known ones). they will give you an idea on what should be done.

MySQL Tuning can take anywhere from a week to over a month to tune it correctly. If not done right, it is possible to cause a server crash from I/O over use(over tuning).

Thanks!

[Viz0n]

I forgot to mention, if you run a heavy DB type of site, you may wish to look into using memcache over the my.cnf as a better way to cache queries ect...

Facebook uses it for all their DB servers, and thanks to their major use of the system, the project has had a lot of development.

[G56Ace]

Thanks Viz0n.
It helped alot.
I also need help Tuning Apache, any tips?

[Nick]

Sweet, thanks for the details, I have found them very helpfull!

[Viz0n]

Thanks Viz0n.
It helped alot.
I also need help Tuning Apache, any tips?

I've never used Apache, I'm a LiteSpeed guy, but look into using mod_proxy or a proxy system like Squid which can cache pages, thus reducing page load time and server load.

[wildfire95]

Hmm.. i would search on google, dont search on Yahoo Anwsers or something like that, just go google.