Slow after "SELECT * FROM"

[menschmaschine]

Hello,

I'm using the lates Roundcube-version on my Virtual Server. The machine has about 4 GB Ram an 2 x 1,5 GHz CPU. Problem is, that Roundcube is slow. In detail Roundcube is slow in showing me my mails. After selecting an entry it takes a few moments until it shown. I tried a couple of things (imap_cache, optimizing mysql based on mysqltuner.pl and tuning-primer.sh) without luck. I enabled sql_debug and here is what I get:

[03-Apr-2012 07:15:26 +0200]: query(1): SELECT vars, ip, changed FROM session WHERE sess_id = 'abcdefghijklmnopqrstuvwxyz';
[03-Apr-2012 07:15:26 +0200]: query(1): SELECT * FROM users WHERE user_id = '1';
[03-Apr-2012 07:15:28 +0200]: query(1): SELECT vars, ip, changed FROM session WHERE sess_id = 'abcdefghijklmnopqrstuvwxyz';
[03-Apr-2012 07:15:28 +0200]: query(1): UPDATE session SET vars='abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz

As you can see theres a gap between "SELECT * FROM" and "SELECT vars...". Any ideas what the problem might be?

regards
mm

[alec]

This is more likely a slow IMAP server issue. Enable imap_debug and check the log.

[menschmaschine]

Hi alec,

thanks for the tip.

This is more likely a slow IMAP server issue. Enable imap_debug and check the log.

[03-Apr-2012 09:34:47 +0200]: [09E5] C: A0002 AUTHENTICATE PLAIN abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefgh

[03-Apr-2012 09:34:50 +0200]: [09E5] S: A0002 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS] Logged in

This is what I get. It seems to me that this is a dovecot-problem. I will check it.

Tanks!
mm