Installation guide

Service Scheduler – Installation Guide

Version 0.8

Page 39 of 42

Frequently Asked Questions (FAQ)

How large will my database get?

The database will continue to grow. We have calculated an average of approx 15000 records

in 7 years. An example database with 20,000+ records and 1,000,000+ audit records had a

database size on disk is 179MB. The database backup files are plain text SQL and are 120 MB

x 7 days. So 7 years may require 1 GB per site.

Are there any maintenance schedules that need to be run on the

Database to keep them running efficiently?

No. Although it is possible to check database sizes and run a check over tables using

HeidiSQL. http://www.heidisql.com/ HeidiSQL also provide quick access to MySQL status

information

We do recommend you perform a monthly check on your server (ie disk space, CPU usage,

windows updates etc)

Backups currently run nightly, what happens if DB corruption occurs

during the day? Do we lose transactions?

MySQL InnoDB tables are very good a recovering themselves, and upon a restart will process

any recovery logs. If database corruption occurs we would recommend restoring a previous

backup.