My Oracle Support Banner

Massive "SHOW WARNINGS" Load on MySQL Database (Doc ID 2860235.1)

Last updated on APRIL 13, 2022

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

Following query shows database statistics information with a huge amount of "SHOW WARNINGS":

 

The query used to provide the statistics information:

 

 

 

 

Relevant information:

 

This MySQL Server is monitored by MEM.
  
Connector/J used by the application to connect to the server is mysql-connector-java-commercial 5.1.48
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.