Is there any metric in mysql plugin to monitor database growth ?

[arun2arunraj]

Hi Developers,

    We are using MySQL as a database server. Our transaction rate is million records per hour.

    We would like to analyse the database growth with RHQ. Is it possible ?

Regards,

ArunRaj.

[tsegismont]

Hi Arun,

You can write a child plugin of the mysql plugin. In this plugin you'll add a Generic query server or service, as explained in the generic database plugin descriptor. You need a trends up metric, which will give you per minute metrics automatically. And eventually, you need to design a query to get Mysql database size.

Regards,

Thomas

[arun2arunraj]

Hi Thomas,

    Thanks for the needful help.

    Just for curious, Will it produce any performance issue ?

Regards,

ArunRaj.

[tsegismont]

Arun Raj a écrit:

    Just for curious, Will it produce any performance issue ?

What do you mean?

[arun2arunraj]

Thomas Segismont wrote:

You need a trends up metric, which will give you per minute metrics automatically

To achieve per minute metrics, RHQ Agent have to query records from mysql server. Will it produce any performance issue to Mysql Server ? Because The mysql Server is having our transactional db in which we would like to see the db growth.

[tsegismont]

Arun,

Per minute metrics values are derived by the plugin container on the agent, they have no impact on your MySQL server.

Thomas