Re: MySQL IMAP Server

[Erik Retz]

Pretty sure dbmail can use mysql.

www.dbmail.org

-Erik





--- Ben Clewett [EMAIL PROTECTED] wrote:
 Paul DuBois wrote:
  
  I believe the Horde IMP server uses MySQL:
  
  http://www.horde.org
 
 Thanks.  Looking at this, I belive it's an IMAP
 clinet.  Unless the web 
 site is in error.
 
 I was rather trying to find an IMAP server using
 MySQL.  Ie, somewhere 
 to store my millions of email messages, from many
 execlent mailing 
 lists, and get at them fast...
 
 EG, Mozilla Mail with message folders more than
 10,000 email's, can 
 (though a bug as well as bad structure) take more
 than a second per 
 email to parse.  Eg, marking as read.  Where as an
 MySQL IMAP server 
 would be thousands of times faster...
 
 If you hear of one, can you let me know?
 
 Cheers, Ben.
 
  
 
  Regards,
 
  Ben
 
  
  
 

-
  Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
  
  To request this thread, e-mail
 [EMAIL PROTECTED]
  To unsubscribe, e-mail 
 

[EMAIL PROTECTED]
  Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
  
 
 
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

slow-queries.log vs. explain

[Erik Retz]

I've been monitoring slow-queries.log to try and find
querys that might be causing problems.  I see the
following logged:

# Time: 020903 16:59:14
# User@Host: cfweb[cfweb] @ storm.centurytel.net
[10.10.1.17]
# Query_time: 47  Lock_time: 0  Rows_sent: 5 
Rows_examined: 145240
SELECT
   
clari_category.image_exists,
clari_article.id,
   
clari_article.image_url_standard 
FROM
clari_category
LEFT JOIN
clari_article ON
clari_category.id = clari_article.id
WHERE
   
clari_category.datestamp   '2002-09-01' 
AND
clari_category.image_exists = '0'
AND
clari_article.image_url_standard != '';


But when I do an explain on the same query I get:

+++---+-+-+---+--++
| table  | type   | possible_keys 
   | key |
key_len | ref   | rows | Extra  |
+++---+-+-+---+--++
| clari_category | ref|
idx_imagekey,idx_imagestoryvalidation,idx_datestamp,idx_photo
| idx_photo   |   1 | const | 1448 |
where used |
| clari_article  | eq_ref |
idx_primary,idx_datearticle   
   | idx_primary | 100 | clari_category.id |  
 1 | where used |
+++---+-+-+---+--++
2 rows in set (0.00 sec)


I don't understand why the query is examining 145240
rows when explain says it should be limited to 1448? 
Am I missing something?  

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php