Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

sys

host_summary

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
statements	decimal(64,0)	Yes	NULL
statement_latency	text	Yes	NULL
statement_avg_latency	text	Yes	NULL
table_scans	decimal(65,0)	Yes	NULL
file_ios	decimal(64,0)	Yes	NULL
file_io_latency	text	Yes	NULL
current_connections	decimal(41,0)	Yes	NULL
total_connections	decimal(41,0)	Yes	NULL
unique_users	bigint(21)	No	0
current_memory	text	Yes	NULL
total_memory_allocated	text	Yes	NULL

No index defined!

host_summary_by_file_io

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
ios	decimal(42,0)	Yes	NULL
io_latency	text	Yes	NULL

No index defined!

host_summary_by_file_io_type

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

host_summary_by_stages

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL

No index defined!

host_summary_by_statement_latency

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
lock_latency	text	Yes	NULL
rows_sent	decimal(42,0)	Yes	NULL
rows_examined	decimal(42,0)	Yes	NULL
rows_affected	decimal(42,0)	Yes	NULL
full_scans	decimal(43,0)	Yes	NULL

No index defined!

host_summary_by_statement_type

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
statement	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
lock_latency	text	Yes	NULL
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_affected	bigint(20)	No
full_scans	bigint(21)	No	0

No index defined!

innodb_buffer_stats_by_schema

Table comments: VIEW

Column	Type	Null	Default
object_schema	text	Yes	NULL
allocated	text	Yes	NULL
data	text	Yes	NULL
pages	bigint(21)	No	0
pages_hashed	bigint(21)	No	0
pages_old	bigint(21)	No	0
rows_cached	decimal(44,0)	Yes	NULL

No index defined!

innodb_buffer_stats_by_table

Table comments: VIEW

Column	Type	Null	Default
object_schema	text	Yes	NULL
object_name	text	Yes	NULL
allocated	text	Yes	NULL
data	text	Yes	NULL
pages	bigint(21)	No	0
pages_hashed	bigint(21)	No	0
pages_old	bigint(21)	No	0
rows_cached	decimal(44,0)	Yes	NULL

No index defined!

innodb_lock_waits

Table comments: VIEW

Column	Type	Null	Default
wait_started	datetime	Yes	NULL
wait_age	time	Yes	NULL
wait_age_secs	bigint(21)	Yes	NULL
locked_table	mediumtext	Yes	NULL
locked_table_schema	varchar(64)	Yes	NULL
locked_table_name	varchar(64)	Yes	NULL
locked_table_partition	varchar(64)	Yes	NULL
locked_table_subpartition	varchar(64)	Yes	NULL
locked_index	varchar(64)	Yes	NULL
locked_type	varchar(32)	No
waiting_trx_id	varchar(18)	No
waiting_trx_started	datetime	No	0000-00-00 00:00:00
waiting_trx_age	time	Yes	NULL
waiting_trx_rows_locked	bigint(21)	No	0
waiting_trx_rows_modified	bigint(21)	No	0
waiting_pid	bigint(21)	No	0
waiting_query	longtext	Yes	NULL
waiting_lock_id	varchar(128)	No
waiting_lock_mode	varchar(32)	No
blocking_trx_id	varchar(18)	No
blocking_pid	bigint(21)	No	0
blocking_query	longtext	Yes	NULL
blocking_lock_id	varchar(128)	No
blocking_lock_mode	varchar(32)	No
blocking_trx_started	datetime	No	0000-00-00 00:00:00
blocking_trx_age	time	Yes	NULL
blocking_trx_rows_locked	bigint(21)	No	0
blocking_trx_rows_modified	bigint(21)	No	0
sql_kill_blocking_query	varchar(32)	No
sql_kill_blocking_connection	varchar(26)	No

No index defined!

io_by_thread_by_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(288)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	text	Yes	NULL
min_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL
thread_id	bigint(20)	No
processlist_id	bigint(20)	Yes	NULL

No index defined!

io_global_by_file_by_bytes

Table comments: VIEW

Column	Type	Null	Default
file	varchar(512)	Yes	NULL
count_read	bigint(20)	No
total_read	text	Yes	NULL
avg_read	text	Yes	NULL
count_write	bigint(20)	No
total_written	text	Yes	NULL
avg_write	text	Yes	NULL
total	text	Yes	NULL
write_pct	decimal(26,2)	No	0.00

No index defined!

io_global_by_file_by_latency

Table comments: VIEW

Column	Type	Null	Default
file	varchar(512)	Yes	NULL
total	bigint(20)	No
total_latency	text	Yes	NULL
count_read	bigint(20)	No
read_latency	text	Yes	NULL
count_write	bigint(20)	No
write_latency	text	Yes	NULL
count_misc	bigint(20)	No
misc_latency	text	Yes	NULL

No index defined!

io_global_by_wait_by_bytes

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	text	Yes	NULL
min_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL
count_read	bigint(20)	No
total_read	text	Yes	NULL
avg_read	text	Yes	NULL
count_write	bigint(20)	No
total_written	text	Yes	NULL
avg_written	text	Yes	NULL
total_requested	text	Yes	NULL

No index defined!

io_global_by_wait_by_latency

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL
read_latency	text	Yes	NULL
write_latency	text	Yes	NULL
misc_latency	text	Yes	NULL
count_read	bigint(20)	No
total_read	text	Yes	NULL
avg_read	text	Yes	NULL
count_write	bigint(20)	No
total_written	text	Yes	NULL
avg_written	text	Yes	NULL

