DX Application Performance Management

Expand all | Collapse all

Monitor MySQL database using EPAgent

Jump to Best Answer
  • 1.  Monitor MySQL database using EPAgent

    Posted 06-27-2013 03:18 AM
    Hi,

    I want to monitor my MySQL Database performance using EPAgent and publish metrics in Investigator.Please help me to achieve this.

    Thanks in advance.

    -Manirul


  • 2.  RE: Monitor MySQL database using EPAgent

    Posted 06-27-2013 06:34 AM
    Hello,

    I implemented CA Insight DPM r11.6 and I could monitor MySQL scans but I just came to know that MySQL scans dont flow in introscope through CA wily Bridge as its not supported.
    So please help me to publish MySQL related metrics in investigator through EPAgent.

    Thanks

    Manirul


  • 3.  RE: Monitor MySQL database using EPAgent
    Best Answer

    Posted 06-27-2013 01:35 PM
    You will need to do the same things as if you were using DPM Lite:

    [list][*]Create a read-only user with access to MySQL
    [*]Create a script to run queries to gather performance data. I'd recommend you check the MySQL documentation
    [*]Publish metrics to EPA as simple pairs or in XML format. Information is available in the EPA guide.[list]

    You can use whatever language suits you, as long it is supported by the host OS where EPA is installed. We already have a Perl module in EPA that can create XML data.


  • 4.  RE: Monitor MySQL database using EPAgent

    Posted 06-27-2013 01:46 PM
    Here is the reference from MySQL 5.6: http://dev.mysql.com/doc/refman/5.6/en/performance-schema-examples.html

    There is a chapter section pertaining to performance queries.