[ic] How to determine cause of load spikes.

[Jure Kodzoman]

> 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.


Jure Kodzoman