No index defined!

latest_file_io

Table comments: VIEW

Column	Type	Null	Default
thread	varchar(316)	Yes	NULL
file	varchar(512)	Yes	NULL
latency	text	Yes	NULL
operation	varchar(32)	No
requested	text	Yes	NULL

No index defined!

memory_by_host_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	text	Yes	NULL
current_avg_alloc	text	Yes	NULL
current_max_alloc	text	Yes	NULL
total_allocated	text	Yes	NULL

No index defined!

memory_by_thread_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
thread_id	bigint(20)	No
user	varchar(288)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	text	Yes	NULL
current_avg_alloc	text	Yes	NULL
current_max_alloc	text	Yes	NULL
total_allocated	text	Yes	NULL

No index defined!

memory_by_user_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	text	Yes	NULL
current_avg_alloc	text	Yes	NULL
current_max_alloc	text	Yes	NULL
total_allocated	text	Yes	NULL

No index defined!

memory_global_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	No
current_count	bigint(20)	No
current_alloc	text	Yes	NULL
current_avg_alloc	text	Yes	NULL
high_count	bigint(20)	No
high_alloc	text	Yes	NULL
high_avg_alloc	text	Yes	NULL

No index defined!

memory_global_total

Table comments: VIEW

Column	Type	Null	Default	Comments
total_allocated	text	Yes	NULL

No index defined!

metrics

Table comments: VIEW

Column	Type	Null	Default
Variable_name	varchar(193)	No
Variable_value	text	Yes	NULL
Type	varchar(210)	No
Enabled	varchar(7)	No

No index defined!

processlist

Table comments: VIEW

Column	Type	Null	Default
thd_id	bigint(20)	No
conn_id	bigint(20)	Yes	NULL
user	varchar(288)	Yes	NULL
db	varchar(64)	Yes	NULL
command	varchar(16)	Yes	NULL
state	varchar(64)	Yes	NULL
time	bigint(20)	Yes	NULL
current_statement	longtext	Yes	NULL
statement_latency	text	Yes	NULL
progress	decimal(26,2)	Yes	NULL
lock_latency	text	Yes	NULL
rows_examined	bigint(20)	Yes	NULL
rows_sent	bigint(20)	Yes	NULL
rows_affected	bigint(20)	Yes	NULL
tmp_tables	bigint(20)	Yes	NULL
tmp_disk_tables	bigint(20)	Yes	NULL
full_scan	varchar(3)	No
last_statement	longtext	Yes	NULL
last_statement_latency	text	Yes	NULL
current_memory	text	Yes	NULL
last_wait	varchar(128)	Yes	NULL
last_wait_latency	text	Yes	NULL
source	varchar(64)	Yes	NULL
trx_latency	text	Yes	NULL
trx_state	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
trx_autocommit	enum('YES', 'NO')	Yes	NULL
pid	varchar(1024)	Yes	NULL
program_name	varchar(1024)	Yes	NULL

No index defined!

ps_check_lost_instrumentation

Table comments: VIEW

Column	Type	Null	Default	Comments
variable_name	varchar(64)	No
variable_value	varchar(1024)	Yes	NULL

No index defined!

schema_auto_increment_columns

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	No
table_name	varchar(64)	No
column_name	varchar(64)	Yes	NULL
data_type	longtext	Yes	NULL
column_type	mediumtext	No
is_signed	int(1)	No	0
is_unsigned	int(1)	No	0
max_value	bigint(21)	Yes	NULL
auto_increment	bigint(21)	Yes	NULL
auto_increment_ratio	decimal(25,4)	Yes	NULL

No index defined!

schema_index_statistics

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
index_name	varchar(64)	Yes	NULL
rows_selected	bigint(20)	No
select_latency	text	Yes	NULL
rows_inserted	bigint(20)	No
insert_latency	text	Yes	NULL
rows_updated	bigint(20)	No
update_latency	text	Yes	NULL
rows_deleted	bigint(20)	No
delete_latency	text	Yes	NULL

No index defined!

schema_object_overview

Table comments: VIEW

Column	Type	Null	Default
db	varchar(64)	No
object_type	varchar(19)	Yes	NULL
count	bigint(21)	No	0

No index defined!

schema_redundant_indexes

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	No
table_name	varchar(64)	No
redundant_index_name	varchar(64)	Yes	NULL
redundant_index_columns	text	Yes	NULL
redundant_index_non_unique	int(1)	Yes	NULL
dominant_index_name	varchar(64)	Yes	NULL
dominant_index_columns	text	Yes	NULL
dominant_index_non_unique	int(1)	Yes	NULL
subpart_exists	int(1)	No	0
sql_drop_index	varchar(223)	Yes	NULL

No index defined!

schema_tables_with_full_table_scans

Table comments: VIEW

Column	Type	Null	Default
object_schema	varchar(64)	Yes	NULL
object_name	varchar(64)	Yes	NULL
rows_full_scanned	bigint(20)	No
latency	text	Yes	NULL

No index defined!

schema_table_lock_waits

Table comments: VIEW

