13.5 Diagnostics Report

Note

MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.

Introduction

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 index.html.

Important

Because generating a dignostic 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.

Diagnostics Report File Contents

An example MysqlConnectionConfiguration snippet from query.instanceOverview.html:

Asset: {com.mysql.etools.inventory.model.agent.MysqlConnectionConfiguration : 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2}
autoManagingMysqlUsers = false
connectTimeout = 10000
host = localhost
id = 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2
identity = {com.mysql.etools.inventory.model.agent.MysqlConnectionConfiguration : 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2}
inventorySchema = mysql
ip = /127.0.0.1
limitedUser = null
port = 23306
processUser = null
socketPath = null
socketTimeout = 60000
superUser = root
timestamp = 2014-01-27T18:40:18.798Z
topologyDiscovery = true
version = 1390522556122
– availability is not present
– operationStats is not present
agent = {com.mysql.etools.inventory.model.agent.Agent : 8f8751fc-664b-4b1a-a19d-34930e4fadca}
server = {com.mysql.etools.inventory.model.mysql.MysqlServer : 1b51b1f0-848c-11e3-a32d-bd2376e51ddd}
mysqlConnectionStates = [
{com.mysql.etools.inventory.model.agent.MysqlConnectionState : 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2.PROCESS},
{com.mysql.etools.inventory.model.agent.MysqlConnectionState : 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2.SUPER},
{com.mysql.etools.inventory.model.agent.MysqlConnectionState : 5b16fc9e-8b34-36d7-a6bd-94c2d435a1d2.LIMITED},
]