[horde] Horde Implementation Going South

[Dave Cunningham]

I have confirmed that many of my slow queries do make use of indexes, but that many also do not.  I'm not really sure how to proceed to do something about this.  Many of them appear to be general select commands on address books.

Dave

-----Original Message-----
From: horde-bounces at lists.horde.org on behalf of Dave Cunningham
Sent: Wed 9/5/2007 1:59 PM
To: Leonardo Rodrigues Magalhães; Horde ML
Subject: Re: [horde] Horde Implementation Going South
 

ok... will try that.

Dave

-----Original Message-----
From: horde-bounces at lists.horde.org on behalf of Leonardo Rodrigues Magalhães
Sent: Wed 9/5/2007 1:20 PM
To: Horde ML
Subject: Re: [horde] Horde Implementation Going South
 


Dave Cunningham escreveu:
>
> 2.) MYSQL - We have mysql running on a separate server of the same specs.  It frequently uses 100% of BOTH cpus in what appears, by using myTop, to be a bunch of Join statements on the horde_datatree table. Switching to InnoDB seemed to make it faster at first.  But, as the number of sessions increased, all performance increases were lost and perhaps made worse.  I also tried upgrading mysql from the stock RHEL4 version 4 rpm to the V5 RPM from mysql.org.  There was no noticeable difference there.
>
>   
    Are you sure your tables have the needed indexes for your complex 
queries ? I have seen several MySQL falling with high loads and killing 
everything else that depends on it because of some miserable missing 
indexes.

    Try running your queries, in mysql client command line, using 
DESCRIBE before the SELECT .... and watch if mysql is using indexes, 
doing linear scan on the table, etc etc

describe select .... from ... where .....;



-- 


	Atenciosamente / Sincerily,
	Leonardo Rodrigues
	Solutti Tecnologia
	http://www.solutti.com.br

	Minha armadilha de SPAM, NÃO mandem email
	gertrudes at solutti.com.br
	My SPAMTRAP, do not email it





-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org