Column	Type	Null	Default
object_schema	varchar(64)	Yes	NULL
object_name	varchar(64)	Yes	NULL
waiting_thread_id	bigint(20)	No
waiting_pid	bigint(20)	Yes	NULL
waiting_account	text	Yes	NULL
waiting_lock_type	varchar(32)	No
waiting_lock_duration	varchar(32)	No
waiting_query	longtext	Yes	NULL
waiting_query_secs	bigint(20)	Yes	NULL
waiting_query_rows_affected	bigint(20)	Yes	NULL
waiting_query_rows_examined	bigint(20)	Yes	NULL
blocking_thread_id	bigint(20)	No
blocking_pid	bigint(20)	Yes	NULL
blocking_account	text	Yes	NULL
blocking_lock_type	varchar(32)	No
blocking_lock_duration	varchar(32)	No
sql_kill_blocking_query	varchar(31)	Yes	NULL
sql_kill_blocking_connection	varchar(25)	Yes	NULL

No index defined!

schema_table_statistics

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
total_latency	text	Yes	NULL
rows_fetched	bigint(20)	No
fetch_latency	text	Yes	NULL
rows_inserted	bigint(20)	No
insert_latency	text	Yes	NULL
rows_updated	bigint(20)	No
update_latency	text	Yes	NULL
rows_deleted	bigint(20)	No
delete_latency	text	Yes	NULL
io_read_requests	decimal(42,0)	Yes	NULL
io_read	text	Yes	NULL
io_read_latency	text	Yes	NULL
io_write_requests	decimal(42,0)	Yes	NULL
io_write	text	Yes	NULL
io_write_latency	text	Yes	NULL
io_misc_requests	decimal(42,0)	Yes	NULL
io_misc_latency	text	Yes	NULL

No index defined!

schema_table_statistics_with_buffer

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
rows_fetched	bigint(20)	No
fetch_latency	text	Yes	NULL
rows_inserted	bigint(20)	No
insert_latency	text	Yes	NULL
rows_updated	bigint(20)	No
update_latency	text	Yes	NULL
rows_deleted	bigint(20)	No
delete_latency	text	Yes	NULL
io_read_requests	decimal(42,0)	Yes	NULL
io_read	text	Yes	NULL
io_read_latency	text	Yes	NULL
io_write_requests	decimal(42,0)	Yes	NULL
io_write	text	Yes	NULL
io_write_latency	text	Yes	NULL
io_misc_requests	decimal(42,0)	Yes	NULL
io_misc_latency	text	Yes	NULL
innodb_buffer_allocated	text	Yes	NULL
innodb_buffer_data	text	Yes	NULL
innodb_buffer_free	text	Yes	NULL
innodb_buffer_pages	bigint(21)	Yes	0
innodb_buffer_pages_hashed	bigint(21)	Yes	0
innodb_buffer_pages_old	bigint(21)	Yes	0
innodb_buffer_rows_cached	decimal(44,0)	Yes	0

No index defined!

schema_unused_indexes

Table comments: VIEW

Column	Type	Null	Default
object_schema	varchar(64)	Yes	NULL
object_name	varchar(64)	Yes	NULL
index_name	varchar(64)	Yes	NULL

No index defined!

session

Table comments: VIEW

Column	Type	Null	Default
thd_id	bigint(20)	No
conn_id	bigint(20)	Yes	NULL
user	varchar(288)	Yes	NULL
db	varchar(64)	Yes	NULL
command	varchar(16)	Yes	NULL
state	varchar(64)	Yes	NULL
time	bigint(20)	Yes	NULL
current_statement	longtext	Yes	NULL
statement_latency	text	Yes	NULL
progress	decimal(26,2)	Yes	NULL
lock_latency	text	Yes	NULL
rows_examined	bigint(20)	Yes	NULL
rows_sent	bigint(20)	Yes	NULL
rows_affected	bigint(20)	Yes	NULL
tmp_tables	bigint(20)	Yes	NULL
tmp_disk_tables	bigint(20)	Yes	NULL
full_scan	varchar(3)	No
last_statement	longtext	Yes	NULL
last_statement_latency	text	Yes	NULL
current_memory	text	Yes	NULL
last_wait	varchar(128)	Yes	NULL
last_wait_latency	text	Yes	NULL
source	varchar(64)	Yes	NULL
trx_latency	text	Yes	NULL
trx_state	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
trx_autocommit	enum('YES', 'NO')	Yes	NULL
pid	varchar(1024)	Yes	NULL
program_name	varchar(1024)	Yes	NULL

No index defined!

session_ssl_status

Table comments: VIEW

Column	Type	Null	Default
thread_id	bigint(20)	No
ssl_version	varchar(1024)	Yes	NULL
ssl_cipher	varchar(1024)	Yes	NULL
ssl_sessions_reused	varchar(1024)	Yes	NULL

No index defined!

statements_with_errors_or_warnings

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
errors	bigint(20)	No
error_pct	decimal(27,4)	No	0.0000
warnings	bigint(20)	No
warning_pct	decimal(27,4)	No	0.0000
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

statements_with_full_table_scans

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	text	Yes	NULL
no_index_used_count	bigint(20)	No
no_good_index_used_count	bigint(20)	No
no_index_used_pct	decimal(24,0)	No	0
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_sent_avg	decimal(21,0)	Yes	NULL
rows_examined_avg	decimal(21,0)	Yes	NULL
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

