stage/sql/Sorting result statement/com/Execute statement/com/Query statement/sql/create_table statement/sql/lock_tables errors 

The instrument name space has a tree-like structure. The elements of an instrument name from left to right provide a progression from more general to more specific. The number of elements a name has depends on the type of instrument. 

The interpretation of a given element in a name depends on the elements to the left of it. For example, myisam  appears in both of the following names, but myisam  in the first name is related to file I/O, whereas in the second it is related to a synchronization instrument: 

wait/io/file/myisam/log wait/synch/cond/myisam/MI_SORT_INFO::cond 

Instrument names consist of a prefix with a structure defined by the Performance Schema implementation and a suffix defined by the developer implementing the instrument code. The top-level element of an instrument prefix indicates the type of instrument. This element also determines which event timer in the performance_timers  table applies to the instrument. For the prefix part of instrument names, the top level indicates the type of instrument. 

The suffix part of instrument names comes from the code for the instruments themselves. Suffixes may include levels such as these: 

•A name for the major element (a server module such as myisam , innodb , mysys , or sql ) or a plugin name. 

•The name of a variable in the code, in the form XXX  (a global variable) or CCC :: MMM  (a member MMM  in class CCC ). Examples: COND_thread_cache , THR_LOCK_myisam , BINLOG::LOCK_index . 

## Top-Level Instrument Elements 

•Top-Level Instrument Elements 

•Idle Instrument Elements 

•Error Instrument Elements 

•Memory Instrument Elements 

•Stage Instrument Elements 

•Statement Instrument Elements 

•Thread Instrument Elements 

•Wait Instrument Elements 

• idle : An instrumented idle event. This instrument has no further elements. 

• error : An instrumented error event. This instrument has no further elements. 

• memory : An instrumented memory event. 

• stage : An instrumented stage event. 

• statement : An instrumented statement event. 

