Deployment Guide

DATABASE MAINTENANCE
In order to keep the database working optimally, it is suggested that the following database maintenance
tasks are scheduled to be done automatically:
1. Online data purges. Data purges prevent database file systems to not get full.
2. Database backups. Recent backups are mandatory in order to recover from fatal file system
errors, broken disks, etc.
3. Table / index reorganizations. By doing regular reorganizations the database structure stays in
optimal shape.
4. Collecting statistics. This keeps database query access paths optimized.
5. Watching DB / log filesystem usage. This prevents database corruption if filesystems are getting
full.
Because any of tasks can take a considerably long time to execute, it is important to be able to execute the
tasks in the background:
Install tmux:
# yum install tmux
tmux commands:
● Start a new session: tmux
● Detach from the session without closing it: CTRL b+d
● Joining to the created session: tmux a
● Exiting from the session and closing it: exit
7signal Solutions Inc., 6155 Rockside Road, Suite 110, Independence, Ohio 44131, USA,
216-777-2900, [e-mail], www.7signal.com