Server load problem....is mysql?

[adivor]

(07-10-2009 07:32 PM)joximu Wrote:  Hm - so, the other approach is: log the "slow" queries.

log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2

and maybe:
log-queries-not-using-indexes

This can help find the scripts that should be optimized...

You also can have a look in phpMyAdmin, Status... there are also some interesting numbers...

/J

I set this, how many time is necessary?

update:
i see this log but i see my mysql password and i can't publish it. what line are you interested?

update2:
i'm very confused....i use only vbulletin and wordpress, not "crazy" script.... vb and wp are fully optimized with cache system.....confused...