The MySQL plugin 'discovers' the list of tables and creates resources for each one. For my application, we create new hundreds of new database tables constantly which are soon dropped.
Is there a potential problem with adding these tables to the discovery queue? Should I attempt to patch the plugin to ignore these tables entirely?
If there's no issue, then perhaps I do not need to address this at all.
Actually, I'd rather prefer it if discovery was disabled (or could be) on a server or host basis. Is there such a way? Thanks.
Non-top-level-servers or services are auto-imported into inventory. If they later become defunct (i.e. their underlying tables go away), RHQ has no builtin mechanism to automatically uninventory them. That means you'll have to manually univentory table resources once they become defunct, otherwise you'll end up with a whole bunch of DOWN table resources in inventory that correspond to tables that no longer exist.
So I'd say you probably don't want to autodiscover the short-lived tables.
One potential way to tell the plugin which tables are short-lived and which are not would be to add a "excludedTablesRegex" plugin configuration property to the parent resource type (database?). The table discovery component could then exclude any tables whose names match that regex.
|Retrieving data ...|