MySQL Enterprise Monitor 4.0.13 Manual
To get the text and details of the queries displayed on the
Query Analyzer page, click one of the icons
to the right of the Browse Queries label in
the separator bar. The query information is exported as
comma-separated data in a .csv
file, with
fields corresponding to the columns shown in the Monitor UI, and
the time of the export encoded in the filename in UTC format. The
icon representing a single page exports the query information for
the currently displayed page only. The icon representing a stack
of pages exports the query information for all available pages of
query information.
Within the Query Analyzer pop-up, you can
also export information about each data group as a
.csv
text file or a .png
image file, using icons next to the labels on the left side. The
output file is named according to the pattern
Statement_Report_Summary_%server/group%_%creationtimestamp%.csv
.
The data exported by these icons includes:
Execution Time: Count
Executions: Exec Time, Max Exec Time, Min Exec Time, Average Exec Time
Rows: Rows, Max Rows, Min Rows, Average Rows
Kilobytes: Bytes, Max Bytes, Average Bytes
Microsoft Excel users on Windows users can import the
.csv
file as a spreadsheet. If the file
contains English text, typically you can double-click it to open
in Excel. If the file contains localized Japanese text, you must
use the File > Open menu choice within
Excel to open the file.
In the Safari browser, exported files containing localized data
might contain %
character sequences in their names, due to browser issues with
UTF-8 and Base64 encodings.
NN