Hello All,
I setup a Roundcube webmail, and it is working fine. Some part not but i can live with that. The problem is that my Server admin is complaining about mysql usage and threads that Roundcube make. I disabeled CACHE but that didnt help either:
/ enable caching of messages and mailbox data in the local database. // this is recommended if the IMAP server does not run on the same machine $rcmail_config['enable_caching'] = FALSE;
// lifetime of message cache // possible units: s, m, h, d, w $rcmail_config['message_cache_lifetime'] = '10d';
Readed that on forum: http://roundcubeforum.net/forum/index.php?topic=116.msg927#msg927
Here is list of thread that are on MySQL5
Id User Host/IP DB Time Cmd Query
or State
-- ---- ------- -- ---- ---
7547906 root localhost USERNAME_test 0 Query show full processlist
7547970 USER1_em localhost USER1_ema 0 Sleep7547997 USER1_em localhost USER1_ema 1 Sleep
7546309 USER1_em localhost USER1_ema 3 Sleep
7547986 USER1_em localhost USER1_ema 10 Sleep
7547875 USER1_em localhost USER1_ema 84 Sleep
7547789 USER1_em localhost USER1_ema 139 Sleep
7546131 eximstats localhost eximstats 200
Sleep7546390 USER1_em localhost USER1_ema 259 Sleep
7547605 USER1_em localhost USER1_ema 266 Sleep
7546367 USER1_em localhost USER1_ema 318 Sleep
7546235 USER1_em localhost USER1_ema 325 Sleep
7546220 USER1_em localhost USER1_ema 502 Sleep
7546209 USER1_em localhost USER1_ema 562 Sleep
7546684 USER1_em localhost USER1_ema 802 Sleep
7546414 USER1_em localhost USER1_ema 982 Sleep
7546406 USER1_em localhost USER1_ema 991 Sleep
7546358 USER1_em localhost USER1_ema 1019 Sleep
7546350 USER1_em localhost USER1_ema 1029 Sleep
7546141 USER1_em localhost USER1_ema 1149 Sleep
If someone have any suggestion pls let me know. Btw: runing last SVN from roundcubemail. thNX
List info: http://lists.roundcube.net/dev/
On Tuesday 04 September 2007 09:02:05 am crow wrote:
Hello All,
I setup a Roundcube webmail, and it is working fine. Some part not but i can live with that. The problem is that my Server admin is complaining about mysql usage and threads that Roundcube make. I disabeled CACHE but that didnt help either:
I am not too sure, but are the connections persistent ? I know that we have reduced connections by using the mysql_pconnect instead of mysql_connect ...
Actually, persistent connections could be the problem. PHP's implementation of mysql_pconnect isn't the greatest. That is why it was taken out of the mysqli connection.
According to the SHOW PROCESSLIST, it shows a lot of sleeping connections. MySQL's default timeout is 8 hours, so those could be there for quite some time.
I disabled persistent connections from the start and I have not had any problems. Might I suggest that?
Thanks, -william
On 9/4/07, Adrian Snyman adrians@supply-chain.co.za wrote:
On Tuesday 04 September 2007 09:02:05 am crow wrote:
Hello All,
I setup a Roundcube webmail, and it is working fine. Some part not but i can live with that. The problem is that my Server admin is complaining about mysql usage and threads that Roundcube make. I disabeled CACHE but that didnt help either:
I am not too sure, but are the connections persistent ? I know that we have reduced connections by using the mysql_pconnect instead of mysql_connect ...
-- Regards, Adrian Snyman ================== Please read our Email Disclaimer : http://www.supply-chain.co.za/disclaimer.html _______________________________________________ List info: http://lists.roundcube.net/dev/
List info: http://lists.roundcube.net/dev/
Hello Adrian,
Tuesday, September 4, 2007, 9:22:53 AM, you wrote:
On Tuesday 04 September 2007 09:02:05 am crow wrote:
Hello All,
I setup a Roundcube webmail, and it is working fine. Some part not but i can live with that. The problem is that my Server admin is complaining about mysql usage and threads that Roundcube make. I disabeled CACHE but that didnt help either:
I am not too sure, but are the connections persistent ? I know that we have reduced connections by using the mysql_pconnect instead of mysql_connect ...
I dont know that i asked my sysadmin if connection persistent are. It would like to use mysql a minimum only, but it seems so not. Thnx for your replay.
List info: http://lists.roundcube.net/dev/
On 9/4/07, crow crow@linux.org.ba wrote:
Tuesday, September 4, 2007, 9:22:53 AM, you wrote:
On Tuesday 04 September 2007 09:02:05 am crow wrote:
Hello All,
I setup a Roundcube webmail, and it is working fine. Some part not but i can live with that. The problem is that my Server admin is complaining about mysql usage and threads that Roundcube make. I disabeled CACHE but that didnt help either:
I am not too sure, but are the connections persistent ? I know that we have reduced connections by using the mysql_pconnect instead of mysql_connect ...
I've never seen that work. Especially with Apache and forking/preforking. I've read a ton of articles where people claim that you save some CPU cycles by using it but I have no idea if that actually works (yet/now).
I dont know that i asked my sysadmin if connection persistent are. It would like to use mysql a minimum only, but it seems so not. Thnx for your replay.
Check config/db.inc.php and check $rcmail_config['db_persistent']
If it is set to TRUE, please set it to FALSE and try again.
Also, as others have stated - the default timeout for mysql connections is 8 hrs. This is not really a problem (shouldn't be anyway), but tell your system administrator to read up on wait_timeout (or something like that) to decrease the setting. Then idle connections will no longer stay around for so long.
Cheers, Till _______________________________________________ List info: http://lists.roundcube.net/dev/
On 9/5/07, till klimpong@gmail.com wrote:
(...) Check config/db.inc.php and check $rcmail_config['db_persistent']
If it is set to TRUE, please set it to FALSE and try again.
Since the majority of users comes with Apache/PHP combos, we should probably disable this by default. I actually couldn't believe it is set to TRUE. If someone has any objections, please raise them. Otherwise I'll make the change in the coming days. ;-)
(Note: You will still be able to use persistant connections (by configuring it to TRUE), but the default will change to FALSE.)
Cheers, Till _______________________________________________ List info: http://lists.roundcube.net/dev/
I know that most users will choose MySQL. I personally prefer PostgreSQL. Is there any info about users that choose the SQLite backend ? Anyone on the devel list use it, or test with it ?
Charles Dostale System Admin - Silver Oaks Communications http://www.silveroaks.com/ 824 17th Street, Moline IL 61265
List info: http://lists.roundcube.net/dev/
Wensday, September 5, 2007, 2:29:27 AM, you wrote:
On 9/5/07, till klimpong@gmail.com wrote:
(...) Check config/db.inc.php and check $rcmail_config['db_persistent']
If it is set to TRUE, please set it to FALSE and try again.
Since the majority of users comes with Apache/PHP combos, we should probably disable this by default. I actually couldn't believe it is set to TRUE. If someone has any objections, please raise them. Otherwise I'll make the change in the coming days. ;-)
(Note: You will still be able to use persistant connections (by configuring it to TRUE), but the default will change to FALSE.)
Cheers, Till _______________________________________________ List info: http://lists.roundcube.net/dev/
Thnx all for your post, i disabeled persistant in config/db.inc.php (thnx Till for suggestion) and i asked my sysadmin if there are any problem, he replayed that now proces dont hang on,and that MYSQL5 is working just fine withot to much usage..
Thnx
Me vote to disable it from default, ALSO CACHE should be disabeled by default, as many ppl run imap on same server where the webmail is hosted, well almost.
List info: http://lists.roundcube.net/dev/
till wrote:
Check config/db.inc.php and check $rcmail_config['db_persistent']
If it is set to TRUE, please set it to FALSE and try again.
Thanks for this tip! I had this incorrectly set and after changing it, I definitely noticed a speed increase. I bet a lot of people have this incorrectly set.
On 9/11/07, kyle kyle@m36.net wrote:
till wrote:
Check config/db.inc.php and check $rcmail_config['db_persistent']
If it is set to TRUE, please set it to FALSE and try again.
Thanks for this tip! I had this incorrectly set and after changing it, I definitely noticed a speed increase. I bet a lot of people have this incorrectly set.
It was enabled by default, so I disabled it. It will be fixed in the next release. :)
Thanks for the heads up!
Till _______________________________________________ List info: http://lists.roundcube.net/dev/