Movatterモバイル変換

Examining a trace in themysql command-line client can be made less difficult using thepager less command (or your operating platform's equivalent). An alternative can be to send the trace to a file, similarly to what is shown here:

SELECT TRACE INTO DUMPFILEfileFROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;

You can then pass this file to a JSON-aware text editor or other viewer, such as theJsonView add-on for Firefox and Chrome, which shows objects in color and allows objects to be expanded or collapsed.

INTO DUMPFILE is preferable toINTO OUTFILE for this purpose, since the latter escapes newlines. As noted previously, you should ensure thatend_markers_in_json isOFFwhen executing theSELECT INTO statement, so that the output is valid JSON.