On Aug 21, 2009, at 3:56 PM, Michal Drozdziewicz wrote: > I check original location of the file which is roundcube/sqlite.db > it was > 11G in size! Is this normal?
Seems big to me. One thing to know about sqlite, it does not shrink the size of the on- disk file when data is deleted from the database. If you want sqlite to recreate the on-disk file with just the existing data, you need to "vacuum" the database. A command to do that would look something like : /usr/bin/sqlite3 <sqlitefilename> 'vacuum <tablename>;' where the values in angled brackets are something from your own system. I use PostgreSQL for RC myself, however I do use a cron script something like the above for maintaining the sqlite databases used by our spam filtering solution. > What is exactly stored in the file? User preferences, address book information, and if you have configured it, a cache of the messages from the IMAP server. Based on the size of that file, and that you are using sqlite, I would recommend you disable the database caching. > So > I am wondering - did someone "visited" my server and did something > nasty? Probably not, that file likely contained a lot of old cached data. -- Charles Dostale System Admin - Silver Oaks Communications http://www.silveroaks.com/ 824 17th Street, Moline IL 61265 _______________________________________________ List info: http://lists.roundcube.net/users/
