Note: for custom KPIs documentation go to the customKPI page.
Configuration options description
The configuration defined in config.yaml file. Some of the settings can be applied without restart by executing Actions -> Reload Config, but some require restart of the application.
Integer. Font size for the chart labels.
DPIAwareness (since 091 beta I)
Scale graphics and fonts according to system display settings. Enabled by default.
By default the system locale used for number formatting: decimal and thousands separators. This can be changed by enforsing different locale. To get the list of available locales you can set some garbage value and in this case list of available locales will be written into the log file. To me honest, it is easier to change your system setting to have proper number formatting. Unfortunately, locales stuff is not very flexible.
Enforce thouthands separator character. In this case non-breaking space code provided. This setting overrides locale. Make sure you use double-quotes for this one.
Enforce decimal point character.
Disable new improved numbers formatting routines (and use the legacy ones)
Changes the chart background to the specified value. Useful for dark XP-like color schemes.
Boolean. Force memory KPIs to be displayed in GB instead of default MB.
Enables chart to send keep alive dummy queries to avoid disconnection due to inactivity.
Saves the window layout: position, size, etc. Information saved in layout.yaml - delete it in case of problems.
Saves enabled KPIs. KPIs saved per host/port pair. Information saved in layout.yaml - delete it in case of problems. This feature requres saveLayout to be enabled.
When enabled - open consoles will be re-opened after the restart, even if not saved. Backups will be saved in “bkp” folder. This feature requres saveLayout to be enabled.
Log level, maximum is 5 it will dump every executed SQL statement
Controls the time scale hint on the chart legend. Set it to False to disable, enabled by default, available in v.07
Enables legend to include service name and tenant name, useful in multi-tenant monitoring from SystemDB. Disabled by default, available since v09
Skip the tenant name check for the initial connection. Usually not requred as this is very quick and works even on old non-MDC installations.
ganttOldImplementation (v 0.9)
Boolean. Eenable to switch to old gantt render algorithm (potentially slow, see .log file for measurements)
autorefreshThreshold (v 0.9)
Integer threshold in seconds. If refresh takes longer than this value - autorefresh will be disabled. Default is 0 (no threshold).
chartWidth (v 0.9)
Chart line width. In most of the cases the default (1) is fine, but sometimes (for example when colorize enabled) value 2 makes chart more readable.
Boolean. Enables experimental functionality.
Decimal. Default scaling factor for the “Adjust Fonts” action.
SQL Console related
Console editor font scale
Sets light gray backgtound for LOB fields just to be aware
Enables sql console to send keep alive dummy queries to avoid disconnection due to inactivity.
Lowercase column names when possible. We seriously think about the environment, lets save some ink when we can, uppercase is bad for environment.
Number of rows fetched for the result set
SQL NULL value representation for table output
SQL NULL value representation for CSV or Copy
Set this to True to disable words/brackets highlighting. By default words are highlighted on selection.
Enables data_format_version2: extended data types including longdate - timestamps with microsecond precision.
raduga: ['#20b2aa', '#32cd32', '#7f007f', '#ff0000', '#ff8c00', '#7fff00', '#00fa9a', '#8a2be2', '#dc143c', '#0000ff', '#da70d6', '#d8bfd8', '#ff00ff', '#1e90ff', '#db7093', '#ffff54', '#ff1493', '#7b68ee', '#ffa07a', '#008000', '#3cb371', '#b8860b', '#4682b4', '#000080', '#9acd32', '#afeeee', '#7fffd4', '#ffdead', '#2f4f4f', '#556b2f', '#a0522d', '#483d8b']
This list defines colors to be used with colorize option (see below).
colorize (v 0.9)
Use colors defined by “raduga” list instead of standard ones. Same can be achieved by menu Actions -> Colorize KPIs.
Potentially useful to distinguish same KPI for different nodes in scale-out env. When this option is enabled colours will be extracted one by one from the list in this order. In order to have consistent colours for the same KPIs you will need to enable KPIs in the same order.
Timeout for detaching resultsets containing LOB values. Default value is 300 seconds.
blockLineNumbers (v 0.9)
In case of DB exceptions, like syntax errors, HANA will report the line number of the error. This line number is inside the execured SQL string and not line number of the console. With this option enabled the console line numbers will only be displayed for the highlighted SQL string, so the reported DB error string should correspond to the displayed line numbers. Can be disabled by setting it to False.
updatesCheckInterval (v 0.91)
Updates will be checked every 7 days (default). You can set it to 0 in order to disable check of updates.
By default only major releases will be checked. You can set this parameter to True to also be notified about beta releases. Check period controlled by updatesCheckInterval.
abap-length (v 0.91)
Number of characters limiting value length for ABAP style copy. The default value is 32.
abap-length (v 0.91)
You can set copy-markdown to False to switch to pure ascii table formatting instead of markdown.
connectionsFile (v 0.91)
Optional path to credentials/connections file. The setting might be useful when several RybaFish instances used on the same machine. The default behaviour is to have separate connections.yaml per RybaFish instance (copy).
screensFolder (v 0.91)
Optional path for to save screenshots. Might be useful when several instances of RybaFish Charts used.
customKPIsFolder (v 0.91)
Optional path to custom KPIs folder. Might be useful when several instances of RybaFish Charts used.
contextSQLsFolder (v 0.91)
Optional path to context SQLs folder. Might be useful when several instances of RybaFish Charts used.
scriptsFolder (v 0.91)
Optional path to sql scripts folder, thde default is local ‘scripts’. Used in SQL Browser: menu -> SQL or F11.
sqlConsoleToolbar (v 0.91)
You can change it to False in config to manualy disable it. Similar can be acheive by menu -> Actions -> SQL Console Toolbar.
threadSafeLogging (v 0.91)
In case you observe slow-downs or freezing duging loggings, try to disable this parameter (False) to avoid mutex usage during logging. The default is True - this should make logging thread safe (only since 0.91 beta 5)
import_timezone_offset (v 0.91)
import_timezone_offset: 7200 # CET summer time (CEsT)
By default import of the nameserver_history.trc file will display data in your local time zone. In most cases it is much more useful to have data in the system time zone, this is where this parameter can help. Unfortunatelly the trace does not contain this information but you can manually define the trace timezone in seconds as an offset from the UTC. To get this value from the source system you can execute:
select distinct key, value from m_host_information where key in ('timezone_offset'). It is delta in seconds from UTC.
Note: 0 and no value has very different meaning in this context: no value = your local timezone, 0 = UTC.
The parameter needs to be set before you start the import.
The alternative way to manually specify the file time zone is to have filename postfix like ‘_utc7200.trc’, it will have the same effect. When the negative shift required - just use the ‘minus’ sign between ‘utc’ and number of seconds. Examples: EST (UTC-5) namserver_history_utc-18000.trc, CEsT namserver_history_utc7200.trc
File naming UTC shift has higher priority than configuration setting.
verifyGroupUnits (v 0.93)
This setting disables check of sUnit/dUnit kpi description integrity. In case same scaling group has inconsistent sUnit/dUnit - an exception will be generated. The check is enabled by default, can be disabled in case of issues.