MySQL Integration

Configure the Watchlog Agent to monitor your MySQL databases, query activity, and connection stats.

Start Free Trial

1. Install Watchlog Agent

Ubuntu

Windows

Source

2. Configure Integration

Open integration.json in your agent directory and add the MySQL block: 


  {
    "service": "mysql",
    "monitor": true,
    "host": "localhost",
    "port": "3306",
    "username": "root",
    "password": "",
    "database": ["mydb"]
  }

Then restart the agent to apply changes:

Linux Restart

pm2 restart watchlog-agent

Windows Restart

Restart-Service -Name "WatchlogAgent"

Explore MySQL Monitoring Capabilities

Database Overview

MySQL version, max connections, uptime, total DB size, table & index counts.

Query Activity

Real-time charts for SELECT, INSERT, UPDATE, DELETE operations over time.

Connection Activity

Monitor active connections, new connects per interval, and aborted clients.

Slow Queries

Track queries exceeding performance thresholds to identify bottlenecks.

Opened Tables

Monitor table open count to tune table_open_cache efficiently.

Avg Active Connections

See time-based average of active sessions for load insights.

All metrics available in real time or over custom time ranges via the Watchlog dashboard.

Start Monitoring MySQL