FAQSearchLoginRegister
It is currently Thu Dec 14, 2017 4:54 pm

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
 Reduce database size 
Author Message

Joined: Tue Sep 27, 2005 12:45 am
Posts: 129
Location: Hannover
Post Reduce database size
Hello.

We're running redline 5.1 Build 949 on Netware. The database files on the redline installation are too large or the system. For the moment there are only 230MB free diskspace on sys: volume.

How can I reduce the filesize of these files? The mtamsgs.db has 2GB...

Tkanks in advance for your answers.

Best regards.

Dirk Emmermacher


Mon Jan 25, 2010 12:57 am
Profile

Joined: Fri Jan 13, 2006 1:14 pm
Posts: 110
Post Re: Reduce database size
You can set how long data is kept by editing the amount of records kept in the Configure | Database section of the Control Center. However, this will only remove data entered. The database size will not be reduced. New records would be placed in the now freed spaces. To reduce the size of the database, you must "vacuum" the database after removing old entries. We are currently testing a vacuum option for Redline, but it's not ready just yet. You can set the amount of data to keep as explained above, then after the maintenance has run to clean out old entries, you could then use an SQL tool such as SQLite to vacuum the database. Alternatively, I would recommend placing the Control Center on a Linux server rather than NetWare. There aren't any file size restrictions with Linux and Redline runs more efficiently on that platform.


Wed Feb 03, 2010 8:36 am
Profile

Joined: Tue Sep 27, 2005 12:45 am
Posts: 129
Location: Hannover
Post Re: Reduce database size
Hello Erico.

Thanks for your answer. So I'll play with SQLite to vaccum the database files.
I have an additional Redline installation on a Linux system. I think about your idea to move the database to this Linuxsystem.

Best regards.

Dirk


Wed Feb 03, 2010 8:42 am
Profile

Joined: Fri Jan 13, 2006 1:14 pm
Posts: 110
Post Re: Reduce database size
Sounds good.


Wed Feb 03, 2010 9:04 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © phpBB Group.
Designed by Vjacheslav Trushkin for Free Forums/DivisionCore.