topic Re: VA new install table clutter? in Administration and Deployment

VA new install table clutter?

Tommp — Tue, 13 Feb 2018 13:03:39 GMT

I have a new VA install and there are bunch of LASR tables that came in by default with the installation. Are any of those actually useful/needed or can they be deleted without breaking things?

Thanks!

Re: VA new install table clutter?

alexal — Tue, 13 Feb 2018 13:08:30 GMT

@Tommp,

If you are talking about VA_SAMPLE_* tables, then yes, you can delete them. Do not delete AUDIT_VISUALANALYTICS.

Re: VA new install table clutter?

Tommp — Tue, 13 Feb 2018 13:21:41 GMT

Ok, so I can delete all the Va_Sample* stuff but I also see these guys on the LASR Analytic Server (not public):

Auidit_VisualAnalytics
Relationships_VisualAnalytics
Events
Filemounts
Gridmgr
Gridmgrhost
Hostplatforms
httpchecks
metadatsvrs
networkinterface

None of them are actually loaded... are they useful?

Thanks Again!
objspawners
saslogicalservers
tcsservers
webappserver
wipdatadb

Re: VA new install table clutter?

alexal — Tue, 13 Feb 2018 13:27:40 GMT

@Tommp,

Do not delete them, those metadata entries are related to auditing (you may enable that feature in the future). Anyway, even if you delete them, nothing bad will happen. EVDMLA will recreate them as soon as you enable auditing.