ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MySQL Infrastructure Agent Not Reporting MySQL Metrics


Article ID: 200844


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management


MySQL Infrastructure Agent not reporting MySQL metrics and throwing below exception:

9/29/20 10:01:59 AM CDT [ERROR] [IntroscopeAgent.DBMonitor] 
java.sql.SQLSyntaxErrorException: (conn=13762) Table 'performance_schema.global_variables' doesn't exist
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(
 at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(
 at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(
 at org.mariadb.jdbc.MariaDbStatement.executeInternal(
 at org.mariadb.jdbc.MariaDbStatement.executeQuery(
 at java.util.concurrent.ThreadPoolExecutor.runWorker(
 at java.util.concurrent.ThreadPoolExecutor$
Caused by: java.sql.SQLException: Table 'performance_schema.global_variables' doesn't exist
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(
 at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(
 at org.mariadb.jdbc.MariaDbStatement.executeInternal(
 ... 7 more


DX Application Performance Management MySql SaaS Agent.
MySQL 8.x release.


This happens due to the incompatibility of MySql database, make sure that you are trying to monitor MySQL database 8.x which is supported by Broadcom.

Any other MySql that you try to monitor, you will see the exception reported in this knowledge article.

Additional Information