Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

slow queries

Quote Reply
slow queries
MySQl 4.1.21 standard
CentOS 4.x
GMail 2.2.4
P4 3.4GHz 3GB RAM
server loads : 0.4 typical

Slow Queries:
# Query_time: 15 Lock_time: 0 Rows_sent: 76491 Rows_examined: 76491

SELECT /*!40001 SQL_NO_CACHE */ * FROM `gmail_msgsearch`;

Search in GMail takes too much time.

Any suggestions for improving this.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] slow queries In reply to
Gossamer Mail's search isn't very fast since it just does a LIKE query on the message body that's in the msgsearch table. The only way to speed things up would be to use indexing, but the search code currently isn't written to use it, so that would have to be updated as well.

Adrian
Quote Reply
Re: [brewt] slow queries In reply to
OK. So does this mean that with lot of search activity there the following values would be alarming /high?

Select_full_join
Handler_read_rnd
Handler_read_rnd_next

Any other component of gossamer mail that can cause high values of above?

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Last edited by:

HyperTherm: Jan 10, 2007, 5:06 PM
Quote Reply
Re: [brewt] slow queries In reply to
In Reply To:
Gossamer Mail's search isn't very fast since it just does a LIKE query on the message body that's in the msgsearch table. The only way to speed things up would be to use indexing, but the search code currently isn't written to use it, so that would have to be updated as well.
Hi,
I'm interested in the above discussion. Please give some light on it:

How easy/difficult will it be to accomplish a fast search as you mentioned above? What are the best options in accomplishing such a fast search?

thank you,pyc