[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] How to determine cause of load spikes.


> 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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.