razuk

Member
Feb 18, 2014
15
0
1
cPanel Access Level
Root Administrator
My RoundCube webmail is extremely low and sometimes users can not even use it.

Code:
[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
 

razuk

Member
Feb 18, 2014
15
0
1
cPanel Access Level
Root Administrator
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

Well-Known Member
PartnerNOC
Sep 26, 2006
833
28
178
Virginia Beach, VA
cPanel Access Level
DataCenter Provider
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

Member
Feb 18, 2014
15
0
1
cPanel Access Level
Root Administrator
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

Well-Known Member
PartnerNOC
Sep 26, 2006
833
28
178
Virginia Beach, VA
cPanel Access Level
DataCenter Provider
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

Member
Feb 18, 2014
15
0
1
cPanel Access Level
Root Administrator
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.