RoundCube very slow

[razuk]

My RoundCube webmail is extremely low and sometimes users can not even use it.

[mysqld]
local-infile=0
datadir=/home/mysql/
socket=/var/lib/mysql/mysql.sock
slow_query_log=1 
slow_query_log_file=mysql-slow.log 
long_query_time=0.2
#skip-locking
##skip-innodb
query_cache_limit=2M
query_cache_size=100M
query_cache_type=1
max_user_connections=100
max_connections=300
interactive_timeout=100
wait_timeout=15
connect_timeout=999
thread_cache_size=128
key_buffer_size=750M 
join_buffer=2M
join_buffer_size=1M
max_allowed_packet=512M
table_cache=6000
#record_buffer=1M
sort_buffer_size=256K
read_buffer_size=128K
myisam_sort_buffer_size=64M
server-id=1
federated

innodb_buffer_pool_size=2500M 

#[mysql.server]
#user=mysql
#basedir=/var/lib 

open_files_limit=50000
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid

#[mysqldump]
#quick
#max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M 

[myisamchk]
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

 

[vanessa]

Is mysql bogged down during the time that it's slow? You might want to consider switching Roundcube to use sqlite.

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

 

[razuk]

Mysql looks ok during this time. All others mysql process run fine.

Is mysql bogged down during the time that it's slow? You might want to consider switching Roundcube to use sqlite.

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

 

[cPanelMichael]

Hello

Yes, Vanessa makes a good point. Have you considered converting Roundcube to SQLite?

Thank you.

 

[razuk]

Thanks to Vanessa I am considering this conversion, but I was told that all adress books of the email accounts will be lost after this conversion. Is there any fix to this situation?

Hello

Yes, Vanessa makes a good point. Have you considered converting Roundcube to SQLite?

Thank you.

 

[vanessa]

Thanks to Vanessa I am considering this conversion, but I was told that all adress books of the email accounts will be lost after this conversion. Is there any fix to this situation?

Do you remember where you heard this from? We converted a few hundred servers when this option first became available, and I don't recall this being an issue.

 

[razuk]

Vanessa,

That information about the adress book was given by Platinum Staff, that administrate my servers.

Today some of our costumers are complaining about difficulties to use email even on Outlook caused by slowness and instability in the connection.

Have you ever worked with them? I like their sevices, but this issue is taking too long.

Thanks,

 

[vanessa]

I'm not familiar with "Platinum Staff" - are you maybe referring to Platinum Server Management? I've worked with the latter a few times.

If you're seeing the problem with Outlook as well, I really don't think the slowness is down to Roundcube at this point - it's the mail server itself. I still recommend using sqlite, but it probably won't resolve this specific problem, though performance in the RC may be generally better. The times I've seen the issue you are referring to, when the server's load is otherwise OK, it's because the number of authentication daemons or max connections for your mailserver (Courier or Dovecot) is set too low to handle the number of connections being made. In which case, you can log into WHM and bump these up to a more reasonable value.

 

[razuk]

Great tip Vanessa. I have increased the max connections. Let's hope for the best.

I'll keep you informed.

May I add you on skype so we can discuss some business?

Att.,

I'm not familiar with "Platinum Staff" - are you maybe referring to Platinum Server Management? I've worked with the latter a few times.

If you're seeing the problem with Outlook as well, I really don't think the slowness is down to Roundcube at this point - it's the mail server itself. I still recommend using sqlite, but it probably won't resolve this specific problem, though performance in the RC may be generally better. The times I've seen the issue you are referring to, when the server's load is otherwise OK, it's because the number of authentication daemons or max connections for your mailserver (Courier or Dovecot) is set too low to handle the number of connections being made. In which case, you can log into WHM and bump these up to a more reasonable value.

 

[vanessa]

You may also want to increase your authentication daemons as well. They don't take up a lot of resources, but each login to the server will wait for an available daemon and if there are non, the connection may hang until one opens up.

Skype name is vanessavasile

 

[razuk]

Ok, i have increased it from 5 to 15.