[ic] How to determine cause of load spikes.
jure at plsavez.hr
Sat Nov 4 13:24:51 EST 2006
> If you suspect a slow query then try turning on the mysql slow query
> log. Let it run for a few days then optimize your most frequent and
> slowest queries.
Since he didn't mention what DB is he using, in case he uses PostgreSQL
he might give http://pgfouine.projects.postgresql.org/ a try. It helped
me a lot in process of finding slow and unefficient queries.
Just an idea.
More information about the interchange-users