statements_with_runtimes_in_95th_percentile

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
full_scan	varchar(1)	No
exec_count	bigint(20)	No
err_count	bigint(20)	No
warn_count	bigint(20)	No
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
rows_sent	bigint(20)	No
rows_sent_avg	decimal(21,0)	No	0
rows_examined	bigint(20)	No
rows_examined_avg	decimal(21,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

statements_with_sorting

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	text	Yes	NULL
sort_merge_passes	bigint(20)	No
avg_sort_merges	decimal(21,0)	No	0
sorts_using_scans	bigint(20)	No
sort_using_range	bigint(20)	No
rows_sorted	bigint(20)	No
avg_rows_sorted	decimal(21,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

statements_with_temp_tables

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	text	Yes	NULL
memory_tmp_tables	bigint(20)	No
disk_tmp_tables	bigint(20)	No
avg_tmp_tables_per_query	decimal(21,0)	No	0
tmp_tables_to_disk_pct	decimal(24,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

statement_analysis

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
full_scan	varchar(1)	No
exec_count	bigint(20)	No
err_count	bigint(20)	No
warn_count	bigint(20)	No
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
lock_latency	text	Yes	NULL
rows_sent	bigint(20)	No
rows_sent_avg	decimal(21,0)	No	0
rows_examined	bigint(20)	No
rows_examined_avg	decimal(21,0)	No	0
rows_affected	bigint(20)	No
rows_affected_avg	decimal(21,0)	No	0
tmp_tables	bigint(20)	No
tmp_disk_tables	bigint(20)	No
rows_sorted	bigint(20)	No
sort_merge_passes	bigint(20)	No
digest	varchar(64)	Yes	NULL
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000

No index defined!

sys_config

Column	Type	Null	Default
variable (Primary)	varchar(128)	No
value	varchar(128)	Yes	NULL
set_time	timestamp	Yes	CURRENT_TIMESTAMP
set_by	varchar(128)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	variable	2	A	No

user_summary

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
statements	decimal(64,0)	Yes	NULL
statement_latency	text	Yes	NULL
statement_avg_latency	text	Yes	NULL
table_scans	decimal(65,0)	Yes	NULL
file_ios	decimal(64,0)	Yes	NULL
file_io_latency	text	Yes	NULL
current_connections	decimal(41,0)	Yes	NULL
total_connections	decimal(41,0)	Yes	NULL
unique_hosts	bigint(21)	No	0
current_memory	text	Yes	NULL
total_memory_allocated	text	Yes	NULL

No index defined!

user_summary_by_file_io

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
ios	decimal(42,0)	Yes	NULL
io_latency	text	Yes	NULL

No index defined!

user_summary_by_file_io_type

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

user_summary_by_stages

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL

No index defined!

user_summary_by_statement_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
lock_latency	text	Yes	NULL
rows_sent	decimal(42,0)	Yes	NULL
rows_examined	decimal(42,0)	Yes	NULL
rows_affected	decimal(42,0)	Yes	NULL
full_scans	decimal(43,0)	Yes	NULL

No index defined!

user_summary_by_statement_type

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
statement	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	text	Yes	NULL
max_latency	text	Yes	NULL
lock_latency	text	Yes	NULL
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_affected	bigint(20)	No
full_scans	bigint(21)	No	0

No index defined!

version

Table comments: VIEW

Column	Type	Null	Default	Comments
sys_version	varchar(5)	No
mysql_version	varchar(6)	No

No index defined!

waits_by_host_by_latency

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

waits_by_user_by_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

waits_global_by_latency

Table comments: VIEW

Column	Type	Null	Default
events	varchar(128)	No
total	bigint(20)	No
total_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

wait_classes_global_by_avg_latency

Table comments: VIEW

Column	Type	Null	Default
event_class	varchar(128)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	text	Yes	NULL
min_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

wait_classes_global_by_latency

Table comments: VIEW

Column	Type	Null	Default
event_class	varchar(128)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	text	Yes	NULL
min_latency	text	Yes	NULL
avg_latency	text	Yes	NULL
max_latency	text	Yes	NULL

No index defined!

x$host_summary

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
statements	decimal(64,0)	Yes	NULL
statement_latency	decimal(64,0)	Yes	NULL
statement_avg_latency	decimal(65,4)	Yes	NULL
table_scans	decimal(65,0)	Yes	NULL
file_ios	decimal(64,0)	Yes	NULL
file_io_latency	decimal(64,0)	Yes	NULL
current_connections	decimal(41,0)	Yes	NULL
total_connections	decimal(41,0)	Yes	NULL
unique_users	bigint(21)	No	0
current_memory	decimal(63,0)	Yes	NULL
total_memory_allocated	decimal(64,0)	Yes	NULL

No index defined!

x$host_summary_by_file_io

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
ios	decimal(42,0)	Yes	NULL
io_latency	decimal(42,0)	Yes	NULL

No index defined!

x$host_summary_by_file_io_type

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
max_latency	bigint(20)	No

No index defined!

x$host_summary_by_stages

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No

No index defined!

x$host_summary_by_statement_latency

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	decimal(42,0)	Yes	NULL
max_latency	bigint(20)	Yes	NULL
lock_latency	decimal(42,0)	Yes	NULL
rows_sent	decimal(42,0)	Yes	NULL
rows_examined	decimal(42,0)	Yes	NULL
rows_affected	decimal(42,0)	Yes	NULL
full_scans	decimal(43,0)	Yes	NULL

No index defined!

x$host_summary_by_statement_type

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
statement	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	bigint(20)	No
max_latency	bigint(20)	No
lock_latency	bigint(20)	No
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_affected	bigint(20)	No
full_scans	bigint(21)	No	0

No index defined!

x$innodb_buffer_stats_by_schema

Table comments: VIEW

Column	Type	Null	Default
object_schema	text	Yes	NULL
allocated	decimal(43,0)	Yes	NULL
data	decimal(43,0)	Yes	NULL
pages	bigint(21)	No	0
pages_hashed	bigint(21)	No	0
pages_old	bigint(21)	No	0
rows_cached	decimal(44,0)	No	0

No index defined!

x$innodb_buffer_stats_by_table

Table comments: VIEW

Column	Type	Null	Default
object_schema	text	Yes	NULL
object_name	text	Yes	NULL
allocated	decimal(43,0)	Yes	NULL
data	decimal(43,0)	Yes	NULL
pages	bigint(21)	No	0
pages_hashed	bigint(21)	No	0
pages_old	bigint(21)	No	0
rows_cached	decimal(44,0)	No	0

No index defined!

x$innodb_lock_waits

Table comments: VIEW

Column	Type	Null	Default
wait_started	datetime	Yes	NULL
wait_age	time	Yes	NULL
wait_age_secs	bigint(21)	Yes	NULL
locked_table	mediumtext	Yes	NULL
locked_table_schema	varchar(64)	Yes	NULL
locked_table_name	varchar(64)	Yes	NULL
locked_table_partition	varchar(64)	Yes	NULL
locked_table_subpartition	varchar(64)	Yes	NULL
locked_index	varchar(64)	Yes	NULL
locked_type	varchar(32)	No
waiting_trx_id	varchar(18)	No
waiting_trx_started	datetime	No	0000-00-00 00:00:00
waiting_trx_age	time	Yes	NULL
waiting_trx_rows_locked	bigint(21)	No	0
waiting_trx_rows_modified	bigint(21)	No	0
waiting_pid	bigint(21)	No	0
waiting_query	varchar(1024)	Yes	NULL
waiting_lock_id	varchar(128)	No
waiting_lock_mode	varchar(32)	No
blocking_trx_id	varchar(18)	No
blocking_pid	bigint(21)	No	0
blocking_query	varchar(1024)	Yes	NULL
blocking_lock_id	varchar(128)	No
blocking_lock_mode	varchar(32)	No
blocking_trx_started	datetime	No	0000-00-00 00:00:00
blocking_trx_age	time	Yes	NULL
blocking_trx_rows_locked	bigint(21)	No	0
blocking_trx_rows_modified	bigint(21)	No	0
sql_kill_blocking_query	varchar(32)	No
sql_kill_blocking_connection	varchar(26)	No

No index defined!

x$io_by_thread_by_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(288)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	decimal(42,0)	Yes	NULL
min_latency	bigint(20)	Yes	NULL
avg_latency	decimal(24,4)	Yes	NULL
max_latency	bigint(20)	Yes	NULL
thread_id	bigint(20)	No
processlist_id	bigint(20)	Yes	NULL

No index defined!

x$io_global_by_file_by_bytes

Table comments: VIEW

Column	Type	Null	Default
file	varchar(512)	No
count_read	bigint(20)	No
total_read	bigint(20)	No
avg_read	decimal(23,4)	No	0.0000
count_write	bigint(20)	No
total_written	bigint(20)	No
avg_write	decimal(23,4)	No	0.0000
total	bigint(21)	No	0
write_pct	decimal(26,2)	No	0.00

No index defined!

x$io_global_by_file_by_latency

Table comments: VIEW

Column	Type	Null
file	varchar(512)	No
total	bigint(20)	No
total_latency	bigint(20)	No
count_read	bigint(20)	No
read_latency	bigint(20)	No
count_write	bigint(20)	No
write_latency	bigint(20)	No
count_misc	bigint(20)	No
misc_latency	bigint(20)	No

No index defined!

x$io_global_by_wait_by_bytes

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	bigint(20)	No
min_latency	bigint(20)	No
avg_latency	bigint(20)	No
max_latency	bigint(20)	No
count_read	bigint(20)	No
total_read	bigint(20)	No
avg_read	decimal(23,4)	No	0.0000
count_write	bigint(20)	No
total_written	bigint(20)	No
avg_written	decimal(23,4)	No	0.0000
total_requested	bigint(21)	No	0

No index defined!

x$io_global_by_wait_by_latency

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No
max_latency	bigint(20)	No
read_latency	bigint(20)	No
write_latency	bigint(20)	No
misc_latency	bigint(20)	No
count_read	bigint(20)	No
total_read	bigint(20)	No
avg_read	decimal(23,4)	No	0.0000
count_write	bigint(20)	No
total_written	bigint(20)	No
avg_written	decimal(23,4)	No	0.0000

No index defined!

x$latest_file_io

Table comments: VIEW

Column	Type	Null	Default
thread	varchar(316)	Yes	NULL
file	varchar(512)	Yes	NULL
latency	bigint(20)	Yes	NULL
operation	varchar(32)	No
requested	bigint(20)	Yes	NULL

No index defined!

x$memory_by_host_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	decimal(41,0)	Yes	NULL
current_avg_alloc	decimal(45,4)	No	0.0000
current_max_alloc	bigint(20)	Yes	NULL
total_allocated	decimal(42,0)	Yes	NULL

No index defined!

x$memory_by_thread_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
thread_id	bigint(20)	No
user	varchar(288)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	decimal(41,0)	Yes	NULL
current_avg_alloc	decimal(45,4)	No	0.0000
current_max_alloc	bigint(20)	Yes	NULL
total_allocated	decimal(42,0)	Yes	NULL

No index defined!

x$memory_by_user_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
current_count_used	decimal(41,0)	Yes	NULL
current_allocated	decimal(41,0)	Yes	NULL
current_avg_alloc	decimal(45,4)	No	0.0000
current_max_alloc	bigint(20)	Yes	NULL
total_allocated	decimal(42,0)	Yes	NULL

No index defined!

x$memory_global_by_current_bytes

Table comments: VIEW

Column	Type	Null	Default
event_name	varchar(128)	No
current_count	bigint(20)	No
current_alloc	bigint(20)	No
current_avg_alloc	decimal(23,4)	No	0.0000
high_count	bigint(20)	No
high_alloc	bigint(20)	No
high_avg_alloc	decimal(23,4)	No	0.0000

No index defined!

x$memory_global_total

Table comments: VIEW

Column	Type	Null	Default	Comments
total_allocated	decimal(41,0)	Yes	NULL

No index defined!

x$processlist

Table comments: VIEW

Column	Type	Null	Default
thd_id	bigint(20)	No
conn_id	bigint(20)	Yes	NULL
user	varchar(288)	Yes	NULL
db	varchar(64)	Yes	NULL
command	varchar(16)	Yes	NULL
state	varchar(64)	Yes	NULL
time	bigint(20)	Yes	NULL
current_statement	longtext	Yes	NULL
statement_latency	bigint(20)	Yes	NULL
progress	decimal(26,2)	Yes	NULL
lock_latency	bigint(20)	Yes	NULL
rows_examined	bigint(20)	Yes	NULL
rows_sent	bigint(20)	Yes	NULL
rows_affected	bigint(20)	Yes	NULL
tmp_tables	bigint(20)	Yes	NULL
tmp_disk_tables	bigint(20)	Yes	NULL
full_scan	varchar(3)	No
last_statement	longtext	Yes	NULL
last_statement_latency	bigint(20)	Yes	NULL
current_memory	decimal(41,0)	Yes	NULL
last_wait	varchar(128)	Yes	NULL
last_wait_latency	varchar(20)	Yes	NULL
source	varchar(64)	Yes	NULL
trx_latency	bigint(20)	Yes	NULL
trx_state	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
trx_autocommit	enum('YES', 'NO')	Yes	NULL
pid	varchar(1024)	Yes	NULL
program_name	varchar(1024)	Yes	NULL

No index defined!

x$ps_digest_95th_percentile_by_avg_us

Table comments: VIEW

Column	Type	Null	Default	Comments
avg_us	decimal(21,0)	Yes	NULL
percentile	decimal(46,4)	No	0.0000

No index defined!

x$ps_digest_avg_latency_distribution

Table comments: VIEW

Column	Type	Null	Default	Comments
cnt	bigint(21)	No	0
avg_us	decimal(21,0)	Yes	NULL

No index defined!

x$ps_schema_table_statistics_io

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
count_read	decimal(42,0)	Yes	NULL
sum_number_of_bytes_read	decimal(41,0)	Yes	NULL
sum_timer_read	decimal(42,0)	Yes	NULL
count_write	decimal(42,0)	Yes	NULL
sum_number_of_bytes_write	decimal(41,0)	Yes	NULL
sum_timer_write	decimal(42,0)	Yes	NULL
count_misc	decimal(42,0)	Yes	NULL
sum_timer_misc	decimal(42,0)	Yes	NULL

No index defined!

x$schema_flattened_keys

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	No
table_name	varchar(64)	No
index_name	varchar(64)	Yes	NULL
non_unique	int(1)	Yes	NULL
subpart_exists	bigint(1)	Yes	NULL
index_columns	text	Yes	NULL

No index defined!

x$schema_index_statistics

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
index_name	varchar(64)	Yes	NULL
rows_selected	bigint(20)	No
select_latency	bigint(20)	No
rows_inserted	bigint(20)	No
insert_latency	bigint(20)	No
rows_updated	bigint(20)	No
update_latency	bigint(20)	No
rows_deleted	bigint(20)	No
delete_latency	bigint(20)	No

No index defined!

x$schema_tables_with_full_table_scans

Table comments: VIEW

Column	Type	Null	Default
object_schema	varchar(64)	Yes	NULL
object_name	varchar(64)	Yes	NULL
rows_full_scanned	bigint(20)	No
latency	bigint(20)	No

No index defined!

x$schema_table_lock_waits

Table comments: VIEW

Column	Type	Null	Default
object_schema	varchar(64)	Yes	NULL
object_name	varchar(64)	Yes	NULL
waiting_thread_id	bigint(20)	No
waiting_pid	bigint(20)	Yes	NULL
waiting_account	text	Yes	NULL
waiting_lock_type	varchar(32)	No
waiting_lock_duration	varchar(32)	No
waiting_query	longtext	Yes	NULL
waiting_query_secs	bigint(20)	Yes	NULL
waiting_query_rows_affected	bigint(20)	Yes	NULL
waiting_query_rows_examined	bigint(20)	Yes	NULL
blocking_thread_id	bigint(20)	No
blocking_pid	bigint(20)	Yes	NULL
blocking_account	text	Yes	NULL
blocking_lock_type	varchar(32)	No
blocking_lock_duration	varchar(32)	No
sql_kill_blocking_query	varchar(31)	Yes	NULL
sql_kill_blocking_connection	varchar(25)	Yes	NULL

No index defined!

x$schema_table_statistics

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
total_latency	bigint(20)	No
rows_fetched	bigint(20)	No
fetch_latency	bigint(20)	No
rows_inserted	bigint(20)	No
insert_latency	bigint(20)	No
rows_updated	bigint(20)	No
update_latency	bigint(20)	No
rows_deleted	bigint(20)	No
delete_latency	bigint(20)	No
io_read_requests	decimal(42,0)	Yes	NULL
io_read	decimal(41,0)	Yes	NULL
io_read_latency	decimal(42,0)	Yes	NULL
io_write_requests	decimal(42,0)	Yes	NULL
io_write	decimal(41,0)	Yes	NULL
io_write_latency	decimal(42,0)	Yes	NULL
io_misc_requests	decimal(42,0)	Yes	NULL
io_misc_latency	decimal(42,0)	Yes	NULL

No index defined!

x$schema_table_statistics_with_buffer

Table comments: VIEW

Column	Type	Null	Default
table_schema	varchar(64)	Yes	NULL
table_name	varchar(64)	Yes	NULL
rows_fetched	bigint(20)	No
fetch_latency	bigint(20)	No
rows_inserted	bigint(20)	No
insert_latency	bigint(20)	No
rows_updated	bigint(20)	No
update_latency	bigint(20)	No
rows_deleted	bigint(20)	No
delete_latency	bigint(20)	No
io_read_requests	decimal(42,0)	Yes	NULL
io_read	decimal(41,0)	Yes	NULL
io_read_latency	decimal(42,0)	Yes	NULL
io_write_requests	decimal(42,0)	Yes	NULL
io_write	decimal(41,0)	Yes	NULL
io_write_latency	decimal(42,0)	Yes	NULL
io_misc_requests	decimal(42,0)	Yes	NULL
io_misc_latency	decimal(42,0)	Yes	NULL
innodb_buffer_allocated	decimal(43,0)	Yes	NULL
innodb_buffer_data	decimal(43,0)	Yes	NULL
innodb_buffer_free	decimal(44,0)	Yes	NULL
innodb_buffer_pages	bigint(21)	Yes	0
innodb_buffer_pages_hashed	bigint(21)	Yes	0
innodb_buffer_pages_old	bigint(21)	Yes	0
innodb_buffer_rows_cached	decimal(44,0)	Yes	0

No index defined!

x$session

Table comments: VIEW

Column	Type	Null	Default
thd_id	bigint(20)	No
conn_id	bigint(20)	Yes	NULL
user	varchar(288)	Yes	NULL
db	varchar(64)	Yes	NULL
command	varchar(16)	Yes	NULL
state	varchar(64)	Yes	NULL
time	bigint(20)	Yes	NULL
current_statement	longtext	Yes	NULL
statement_latency	bigint(20)	Yes	NULL
progress	decimal(26,2)	Yes	NULL
lock_latency	bigint(20)	Yes	NULL
rows_examined	bigint(20)	Yes	NULL
rows_sent	bigint(20)	Yes	NULL
rows_affected	bigint(20)	Yes	NULL
tmp_tables	bigint(20)	Yes	NULL
tmp_disk_tables	bigint(20)	Yes	NULL
full_scan	varchar(3)	No
last_statement	longtext	Yes	NULL
last_statement_latency	bigint(20)	Yes	NULL
current_memory	decimal(41,0)	Yes	NULL
last_wait	varchar(128)	Yes	NULL
last_wait_latency	varchar(20)	Yes	NULL
source	varchar(64)	Yes	NULL
trx_latency	bigint(20)	Yes	NULL
trx_state	enum('ACTIVE', 'COMMITTED', 'ROLLED BACK')	Yes	NULL
trx_autocommit	enum('YES', 'NO')	Yes	NULL
pid	varchar(1024)	Yes	NULL
program_name	varchar(1024)	Yes	NULL

No index defined!

x$statements_with_errors_or_warnings

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
errors	bigint(20)	No
error_pct	decimal(27,4)	No	0.0000
warnings	bigint(20)	No
warning_pct	decimal(27,4)	No	0.0000
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

x$statements_with_full_table_scans

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	bigint(20)	No
no_index_used_count	bigint(20)	No
no_good_index_used_count	bigint(20)	No
no_index_used_pct	decimal(24,0)	No	0
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_sent_avg	decimal(21,0)	Yes	NULL
rows_examined_avg	decimal(21,0)	Yes	NULL
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

x$statements_with_runtimes_in_95th_percentile

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
full_scan	varchar(1)	No
exec_count	bigint(20)	No
err_count	bigint(20)	No
warn_count	bigint(20)	No
total_latency	bigint(20)	No
max_latency	bigint(20)	No
avg_latency	bigint(20)	No
rows_sent	bigint(20)	No
rows_sent_avg	decimal(21,0)	No	0
rows_examined	bigint(20)	No
rows_examined_avg	decimal(21,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

x$statements_with_sorting

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	bigint(20)	No
sort_merge_passes	bigint(20)	No
avg_sort_merges	decimal(21,0)	No	0
sorts_using_scans	bigint(20)	No
sort_using_range	bigint(20)	No
rows_sorted	bigint(20)	No
avg_rows_sorted	decimal(21,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

x$statements_with_temp_tables

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
exec_count	bigint(20)	No
total_latency	bigint(20)	No
memory_tmp_tables	bigint(20)	No
disk_tmp_tables	bigint(20)	No
avg_tmp_tables_per_query	decimal(21,0)	No	0
tmp_tables_to_disk_pct	decimal(24,0)	No	0
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
digest	varchar(64)	Yes	NULL

No index defined!

x$statement_analysis

Table comments: VIEW

Column	Type	Null	Default
query	longtext	Yes	NULL
db	varchar(64)	Yes	NULL
full_scan	varchar(1)	No
exec_count	bigint(20)	No
err_count	bigint(20)	No
warn_count	bigint(20)	No
total_latency	bigint(20)	No
max_latency	bigint(20)	No
avg_latency	bigint(20)	No
lock_latency	bigint(20)	No
rows_sent	bigint(20)	No
rows_sent_avg	decimal(21,0)	No	0
rows_examined	bigint(20)	No
rows_examined_avg	decimal(21,0)	No	0
rows_affected	bigint(20)	No
rows_affected_avg	decimal(21,0)	No	0
tmp_tables	bigint(20)	No
tmp_disk_tables	bigint(20)	No
rows_sorted	bigint(20)	No
sort_merge_passes	bigint(20)	No
digest	varchar(64)	Yes	NULL
first_seen	timestamp(6)	No	0000-00-00 00:00:00.000000
last_seen	timestamp(6)	No	0000-00-00 00:00:00.000000

No index defined!

x$user_summary

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
statements	decimal(64,0)	Yes	NULL
statement_latency	decimal(64,0)	Yes	NULL
statement_avg_latency	decimal(65,4)	No	0.0000
table_scans	decimal(65,0)	Yes	NULL
file_ios	decimal(64,0)	Yes	NULL
file_io_latency	decimal(64,0)	Yes	NULL
current_connections	decimal(41,0)	Yes	NULL
total_connections	decimal(41,0)	Yes	NULL
unique_hosts	bigint(21)	No	0
current_memory	decimal(63,0)	Yes	NULL
total_memory_allocated	decimal(64,0)	Yes	NULL

No index defined!

x$user_summary_by_file_io

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
ios	decimal(42,0)	Yes	NULL
io_latency	decimal(42,0)	Yes	NULL

No index defined!

x$user_summary_by_file_io_type

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
latency	bigint(20)	No
max_latency	bigint(20)	No

No index defined!

x$user_summary_by_stages

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event_name	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No

No index defined!

x$user_summary_by_statement_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	decimal(42,0)	Yes	NULL
max_latency	decimal(42,0)	Yes	NULL
lock_latency	decimal(42,0)	Yes	NULL
rows_sent	decimal(42,0)	Yes	NULL
rows_examined	decimal(42,0)	Yes	NULL
rows_affected	decimal(42,0)	Yes	NULL
full_scans	decimal(43,0)	Yes	NULL

No index defined!

x$user_summary_by_statement_type

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
statement	varchar(128)	Yes	NULL
total	bigint(20)	No
total_latency	bigint(20)	No
max_latency	bigint(20)	No
lock_latency	bigint(20)	No
rows_sent	bigint(20)	No
rows_examined	bigint(20)	No
rows_affected	bigint(20)	No
full_scans	bigint(21)	No	0

No index defined!

x$waits_by_host_by_latency

Table comments: VIEW

Column	Type	Null	Default
host	varchar(255)	Yes	NULL
event	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No
max_latency	bigint(20)	No

No index defined!

x$waits_by_user_by_latency

Table comments: VIEW

Column	Type	Null	Default
user	varchar(32)	Yes	NULL
event	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No
max_latency	bigint(20)	No

No index defined!

x$waits_global_by_latency

Table comments: VIEW

Column	Type	Null
events	varchar(128)	No
total	bigint(20)	No
total_latency	bigint(20)	No
avg_latency	bigint(20)	No
max_latency	bigint(20)	No

No index defined!

x$wait_classes_global_by_avg_latency

Table comments: VIEW

Column	Type	Null	Default
event_class	varchar(128)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	decimal(42,0)	Yes	NULL
min_latency	bigint(20)	Yes	NULL
avg_latency	decimal(46,4)	No	0.0000
max_latency	bigint(20)	Yes	NULL

No index defined!

x$wait_classes_global_by_latency

Table comments: VIEW

Column	Type	Null	Default
event_class	varchar(128)	Yes	NULL
total	decimal(42,0)	Yes	NULL
total_latency	decimal(42,0)	Yes	NULL
min_latency	bigint(20)	Yes	NULL
avg_latency	decimal(46,4)	No	0.0000
max_latency	bigint(20)	Yes	NULL

No index defined!

phpMyAdmin Demo Server: Git information missing!