[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