[
https://issues.apache.org/jira/browse/GERONIMO-3541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viet Hung Nguyen updated GERONIMO-3541:
---------------------------------------
Attachment: geronimo-3541.patch
I have changed the db structure to be as the following:
Statistics
-mbeanid (F.K. refs MBeans.id)
-snapshotid (F.K. refs Snapshots.id)
-statsValue
-statsName
MBeans
-id (P.K.)
-mbeanName
Snapshots
-id (P.K.)
-snapshot_time
-snapshot_date
Erik, I do not think that putting statistics names in a CSV list in a db is a
good practice. And in this case, I will not be able to save a statsValue for
each statsName if I did that. There would not be a way of mapping it. However,
I have broken up the table into multiple pieces as we have discussed before.
If someone could take a look at this, it will be great, because it is a
significant part that needs to be established before we can move on to other
things.
> monitoring plugin: collecting agent needs to use a database to store the
> snapshots instead of xml
> -------------------------------------------------------------------------------------------------
>
> Key: GERONIMO-3541
> URL: https://issues.apache.org/jira/browse/GERONIMO-3541
> Project: Geronimo
> Issue Type: Improvement
> Security Level: public(Regular issues)
> Components: monitoring
> Affects Versions: 2.1
> Environment: windows
> Reporter: Viet Hung Nguyen
> Attachments: geronimo-3541.patch
>
>
> The DB needs to be populated with snapshot statistics. Also, the functions
> used to query snapshots needs to be migrated from reading from XML files to a
> DB.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.