Author Topic: MySQL memory usage  (Read 6165 times)

Offline Drakon

  • Jr. Member
  • **
  • Posts: 45
Re: MySQL memory usage
« Reply #15 on: October 17, 2013, 09:15:50 AM »
My performance problem is on searches. I have verified there is not a problem with mysql. I don't know, possibly it's a problem with Roundcube or IMAP. Desktop applications works fine with IMAP. My big problem is with searches, these are very slow with thousand of e-mails. I have disabled plugins too.

Can someone help me?

Offline alec

  • Hero Member
  • *****
  • Posts: 1,145
Re: MySQL memory usage
« Reply #16 on: October 17, 2013, 09:41:26 AM »
It is IMAP server performance issue. Ask on different forum/list. The only hint I can give you is to use Dovecot.

Offline Drakon

  • Jr. Member
  • **
  • Posts: 45
Re: MySQL memory usage
« Reply #17 on: October 17, 2013, 09:50:08 AM »
Thank you alec!

Offline Drakon

  • Jr. Member
  • **
  • Posts: 45
Re: MySQL memory usage
« Reply #18 on: October 18, 2013, 08:12:52 AM »
Ok, I have seen that many people have improved the performance migrating from 'courier' to 'dovecot' because 'dovecot' has indexing for search. I'm studying migration. Do you know if 'dovecot' uses the same structure maildir as 'courier' with folders 'cur', 'new', etc? I need to migrate mailboxes (/var/vmail/*) with a 'dovecot' script in Perl but I have plugins that uses courier maildir references.

Thanks anyway!

Offline Drakon

  • Jr. Member
  • **
  • Posts: 45
Re: MySQL memory usage
« Reply #19 on: November 13, 2013, 06:22:12 AM »
SKaero, alec, I solved all my problems migrating from Courier to Dovecot. Now is faster, very very very faster!!

Thanks for your support!