10.3 Upgrade File IQ Database Optimization

Prev Next

Warning: This feature requires a mandatory database schema migration and imposes strict disk space requirements on the File IQ DB disk. Customers should verify requirements as described on this page before upgrading to version 10.3.

Introduction

When upgrading to Nasuni File IQ 10.3, the system performs a one-time database migration to optimize internal data structures. This process begins automatically after the upgrade to Nasuni File IQ 10.3 completes and requires no user action.

To monitor progress, see Monitoring update progress.

Upgrade Planning

Disk Space Requirements

Database migration requires that the File IQ DB Disk has the following free space available:

Total Space Required = Current Used Space + (2×FSMS Schema Size) + (0.1×Total Disk Capacity)

These variables are calculated as follows:

Variable

Details

Current Used Space

The information necessary to determine this value is available on the Nasuni File IQ System Status Dashboard, in the DB Size and DB Usage % panels.

Use the information presented in these panels to determine the current disk usage given the total size and the percentage used.

FSMS Schema Size

FSMS schema size is presented in the Database Schema Size panel of the Grafana Database Support Dashboard.

Total Disk Capacity

Total DB size Nasuni File IQ System Status Dashboard, panel DB Size.

Note: If there is insufficient disk space, the upgrade is not performed, and a notification is displayed in both the File IQ UI and the Nasuni Management Center (NMC) UI.

Disk Space Calculation Example

In this example, the following values are given:

  • 500 GB Nasuni File IQ Database Disk.

  • FSMS schema size of 187GB.

  • Nasuni File IQ Database Usage of 200GB (40% of 500GB).

Step 1 — Calculate Required Free Space

The required migration space:

2 × FSMS Schema Size = 2 × 187 = 374 GB

Headroom:

0.1 × 500 = 50 GB

Total required free space:

374 + 50 = 424 GB

Step 2 — Calculate Available Free Space

Capacity − Used = 500 − 200 = 300 GB, where 200 GB is the calculated Nasuni File IQ Database Disk usage.

Step 3 — Compare

  • Required free space: 424 GB

  • Available free space: 300 GB

Result: The upgrade cannot proceed. An additional 124 GB of free space is required in order for the migration to proceed.

Step 4 — Select Minimum Disk Size

Required: Capacity − 200 ≥ 374 + (0.1 × Capacity)

Solve: Capacity − 0.1 × Capacity − 200 ≥ 374

=> 0.9 × Capacity − 200 ≥ 374

=> 0.9 × Capacity ≥ 574

Capacity ≥ 637.8 GB

Therefore, a File IQ DB disk of at least 638 GB is required, and in practice, provisioning 650 GB or larger satisfies the requirement.

If provisioned disk space is insufficient for migration to proceed, a message indicating the required disk space is displayed on the Nasuni File IQ Status Page.

Note: After making the disk space available, the appliance must be rebooted to proceed with database migration.

System Behavior During Update

When audit event processing is enabled, it continues to operate normally during the update. Audit data collection and processing are not interrupted.

During the update process, the following functions are temporarily paused:

  • Volume delta scans are not performed.

  • Any report executed remains enqueued until the update completes.

  • Advanced metadata filtering indexes are not refreshed.

  • Grafana metadata dashboards do not populate; instead, they display “No data“ or there are empty panels.

All affected functionality automatically resumes after the update completes.

Expected Duration of the Update Process

The duration of the one-time update depends on the total number of files managed by the system. As a general guideline, the process takes approximately 1.25 days per 400 million files and directories.

The following chart illustrates estimated update durations for common volume sizes, with a file-to-directory ratio of 20:1:

Note: Actual duration may vary based on system performance and workload characteristics.

Monitoring Update Progress

When the update is underway, status information is surfaced at the following Nasuni File IQ user interfaces.

Grafana Dashboards

A notification banner is displayed in Grafana to indicate that the update is in progress. This banner is displayed on all dashboards.

File IQ Status Page

The message "Database migration is in progress" is displayed on the Nasuni File IQ Status page while the update is in progress.

If the update cannot proceed, for example, due to insufficient disk space, the reason is also displayed here.

While the database optimization is in progress, the message “Nasuni File IQ API service check” is expected to show an error. The check passes successfully once the optimization is complete.

Grafana Service Support Dashboard

Update progress can be monitored on a per-volume basis at the Volume Scan Detailed Status panel.

Volumes are processed sequentially. Each volume progresses through a defined set of states, which are recorded in the Volume Scan State Logs table. The update lifecycle for a volume follows this general sequence:

  1. Starting database migration: Indicates that processing has begun for the selected volume.

  2. Database migration in progress: Indicates the approximate migration progress for a given volume. This estimate is refreshed every 5 minutes.

  3. Database migration Complete: Indicates that all relationship updates for the volume have completed successfully.

The Percent, Estimated Relationships, and Processed Relationships columns provide additional visibility into real-time progress for the active step.

After the migration for each volume completes, the system automatically proceeds to the next volume in sequence until all volumes have been processed.

Afterwards, the update performs a database index and constraint maintenance on a database-wide basis, as reflected in the Service Support Dashboard.