Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

30.4.5.16 The ps_thread_stack() Function

Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID.

Parameters

  • in_thread_id BIGINT: The ID of the thread to trace. The value should match theTHREAD_ID column from some Performance Schemathreads table row.

  • in_verbose BOOLEAN: Whether to includefile:lineno information in the events.

Return Value

ALONGTEXT CHARACTER SET latin1 value.

Example
mysql> SELECT sys.ps_thread_stack(37, FALSE) AS thread_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:...