how many visitors your site is getting per day on average?
is your db is mysql or postgres?
Visitors varies.
Mysql.

Hi,

Optimizating my.cnf is a really hard work bur you should optimize it from your server specs..

This whole week i was trying to optimize my.cnf not becouse i am having high CPU usage just for been ready

You can use the command "/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl" into SSH thru putty and you will get some suggestions..

This thing should made every day or every 1-3 days to see what the script will suggest you to change

this is a loong term run so you wont see the changes imediatly
Thank you sady92.
The command you wrote in case you have cpanel, isn't it?
Well, i don't have cpanel, just server run with webmin.
I have red previously about optamization of my.cf , but didn't find anything regarding how to reduce CPU load, only how to reduce the ram usage:
http://library.linode.com/troublesho...ory-networking

Mybb is optimized to use accelerator, install it
Can you give me the link of the tutorial on how to install it? Iam using Ubuntu 10.04 .
Thank you.