[ic] How to determine cause of load spikes.

Kevin Walsh kevin at cursor.biz
Sat Nov 4 13:52:52 EST 2006


Jure Kodzoman <jure at plsavez.hr> wrote:
> > 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.
> 
He did say that it was a MySQL database.  If he was using PostgreSQL then
it probably wouldn't be a little sluggish;  It'd probably grind to a
shuddering halt for a week at a time. :-)

It certainly sounds fixable - whichever database is in use.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/


More information about the interchange-users mailing list