Administration Server maintenance

The Administration Server maintenance allows you to reduce the database volume, and improve the performance and operation reliability of the application. We recommend that you maintain the Administration Server at least every week.

The Administration Server maintenance is performed using the dedicated task. The application performs the following actions when maintaining the Administration Server:

• Checks the database for errors.
• Re-organizes database indexes.
• Updates the database statistics.
• Shrinks the database (if necessary).

The Administration Server maintenance task supports MariaDB versions 10.3 and later. If you use MariaDB versions 10.2 or earlier, administrators have to maintain this DBMS on their own.

To create the Administration Server maintenance task:

1. In the console tree, select the node of the Administration Server for which you want to create the Administration Server maintenance task.
2. Select the Tasks folder.
3. By clicking the New task button in the workspace of the Tasks folder.

   The New task wizard starts.

4. In the Select the task type window of the wizard, select Administration Server maintenance as the task type, and then click Next.
5. If you have to shrink the Administration Server database during maintenance, in the Settings window of the wizard, select the Shrink database check box.
6. Follow the rest of the wizard instructions.

The newly created task is displayed in the list of tasks in the workspace of the Tasks folder. Only one Administration Server maintenance task can be running for a single Administration Server. If an Administration Server maintenance task has already been created for an Administration Server, no new Administration Server maintenance task can be created.