Upcoming Roundcube Performance Enhancement

Status
Not open for further replies.

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
We have noticed many threads about issues regarding excessive CPU utilization by Roundcube. We have recently located the cause of this issue and are performing some final testing on a resolution to this issue. This resolution already published in our BETA build. Once this modification is found to meet our quality standards for EDGE, we will be pushing this to our EDGE build (11.25).

We understand the majority of you are using version 11.24. Please understand we intend to backport this enhancement to 11.24 in the near future. We do not have any exact ETAs on the propagation of this enhancement. However, this thread will be updated when more information becomes available.

To ensure all Roundcube users benefit from this enhancement, we are sharing our findings with the developers of Roundcube once we have completed the testing and rollout.

If you have any questions, desire any clarification, or have any feedback please post to this thread. Your feedback helps us to better meet your needs.
 

hostmedic

Well-Known Member
Apr 30, 2003
543
0
166
Washington Court House, Ohio, United States
cPanel Access Level
DataCenter Provider
awesome - and thanks

David - thanks - that is absolutely awesome.
I also love that your team is going to go the extra mile and share the enhancement with the Round Cube folks

Another reason to stick w/ cPanel. :)
 

stormy

Well-Known Member
Nov 22, 2003
180
33
178
Spain
cPanel Access Level
Root Administrator
What's the status on this? I just had roundcube bring a server to its knees (load 174) with a truckload of roundcube processes.

I issued pkill -u cpanelroundcube and then restarted cPanel services just to be sure.
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,544
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
What's the status on this? I just had roundcube bring a server to its knees (load 174) with a truckload of roundcube processes.

I issued pkill -u cpanelroundcube and then restarted cPanel services just to be sure.
The RoundCube enhancements are included in the latest builds of cPanel version 11.25. Currently this is available in the EDGE and CURRENT build trees; in due time it be available in the RELEASE and STABLE build trees. There is no ETA available for when new versions reach a certain build tree, including RELEASE and STABLE.

For additional information about when the new version will be available please refer to the following thread:
cPanel Forums - View Single Post - cPanel 11.25

If considering to switch your server's configured build tree to obtain cPanel version 11.25, please first review the following 11.25 information page and applicable release notes (PDF) :
cPanel 11.25
ReleaseNotes < AllDocumentation < TWiki
 

budway

Well-Known Member
Apr 16, 2003
189
0
166
Top Gov's discussing global warming trying to find away out and this issue is ongoing?

Imagine the co2 generated by the extra cpu load generated by this bug.


I found a thread it people reporting this problem since way-back and this is still unsolved....
 
Last edited:

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,544
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Top Gov's discussing global warming trying to find away out and this issue is ongoing?

Imagine the co2 generated by the extra cpu load generated by this bug.

I found a thread it people reporting this problem since way-back and this is still unsolved....
The aforementioned issue in Roundcube is fully resolved. I would consider upgrading to the latest CURRENT build or wait for the upcoming RELEASE build of cPanel version 11.25.

Please refer to the earlier reply in this thread linking to the cPanel 11.25 release page and release notes.
 

Secmas

Well-Known Member
Feb 18, 2005
378
20
168
The aforementioned issue in Roundcube is fully resolved. I would consider upgrading to the latest CURRENT build or wait for the upcoming RELEASE build of cPanel version 11.25.

Please refer to the earlier reply in this thread linking to the cPanel 11.25 release page and release notes.
When is the RELEASE ETA?
 

PitadaVespa

Active Member
Aug 28, 2006
28
0
151
I upgraded to 11.25 but cpanelro still has a high CPU load.
This only happens on one of my servers.

Thanks,
PV
 

Secmas

Well-Known Member
Feb 18, 2005
378
20
168
This is a bad joke, after waiting that 11.25 release came out, this didn't fix the roundcube error, server did the update very early this morning (about 3:00 am CST) and a few minutes ago:

