[ic] How to determine cause of load spikes.

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

Jure Kodzoman

More information about the interchange-users mailing list