Thanks for the reply Paul

The imapdproxy seemed to help with an imap fetch problem (iirc) we were
having when we first went to 2.2.5. Although that may be a coincidence - i
haven't figured that one out yet

I have tested without it in equation also so i don't believe this to be the
cause.

At the squirrelmail login prompt it wont load up the ui, it hangs until it
eventually times out with imapd dropped connection (or something to that
effect).  I've actually set the timeout to a much higher value now to see if
i'd get anything after a longer amount of time, but still no joy.

(just double checked before sending the email and this is the error im
getting )
ERROR : Connection dropped by imap-server.
Query: SEARCH CHARSET ISO-8859-1 ALL Subject {13}

I'll try and get some further info regarding the mysql slow query logs.

It's been a rather intermittent fault since the upgrade which is why i left
it last time around, it was put on the back burner but it needs sorting.

Can you think of anything else which may need tweaking, perhaps
apache/php/squirrelmail related?  What's the recommended $imap_server_type
setting?  I've currently set this to 'other'

Thanks for all your help as always

Jon

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul J Stevens
Sent: 27 June 2007 21:04
To: DBMail mailinglist
Subject: Re: [Dbmail] slow squirrelmail queries

Jon Duggan wrote:
> Hi Guys
> 
> Still having an issue with slow imap queries via overlook (its a
> squirrelmail base with changes in gui, we've also tested squirrelmail with
> same results),
> 
> We're getting *very* slow queries on some mailboxes below ive provided a
> level 5 trace log

No slow queries in the logs. You may want to try taking imapproxy out of
the equation, just to clear up the picture.

> 
> This client has 14mb of mail which is about 280 emails or so
> 
> Can anyone shed some light on this?
> 
> The database is running on a dedicated server with very little load on it
> and im testing this from a spare failover webserver with the same results
as
> the live webserver so im confident its not an I/O error machines are also
on
> a bonded gigabit connection to eachother.
> 
> I saw a bug filed for a similar issue, is this still outstanding? Bug id
> 579, i wonder if its related?

That bug is not about slow results.

> 
> Not sure if you can see anything obvious from those tracelogs, if anyone
has
> any ideas on how to fix this please let me know!


Jon, where are the slow queries? There aren't any in the logs. Also,
last time around I asked you to look at the slow queries log in mysql,
but I havent seen any, iirc.




-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail 

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to