/var/cpanel/3rdparty/bin/php -c /usr/local/cpanel/3rdparty/etc/roundcube /usr/local/cpanel/base/3rdparty/roundcube/index.php
:(
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,544
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
I upgraded to 11.25 but cpanelro still has a high CPU load.
This only happens on one of my servers.

Thanks,
PV
What is the full cPanel version number? The following command may be used to obtain the version information:
Code:
# cat /usr/local/cpanel/version && echo
Has the system Roundcube configuration been converted from MySQL to SQLite? Via root SSH access the following command may be used to determine the status of Roundcube using SQLite or MySQL:
Code:
# grep roundcube_db /var/cpanel/cpanel.config
If the system Roundcube configuration is still using MySQL I would consider converting it to SQLite as detailed in the cPanel 11.25 Release Notes (available for download in PDF format): cPanel Release Notes - Version 11.25
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,544
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
This is a bad joke, after waiting that 11.25 release came out, this didn't fix the roundcube error, server did the update very early this morning (about 3:00 am CST) and a few minutes ago:

:(
What is the exact error you are referring to? Please also see my last reply regarding Roundcube performance and optional conversion to SQLite as mentioned in the cPanel 11.25 Release Notes.
 

Craigles

Member
Aug 5, 2004
12
0
151
If the system Roundcube configuration is still using MySQL I would consider converting it to SQLite as detailed in the cPanel 11.25 Release Notes (available for download in PDF format): cPanel Release Notes - Version 11.25
Just out of curiosity, what sort of performance gains would you expect to see converting to SQLite ?

Roundcube is always hogging resources on a number of our servers, would this help it to calm down?

Cheers.
 

PitadaVespa

Active Member
Aug 28, 2006
28
0
151
What is the full cPanel version number? The following command may be used to obtain the version information:
Code:
# cat /usr/local/cpanel/version && echo
11.25.0-RELEASE_42213

Has the system Roundcube configuration been converted from MySQL to SQLite? Via root SSH access the following command may be used to determine the status of Roundcube using SQLite or MySQL:
Code:
# grep roundcube_db /var/cpanel/cpanel.config
No, it was not.

If the system Roundcube configuration is still using MySQL I would consider converting it to SQLite as detailed in the cPanel 11.25 Release Notes (available for download in PDF format): cPanel Release Notes - Version 11.25

Would it be mouch more performante?
---
Actually, last night I killed cpanelro process and, after more then 12 hours, it hasn't showed up again.
So, everything seems fine now.

Thanks,
PV
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,544
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
Just out of curiosity, what sort of performance gains would you expect to see converting to SQLite ?

Roundcube is always hogging resources on a number of our servers, would this help it to calm down?

Cheers.
If Roundcube usage was previously triggering CPU resource issues I believe proceeding with the optional conversion to SQLite would allow for enhanced performance; how noticeable the improvement may be could vary depending on system activity, including overall webmail usage and IMAP server load. In addition to performance, general usage of Roundcube should benefit as we have updated to the latest major Roundcube version series ("0.3.x"), availing of any new features and bug-fixes that are available upstream from the (third-party) Roundcube developers.

The IMAP/POP mail server selection may also have some effect on performance; if using Courier I may suggest considering Dovecot for enhanced IMAP (webmail) performance. Additional comparison details (between Courier and Dovecot) are included in WHM at the following menu path:
WHM: Main >> Service Configuration >> Mailserver Selection
Documentation: Mailserver Selection
 

Craigles

Member
Aug 5, 2004
12
0
151
Thanks for the information :)

I might look at converting a number of our more troublesome servers to Roundcube with SQLite to see how it performs.

We are already using Dovecot, I like it better then Courier and it seems to have far better performance - at least on our setup it does.
 

Luke Carrier

Active Member
May 27, 2009
29
0
51
Glad to hear something being done about this; thanks for the heads up :)
 

yapluka

Well-Known Member
Dec 24, 2003
301
2
168
France
cPanel Access Level
Root Administrator
As there is no sqlite2 management utilities, is there any way for the sysadmin to VACUUM the users roundcube databases through command line ?
I am foreseeing disk space issues as the end users rarely use the "Log out" link and usually just close the window...
 
Status
Not open for further replies.