This chapter describes the Diagnostics Report.
You can obtain a diagnostics report file for either individual
servers, or entire server groups. To get a diagnostic report file,
select Diagnostics Report from the
Settings menu. The information is provided as
a time stamped Zip file (such as
support-20130815T2238.zip) that is downloaded
to the machine. The information contained in the report includes
detailed information about your server (or multiple servers if you
selected a server group), including configuration, hardware, MySQL
options/variables and historical graphs. To view the information
extracted, unzip the downloaded file and double-click the
Because generating a diagnostic report is an expensive operation, the Diagnostics Report report is cached for six hours. All requests within this six hour time period will pull (download) this cached report. A request after this period will trigger a new report to be generated.
This report is especially useful for debugging the MySQL Enterprise Service Manager and the MySQL Enterprise Monitor Agent. When filling out a My Oracle Support (MOS) ticket, it is common practice for the support team to ask for this report.
audit.log: The Audit log file.
catalina.out: A Tomcat log file.
com.mysql.etools.agent.csv: A built-in
MySQL Enterprise Monitor Agent log file.
java-threads.dot: A list of the current
Java threads and the dependencies.
java.props: The current Java
java.threads: A list of the current Java
threads and their backtrace.
mysql-monitor.log: The general
MySQL Enterprise Service Manager log file.
mysql-monitor-full.log: The full
MySQL Enterprise Service Manager log file, that also contains stack traces.
mysql-monitor-agent.log: A general
built-in MySQL Enterprise Monitor Agent log file.
mysql-monitor-agent-full.log: A full
built-in MySQL Enterprise Monitor Agent log file, that also contains stack
preferences.properties: The MySQL Enterprise Monitor
product usage.html: A usage report for
each MySQL Enterprise Monitor User Interface page.
query.instanceOverview.html: An HTML list
of the current query instance related information.
The format of this file changed in 3.0. It is now listed as one Asset per block, instead of having one row per Asset inventory item.
Replication 1.dot: The calculated MySQL
server replication structure.
root.csv: A copy of your main MySQL Enterprise Monitor
server.props: A copy of your server
tomcat.log: A Tomcat log file.