java实现监控mysql

<dependency>
    <groupId>javax.management</groupId>
    <artifactId>jmxremote</artifactId>
    <version>1.0</version>
</dependency>

import javax.management.*;
import javax.management.remote.*;
import java.util.Set;

public class MySQLMonitor {
    public static void main(String[] args) throws Exception {
        // 连接MySQL的JMX服务
        JMXServiceURL url = new JMXServiceURL("service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi");
        JMXConnector jmxConnector = JMXConnectorFactory.connect(url);
        MBeanServerConnection mbsc = jmxConnector.getMBeanServerConnection();

        // 获取MySQL的MBean对象
        ObjectName mysqlObjName = new ObjectName("com.mysql:type=Server");
        Set<ObjectName> objectNames = mbsc.queryNames(mysqlObjName, null);

        for (ObjectName name : objectNames) {
            // 获取属性值
            Long openConnections = (Long) mbsc.getAttribute(name, "OpenConnections");
            System.out.println("Open Connections: " + openConnections);
        }

        // 关闭连接
        jmxConnector.close();
    }
}

[mysqld]
# 启用JMX远程监控
jmxremote=true
jmxremote.port=9999
jmxremote.ssl=false
jmxremote.authenticate=false