Upcoming Roundcube Performance Enhancement

[PitadaVespa]

What is the full cPanel version number? The following command may be used to obtain the version information:

# 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:

# 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]

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]

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]

Glad to hear something being done about this; thanks for the heads up

[yapluka]

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...

[cPanelDon]

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...

Please use caution and ensure to save fresh backups of any databases to be accessed; using the following is at one's own risk.

SQLite2 binaries may be compiled from source or downloaded via the official SQLite web site:
http://www.sqlite.org/sqlite-2.8.17.tar.gz - A tarball of the complete source tree for SQLite version 2.8.17 including all of the documentation.
http://www.sqlite.org/sqlite-2.8.17.bin.gz - A command-line program for accessing and modifying SQLite version 2.* databases on Linux-x86.
http://www.sqlite.org/sqlite_analyzer-2.8.16.bin.gz - An analysis program for version 2.* database files on Linux-x86

References used for the above information:
SQLite Download Page
Internet Archive Wayback Machine | SQLite Download Page
Internet Archive Wayback Machine | SQLite Download Page (2006/09/04 - September 04, 2006)
Internet Archive Wayback Machine | SQLite Download Page (2007/12/14 - December 14, 2007)
Internet Archive Wayback Machine | SQLite Download Page (2008/01/10 - January 10, 2008)

Another resource that may be of interest is the official SQLite wiki that includes links to third-party projects and software that interact with SQLite databases: SQLite CVSTrac Wiki

[huafeihua116]

Thanks for sharing this!