Current time: 09-30-2024, 12:54 AM Hello There, Guest! (LoginRegister)


Post Reply 
Server load problem....is mysql?
Author Message
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #9
RE: Server load problem....is mysql?
ok, so log-bin was already off (I had a message to also comment the other lines - but maybe it's not neccesarry).
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
07-10-2009 07:32 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
Server load problem....is mysql? - adivor - 07-10-2009, 07:11 AM
RE: Server load problem....is mysql? - joximu - 07-10-2009 07:32 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)