(Recent tables) ...
`mysql`.`proc`
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
ยป
Database: performance_schema
Structure
SQL
Search
Query
Export
Column:
`cond_instances`.*
`cond_instances`.`NAME`
`cond_instances`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.*
`events_waits_current`.`THREAD_ID`
`events_waits_current`.`EVENT_ID`
`events_waits_current`.`EVENT_NAME`
`events_waits_current`.`SOURCE`
`events_waits_current`.`TIMER_START`
`events_waits_current`.`TIMER_END`
`events_waits_current`.`TIMER_WAIT`
`events_waits_current`.`SPINS`
`events_waits_current`.`OBJECT_SCHEMA`
`events_waits_current`.`OBJECT_NAME`
`events_waits_current`.`OBJECT_TYPE`
`events_waits_current`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.`NESTING_EVENT_ID`
`events_waits_current`.`OPERATION`
`events_waits_current`.`NUMBER_OF_BYTES`
`events_waits_current`.`FLAGS`
`events_waits_history`.*
`events_waits_history`.`THREAD_ID`
`events_waits_history`.`EVENT_ID`
`events_waits_history`.`EVENT_NAME`
`events_waits_history`.`SOURCE`
`events_waits_history`.`TIMER_START`
`events_waits_history`.`TIMER_END`
`events_waits_history`.`TIMER_WAIT`
`events_waits_history`.`SPINS`
`events_waits_history`.`OBJECT_SCHEMA`
`events_waits_history`.`OBJECT_NAME`
`events_waits_history`.`OBJECT_TYPE`
`events_waits_history`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history`.`NESTING_EVENT_ID`
`events_waits_history`.`OPERATION`
`events_waits_history`.`NUMBER_OF_BYTES`
`events_waits_history`.`FLAGS`
`events_waits_history_long`.*
`events_waits_history_long`.`THREAD_ID`
`events_waits_history_long`.`EVENT_ID`
`events_waits_history_long`.`EVENT_NAME`
`events_waits_history_long`.`SOURCE`
`events_waits_history_long`.`TIMER_START`
`events_waits_history_long`.`TIMER_END`
`events_waits_history_long`.`TIMER_WAIT`
`events_waits_history_long`.`SPINS`
`events_waits_history_long`.`OBJECT_SCHEMA`
`events_waits_history_long`.`OBJECT_NAME`
`events_waits_history_long`.`OBJECT_TYPE`
`events_waits_history_long`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history_long`.`NESTING_EVENT_ID`
`events_waits_history_long`.`OPERATION`
`events_waits_history_long`.`NUMBER_OF_BYTES`
`events_waits_history_long`.`FLAGS`
`events_waits_summary_by_instance`.*
`events_waits_summary_by_instance`.`EVENT_NAME`
`events_waits_summary_by_instance`.`OBJECT_INSTANCE_BEGIN`
`events_waits_summary_by_instance`.`COUNT_STAR`
`events_waits_summary_by_instance`.`SUM_TIMER_WAIT`
`events_waits_summary_by_instance`.`MIN_TIMER_WAIT`
`events_waits_summary_by_instance`.`AVG_TIMER_WAIT`
`events_waits_summary_by_instance`.`MAX_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.*
`events_waits_summary_by_thread_by_event_name`.`THREAD_ID`
`events_waits_summary_by_thread_by_event_name`.`EVENT_NAME`
`events_waits_summary_by_thread_by_event_name`.`COUNT_STAR`
`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MAX_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.*
`events_waits_summary_global_by_event_name`.`EVENT_NAME`
`events_waits_summary_global_by_event_name`.`COUNT_STAR`
`events_waits_summary_global_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MAX_TIMER_WAIT`
`file_instances`.*
`file_instances`.`FILE_NAME`
`file_instances`.`EVENT_NAME`
`file_instances`.`OPEN_COUNT`
`file_summary_by_event_name`.*
`file_summary_by_event_name`.`EVENT_NAME`
`file_summary_by_event_name`.`COUNT_READ`
`file_summary_by_event_name`.`COUNT_WRITE`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_WRITE`
`file_summary_by_instance`.*
`file_summary_by_instance`.`FILE_NAME`
`file_summary_by_instance`.`EVENT_NAME`
`file_summary_by_instance`.`COUNT_READ`
`file_summary_by_instance`.`COUNT_WRITE`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_WRITE`
`mutex_instances`.*
`mutex_instances`.`NAME`
`mutex_instances`.`OBJECT_INSTANCE_BEGIN`
`mutex_instances`.`LOCKED_BY_THREAD_ID`
`performance_timers`.*
`performance_timers`.`TIMER_NAME`
`performance_timers`.`TIMER_FREQUENCY`
`performance_timers`.`TIMER_RESOLUTION`
`performance_timers`.`TIMER_OVERHEAD`
`rwlock_instances`.*
`rwlock_instances`.`NAME`
`rwlock_instances`.`OBJECT_INSTANCE_BEGIN`
`rwlock_instances`.`WRITE_LOCKED_BY_THREAD_ID`
`rwlock_instances`.`READ_LOCKED_BY_COUNT`
`setup_consumers`.*
`setup_consumers`.`NAME`
`setup_consumers`.`ENABLED`
`setup_instruments`.*
`setup_instruments`.`NAME`
`setup_instruments`.`ENABLED`
`setup_instruments`.`TIMED`
`setup_timers`.*
`setup_timers`.`NAME`
`setup_timers`.`TIMER_NAME`
`threads`.*
`threads`.`THREAD_ID`
`threads`.`PROCESSLIST_ID`
`threads`.`NAME`
`cond_instances`.*
`cond_instances`.`NAME`
`cond_instances`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.*
`events_waits_current`.`THREAD_ID`
`events_waits_current`.`EVENT_ID`
`events_waits_current`.`EVENT_NAME`
`events_waits_current`.`SOURCE`
`events_waits_current`.`TIMER_START`
`events_waits_current`.`TIMER_END`
`events_waits_current`.`TIMER_WAIT`
`events_waits_current`.`SPINS`
`events_waits_current`.`OBJECT_SCHEMA`
`events_waits_current`.`OBJECT_NAME`
`events_waits_current`.`OBJECT_TYPE`
`events_waits_current`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.`NESTING_EVENT_ID`
`events_waits_current`.`OPERATION`
`events_waits_current`.`NUMBER_OF_BYTES`
`events_waits_current`.`FLAGS`
`events_waits_history`.*
`events_waits_history`.`THREAD_ID`
`events_waits_history`.`EVENT_ID`
`events_waits_history`.`EVENT_NAME`
`events_waits_history`.`SOURCE`
`events_waits_history`.`TIMER_START`
`events_waits_history`.`TIMER_END`
`events_waits_history`.`TIMER_WAIT`
`events_waits_history`.`SPINS`
`events_waits_history`.`OBJECT_SCHEMA`
`events_waits_history`.`OBJECT_NAME`
`events_waits_history`.`OBJECT_TYPE`
`events_waits_history`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history`.`NESTING_EVENT_ID`
`events_waits_history`.`OPERATION`
`events_waits_history`.`NUMBER_OF_BYTES`
`events_waits_history`.`FLAGS`
`events_waits_history_long`.*
`events_waits_history_long`.`THREAD_ID`
`events_waits_history_long`.`EVENT_ID`
`events_waits_history_long`.`EVENT_NAME`
`events_waits_history_long`.`SOURCE`
`events_waits_history_long`.`TIMER_START`
`events_waits_history_long`.`TIMER_END`
`events_waits_history_long`.`TIMER_WAIT`
`events_waits_history_long`.`SPINS`
`events_waits_history_long`.`OBJECT_SCHEMA`
`events_waits_history_long`.`OBJECT_NAME`
`events_waits_history_long`.`OBJECT_TYPE`
`events_waits_history_long`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history_long`.`NESTING_EVENT_ID`
`events_waits_history_long`.`OPERATION`
`events_waits_history_long`.`NUMBER_OF_BYTES`
`events_waits_history_long`.`FLAGS`
`events_waits_summary_by_instance`.*
`events_waits_summary_by_instance`.`EVENT_NAME`
`events_waits_summary_by_instance`.`OBJECT_INSTANCE_BEGIN`
`events_waits_summary_by_instance`.`COUNT_STAR`
`events_waits_summary_by_instance`.`SUM_TIMER_WAIT`
`events_waits_summary_by_instance`.`MIN_TIMER_WAIT`
`events_waits_summary_by_instance`.`AVG_TIMER_WAIT`
`events_waits_summary_by_instance`.`MAX_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.*
`events_waits_summary_by_thread_by_event_name`.`THREAD_ID`
`events_waits_summary_by_thread_by_event_name`.`EVENT_NAME`
`events_waits_summary_by_thread_by_event_name`.`COUNT_STAR`
`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MAX_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.*
`events_waits_summary_global_by_event_name`.`EVENT_NAME`
`events_waits_summary_global_by_event_name`.`COUNT_STAR`
`events_waits_summary_global_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MAX_TIMER_WAIT`
`file_instances`.*
`file_instances`.`FILE_NAME`
`file_instances`.`EVENT_NAME`
`file_instances`.`OPEN_COUNT`
`file_summary_by_event_name`.*
`file_summary_by_event_name`.`EVENT_NAME`
`file_summary_by_event_name`.`COUNT_READ`
`file_summary_by_event_name`.`COUNT_WRITE`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_WRITE`
`file_summary_by_instance`.*
`file_summary_by_instance`.`FILE_NAME`
`file_summary_by_instance`.`EVENT_NAME`
`file_summary_by_instance`.`COUNT_READ`
`file_summary_by_instance`.`COUNT_WRITE`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_WRITE`
`mutex_instances`.*
`mutex_instances`.`NAME`
`mutex_instances`.`OBJECT_INSTANCE_BEGIN`
`mutex_instances`.`LOCKED_BY_THREAD_ID`
`performance_timers`.*
`performance_timers`.`TIMER_NAME`
`performance_timers`.`TIMER_FREQUENCY`
`performance_timers`.`TIMER_RESOLUTION`
`performance_timers`.`TIMER_OVERHEAD`
`rwlock_instances`.*
`rwlock_instances`.`NAME`
`rwlock_instances`.`OBJECT_INSTANCE_BEGIN`
`rwlock_instances`.`WRITE_LOCKED_BY_THREAD_ID`
`rwlock_instances`.`READ_LOCKED_BY_COUNT`
`setup_consumers`.*
`setup_consumers`.`NAME`
`setup_consumers`.`ENABLED`
`setup_instruments`.*
`setup_instruments`.`NAME`
`setup_instruments`.`ENABLED`
`setup_instruments`.`TIMED`
`setup_timers`.*
`setup_timers`.`NAME`
`setup_timers`.`TIMER_NAME`
`threads`.*
`threads`.`THREAD_ID`
`threads`.`PROCESSLIST_ID`
`threads`.`NAME`
`cond_instances`.*
`cond_instances`.`NAME`
`cond_instances`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.*
`events_waits_current`.`THREAD_ID`
`events_waits_current`.`EVENT_ID`
`events_waits_current`.`EVENT_NAME`
`events_waits_current`.`SOURCE`
`events_waits_current`.`TIMER_START`
`events_waits_current`.`TIMER_END`
`events_waits_current`.`TIMER_WAIT`
`events_waits_current`.`SPINS`
`events_waits_current`.`OBJECT_SCHEMA`
`events_waits_current`.`OBJECT_NAME`
`events_waits_current`.`OBJECT_TYPE`
`events_waits_current`.`OBJECT_INSTANCE_BEGIN`
`events_waits_current`.`NESTING_EVENT_ID`
`events_waits_current`.`OPERATION`
`events_waits_current`.`NUMBER_OF_BYTES`
`events_waits_current`.`FLAGS`
`events_waits_history`.*
`events_waits_history`.`THREAD_ID`
`events_waits_history`.`EVENT_ID`
`events_waits_history`.`EVENT_NAME`
`events_waits_history`.`SOURCE`
`events_waits_history`.`TIMER_START`
`events_waits_history`.`TIMER_END`
`events_waits_history`.`TIMER_WAIT`
`events_waits_history`.`SPINS`
`events_waits_history`.`OBJECT_SCHEMA`
`events_waits_history`.`OBJECT_NAME`
`events_waits_history`.`OBJECT_TYPE`
`events_waits_history`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history`.`NESTING_EVENT_ID`
`events_waits_history`.`OPERATION`
`events_waits_history`.`NUMBER_OF_BYTES`
`events_waits_history`.`FLAGS`
`events_waits_history_long`.*
`events_waits_history_long`.`THREAD_ID`
`events_waits_history_long`.`EVENT_ID`
`events_waits_history_long`.`EVENT_NAME`
`events_waits_history_long`.`SOURCE`
`events_waits_history_long`.`TIMER_START`
`events_waits_history_long`.`TIMER_END`
`events_waits_history_long`.`TIMER_WAIT`
`events_waits_history_long`.`SPINS`
`events_waits_history_long`.`OBJECT_SCHEMA`
`events_waits_history_long`.`OBJECT_NAME`
`events_waits_history_long`.`OBJECT_TYPE`
`events_waits_history_long`.`OBJECT_INSTANCE_BEGIN`
`events_waits_history_long`.`NESTING_EVENT_ID`
`events_waits_history_long`.`OPERATION`
`events_waits_history_long`.`NUMBER_OF_BYTES`
`events_waits_history_long`.`FLAGS`
`events_waits_summary_by_instance`.*
`events_waits_summary_by_instance`.`EVENT_NAME`
`events_waits_summary_by_instance`.`OBJECT_INSTANCE_BEGIN`
`events_waits_summary_by_instance`.`COUNT_STAR`
`events_waits_summary_by_instance`.`SUM_TIMER_WAIT`
`events_waits_summary_by_instance`.`MIN_TIMER_WAIT`
`events_waits_summary_by_instance`.`AVG_TIMER_WAIT`
`events_waits_summary_by_instance`.`MAX_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.*
`events_waits_summary_by_thread_by_event_name`.`THREAD_ID`
`events_waits_summary_by_thread_by_event_name`.`EVENT_NAME`
`events_waits_summary_by_thread_by_event_name`.`COUNT_STAR`
`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_by_thread_by_event_name`.`MAX_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.*
`events_waits_summary_global_by_event_name`.`EVENT_NAME`
`events_waits_summary_global_by_event_name`.`COUNT_STAR`
`events_waits_summary_global_by_event_name`.`SUM_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MIN_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`AVG_TIMER_WAIT`
`events_waits_summary_global_by_event_name`.`MAX_TIMER_WAIT`
`file_instances`.*
`file_instances`.`FILE_NAME`
`file_instances`.`EVENT_NAME`
`file_instances`.`OPEN_COUNT`
`file_summary_by_event_name`.*
`file_summary_by_event_name`.`EVENT_NAME`
`file_summary_by_event_name`.`COUNT_READ`
`file_summary_by_event_name`.`COUNT_WRITE`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_event_name`.`SUM_NUMBER_OF_BYTES_WRITE`
`file_summary_by_instance`.*
`file_summary_by_instance`.`FILE_NAME`
`file_summary_by_instance`.`EVENT_NAME`
`file_summary_by_instance`.`COUNT_READ`
`file_summary_by_instance`.`COUNT_WRITE`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_READ`
`file_summary_by_instance`.`SUM_NUMBER_OF_BYTES_WRITE`
`mutex_instances`.*
`mutex_instances`.`NAME`
`mutex_instances`.`OBJECT_INSTANCE_BEGIN`
`mutex_instances`.`LOCKED_BY_THREAD_ID`
`performance_timers`.*
`performance_timers`.`TIMER_NAME`
`performance_timers`.`TIMER_FREQUENCY`
`performance_timers`.`TIMER_RESOLUTION`
`performance_timers`.`TIMER_OVERHEAD`
`rwlock_instances`.*
`rwlock_instances`.`NAME`
`rwlock_instances`.`OBJECT_INSTANCE_BEGIN`
`rwlock_instances`.`WRITE_LOCKED_BY_THREAD_ID`
`rwlock_instances`.`READ_LOCKED_BY_COUNT`
`setup_consumers`.*
`setup_consumers`.`NAME`
`setup_consumers`.`ENABLED`
`setup_instruments`.*
`setup_instruments`.`NAME`
`setup_instruments`.`ENABLED`
`setup_instruments`.`TIMED`
`setup_timers`.*
`setup_timers`.`NAME`
`setup_timers`.`TIMER_NAME`
`threads`.*
`threads`.`THREAD_ID`
`threads`.`PROCESSLIST_ID`
`threads`.`NAME`
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Show:
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use Tables
cond_instances
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
mutex_instances
performance_timers
rwlock_instances
setup_consumers
setup_instruments
setup_timers
threads
SQL query on database
performance_schema
:
