MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID.
in_thread_id BIGINT: The ID of the thread to trace. The value should match theTHREAD_IDcolumn from some Performance Schemathreadstable row.in_verbose BOOLEAN: Whether to includefile:linenoinformation in the events.
mysql >选择sys.ps_thread_stack th(37岁,假)read_stack\G *************************** 1. row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "8.0.2-dmr-debug-log", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", "timer_wait": 256.35, "event_info": "sql/select", "wait_info": "select @@version_comment limit 1\nerrors: 0\nwarnings: 0\nlock time: ...