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 notifications come 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
notification.check.cron. For instance:
SET_ notification.check.cron = "0 0/15 * * * ?" // every 15 minutes
After that, you can see your notifications in Monitor.
How to use my notification panel
Once your panel is enabled, you will notice several types of notifications. Each type has main buttons allowing you to contact support if necessary or to go to a specific page of documentation.
By clicking on a notification, you will be able to see the details and a button to address them.
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. The refresh button looks like this:
List of notified elements
|INFO||LIMITED_TABLE||Display limited tables that should be converted into fact table 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 threshold, in notifications.json, define the gravity of the notification.|
|WARNING / DANGER||TABLE_SIZE||Display when a table size is approaching table.memory.max_size.mb. Two threshold, in notifications.json, define the gravity of the notification.|
|DANGER||INTEGRITY_CHECK||Display tables which are corrupted and can't be restored.|
|WARNING||NEED_COMPACTION||Display tables which need an ALTER TABLE COMPACT because of shadow rows, provoqued during multiple DELETE / LOAD operations.|
|INFO||DEPRECATED_PARAMETER||Display parameter in galactica.conf which are deprecated. These parameters will be removed in future version.|
|INFO||UNUSED_INDEX||Display indexes which aren't used since 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 list of displayed notifications
Go to notifications.json