Hi! I had the chance to work with Roundcube only recently. I "inherited" this webmail setup from the previous admin and I have a very unsettling feeling that it wasn't set up properly, but it works. Due to the fact I want to upgrade it (it's out dated version 0.1) I took a closer look to it and discovered (because I want to make a new install and only import the data from the database tables into the new tables and drop the old installation entirely) that it uses InnoDB. My question is (pretty stupid question I know) will I break the program if I try to force it to use MyISAM engine instead of InnoDB, the reason being that InnoDB uses a lot of memory even when is in idle and the machine on which the webmail is hosted has very limited resources. Thank you!
On Sep 3, 2008, at 6:12 AM, Dadu Kakkado wrote:
it uses InnoDB. My question is (pretty stupid question I know) will
I break the program if I try to force it to use MyISAM engine
instead of InnoDB,
I think InnoDB is the default with MySQL now.
Although MyISAM was the previous default, I ( and others I know )
have had data corruption issues with MyISAM tables with applications
that heavily load MySQL. Also, it is possible that there would be
some contention or blocking issues since MyISAM is table-locked not
row-locked like InnoDB. That said, it should not make a difference
for RoundCube.
the reason being that InnoDB uses a lot of memory even when is in
idle and the machine on which the webmail is hosted has very
limited resources
You could make some changes to your my.cnf to limit the memory
issues, although memory is the thing that makes a database system go
more than anything else.
I personally use PostgreSQL with RC, and it is on a separate host
from any of the RC instances I have deployed.
Charles Dostale System Admin - Silver Oaks Communications http://www.silveroaks.com/ 824 17th Street, Moline IL 61265
List info: http://lists.roundcube.net/users/