The notification panel is the section that will provide suggestions to optimize your cluster.
Notifications are organized into 3 groups: INFOS, WARNING, and DANGER.
Each notification comes with a way to address the issue.
How to start my notification panel
By default, notifications are not enabled.
You have to set the cron expression for the property
For a refresh of notifications every 15 minutes
SET_ notification.check.cron = '0 0/15 * * * ?'
For a refresh of notifications on the last day of the month
SET_ notification.check.cron = '0 0/15 * L * ?'
For a refresh notifications from 8 p.m. to 8 a.m.
SET_ notification.check.cron = '0 0 20-8 * * ?'
After that, you can see your notifications in Cluster View
or from the Data View dashboard
How to use my notification panel
Once your panel is enabled, you will notice several types of notifications.
By clicking on a notification, you will be able to see the details and a button to address it.
Once you have resolved a notification, it won't disappear until the notifications are checked again. By clicking on the refresh button, suggestions will be computed again.
List of notified elements
|INFO||LIMITED_TABLE||Display limited tables that should be converted into fact tables to reduce the memory consumption|
|WARNING||OPTIMIZE_TABLE||Display when a table has a percentage of queries using the main index only. You should run the optimizer to create new indexes|
|WARNING / DANGER||INDEX_SIZE||Display when an index size is approaching index.memory.max_size.mb. Two thresholds, in notifications.json, define the gravity of the notification.|
|WARNING / DANGER||TABLE_SIZE||Display when table size is approaching table.memory.max_size.mb. Two thresholds, in notifications.json, define the gravity of the notification.|
|DANGER||INTEGRITY_CHECK||Display tables that are corrupted and can't be restored.|
|WARNING||NEED_COMPACTION||Display tables that need an ALTER TABLE COMPACT because of shadow rows, provoked during multiple DELETE / LOAD operations.|
|INFO||DEPRECATED_PARAMETER||Display parameters in galactica.conf which are deprecated. These parameters will be removed in future versions.|
|INFO||UNUSED_INDEX||Display indexes which aren't been used for 30 days. They could be removed to reduce memory/disk spaces.|
|INFO||EXTERNAL_TABLE_WITHOUT_INDEX||Display external tables without any indexes, meaning that all queries will be delegated to the underlying database.|
Modify the list of displayed notifications
Go to notifications.json