You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernt M. Johnsen (JIRA)" <ji...@apache.org> on 2008/03/06 14:58:59 UTC

[jira] Created: (DERBY-3500) Implement a DatabaseMBean for monitoring of a database

Implement a DatabaseMBean for monitoring of a database
------------------------------------------------------

                 Key: DERBY-3500
                 URL: https://issues.apache.org/jira/browse/DERBY-3500
             Project: Derby
          Issue Type: New Feature
          Components: JMX
            Reporter: Bernt M. Johnsen
             Fix For: 10.5.0.0


Implement a DatabaseMBean for monitoring of a database. Example attributes
- various database properties
- disk writes pr. second
- disk reads pr. second
- data cache statistics
- statement cache statistics
- queries pr. second
etc.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3500) Implement a DatabaseMBean for monitoring of a database

Posted by "Bernt M. Johnsen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bernt M. Johnsen updated DERBY-3500:
------------------------------------

    Attachment: DERBY-3500-v1.stat
                DERBY-3500-v1.diff

Improved somewhat and added some replication mbeans. It is now possible to monitor the replication master buffer fill percent. Still no security nor javadoc.

> Implement a DatabaseMBean for monitoring of a database
> ------------------------------------------------------
>
>                 Key: DERBY-3500
>                 URL: https://issues.apache.org/jira/browse/DERBY-3500
>             Project: Derby
>          Issue Type: New Feature
>          Components: JMX
>            Reporter: Bernt M. Johnsen
>         Attachments: DERBY-3500-v0.diff, DERBY-3500-v0.png, DERBY-3500-v0.stat, DERBY-3500-v1.diff, DERBY-3500-v1.stat
>
>
> Implement a DatabaseMBean for monitoring of a database. Example attributes
> - various database properties
> - disk writes pr. second
> - disk reads pr. second
> - data cache statistics
> - statement cache statistics
> - queries pr. second
> etc.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3500) Implement a DatabaseMBean for monitoring of a database

Posted by "Dyre Tjeldvoll (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dyre Tjeldvoll updated DERBY-3500:
----------------------------------

    Fix Version/s:     (was: 10.5.0.0)

Removing Fix-version for unassigned issues

> Implement a DatabaseMBean for monitoring of a database
> ------------------------------------------------------
>
>                 Key: DERBY-3500
>                 URL: https://issues.apache.org/jira/browse/DERBY-3500
>             Project: Derby
>          Issue Type: New Feature
>          Components: JMX
>            Reporter: Bernt M. Johnsen
>
> Implement a DatabaseMBean for monitoring of a database. Example attributes
> - various database properties
> - disk writes pr. second
> - disk reads pr. second
> - data cache statistics
> - statement cache statistics
> - queries pr. second
> etc.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-3500) Implement a DatabaseMBean for monitoring of a database

Posted by "Bernt M. Johnsen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bernt M. Johnsen updated DERBY-3500:
------------------------------------

    Attachment: DERBY-3500-v0.png
                DERBY-3500-v0.stat
                DERBY-3500-v0.diff

As a "proof of concept": A patch that implements a DatabasMBean interface with an BasicDatabaseMBeanImpl implementation. Implements number of locked objects (in the sense of rows and tables) and transactions per second. Attached is also a JConsole screen shot. The patch needs more work (e.g comments ;-) and security stuff, but comments are very welcome.

> Implement a DatabaseMBean for monitoring of a database
> ------------------------------------------------------
>
>                 Key: DERBY-3500
>                 URL: https://issues.apache.org/jira/browse/DERBY-3500
>             Project: Derby
>          Issue Type: New Feature
>          Components: JMX
>            Reporter: Bernt M. Johnsen
>         Attachments: DERBY-3500-v0.diff, DERBY-3500-v0.png, DERBY-3500-v0.stat
>
>
> Implement a DatabaseMBean for monitoring of a database. Example attributes
> - various database properties
> - disk writes pr. second
> - disk reads pr. second
> - data cache statistics
> - statement cache statistics
> - queries pr. second
> etc.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.