The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

RoundCube very slow

Discussion in 'Workarounds and Optimization' started by razuk, Mar 11, 2014.

  1. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    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
     
  3. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Mysql looks ok during this time. All others mysql process run fine.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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?

     
  6. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    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.
     
  7. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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,
     
  8. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    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.
     
  9. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    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.,

     
  10. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    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 :)
     
  11. razuk

    razuk Member

    Joined:
    Feb 18, 2014
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Ok, i have increased it from 5 to 15.
     
Loading...

Share This Page