Current server:
(Servers) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Recent
There are no recent tables.
Favorites
There are no favorite tables.
X
New
axel
azka word
c_management
DB_VINICULA
ESMOKI
foldrajz
Hospital
information_schema
library_management
mysql
performance_schema
Portfolio_Marcus
PRUEBA
pw
resort
resort
resort_db
resort.sql
sakila
serveruwebcoBressolia
shoe_db
sklepSerohenko
sku
StdMdDB
Stefano
students
students 2020
superpos
sys
tabla
table
Table_insertion
tarea
tb
test19
teste_teste
TlapaleriaMalfoy
tp1
travel_ticket_register
Trickysolo
vedettfak
victory 2020
VINICULA_DB
wisedb
wordpress
world
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: phpMyAdmin demo - MySQL
Database: sys
Structure
SQL
Search
Query
(current)
Export
root@192.168.30.%
phpMyAdmin documentation
MySQL documentation
Settings
Log out
Console
Clear
History
Options
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count:
Time taken:
Options
Restore default values
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:
Loading
ENUM/SET editor
Create view
Query window
*
current_connections
current_memory
file_io_latency
file_ios
host
statement_avg_latency
statement_latency
statements
table_scans
total_connections
total_memory_allocated
unique_users
*
host
io_latency
ios
*
event_name
host
max_latency
total
total_latency
*
avg_latency
event_name
host
total
total_latency
*
full_scans
host
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
total
total_latency
*
full_scans
host
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
statement
total
total_latency
*
allocated
data
object_schema
pages
pages_hashed
pages_old
rows_cached
*
allocated
data
object_name
object_schema
pages
pages_hashed
pages_old
rows_cached
*
blocking_lock_id
blocking_lock_mode
blocking_pid
blocking_query
blocking_trx_age
blocking_trx_id
blocking_trx_rows_locked
blocking_trx_rows_modified
blocking_trx_started
locked_index
locked_table
locked_table_name
locked_table_partition
locked_table_schema
locked_table_subpartition
locked_type
sql_kill_blocking_connection
sql_kill_blocking_query
wait_age
wait_age_secs
wait_started
waiting_lock_id
waiting_lock_mode
waiting_pid
waiting_query
waiting_trx_age
waiting_trx_id
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_trx_started
*
avg_latency
max_latency
min_latency
processlist_id
thread_id
total
total_latency
user
*
avg_read
avg_write
count_read
count_write
file
total
total_read
total_written
write_pct
*
count_misc
count_read
count_write
file
misc_latency
read_latency
total
total_latency
write_latency
*
avg_latency
avg_read
avg_written
count_read
count_write
event_name
max_latency
min_latency
total
total_latency
total_read
total_requested
total_written
*
avg_latency
avg_read
avg_written
count_read
count_write
event_name
max_latency
misc_latency
read_latency
total
total_latency
total_read
total_written
write_latency
*
file
latency
operation
requested
thread
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
host
total_allocated
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
thread_id
total_allocated
user
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
total_allocated
user
*
current_alloc
current_avg_alloc
current_count
event_name
high_alloc
high_avg_alloc
high_count
*
total_allocated
*
Enabled
Type
Variable_name
Variable_value
*
command
conn_id
current_memory
current_statement
db
full_scan
last_statement
last_statement_latency
last_wait
last_wait_latency
lock_latency
pid
program_name
progress
rows_affected
rows_examined
rows_sent
source
state
statement_latency
thd_id
time
tmp_disk_tables
tmp_tables
trx_autocommit
trx_latency
trx_state
user
*
variable_name
variable_value
*
auto_increment
auto_increment_ratio
column_name
column_type
data_type
is_signed
is_unsigned
max_value
table_name
table_schema
*
delete_latency
index_name
insert_latency
rows_deleted
rows_inserted
rows_selected
rows_updated
select_latency
table_name
table_schema
update_latency
*
count
db
object_type
*
dominant_index_columns
dominant_index_name
dominant_index_non_unique
redundant_index_columns
redundant_index_name
redundant_index_non_unique
sql_drop_index
subpart_exists
table_name
table_schema
*
blocking_account
blocking_lock_duration
blocking_lock_type
blocking_pid
blocking_thread_id
object_name
object_schema
sql_kill_blocking_connection
sql_kill_blocking_query
waiting_account
waiting_lock_duration
waiting_lock_type
waiting_pid
waiting_query
waiting_query_rows_affected
waiting_query_rows_examined
waiting_query_secs
waiting_thread_id
*
delete_latency
fetch_latency
insert_latency
io_misc_latency
io_misc_requests
io_read
io_read_latency
io_read_requests
io_write
io_write_latency
io_write_requests
rows_deleted
rows_fetched
rows_inserted
rows_updated
table_name
table_schema
total_latency
update_latency
*
delete_latency
fetch_latency
innodb_buffer_allocated
innodb_buffer_data
innodb_buffer_free
innodb_buffer_pages
innodb_buffer_pages_hashed
innodb_buffer_pages_old
innodb_buffer_rows_cached
insert_latency
io_misc_latency
io_misc_requests
io_read
io_read_latency
io_read_requests
io_write
io_write_latency
io_write_requests
rows_deleted
rows_fetched
rows_inserted
rows_updated
table_name
table_schema
update_latency
*
latency
object_name
object_schema
rows_full_scanned
*
index_name
object_name
object_schema
*
command
conn_id
current_memory
current_statement
db
full_scan
last_statement
last_statement_latency
last_wait
last_wait_latency
lock_latency
pid
program_name
progress
rows_affected
rows_examined
rows_sent
source
state
statement_latency
thd_id
time
tmp_disk_tables
tmp_tables
trx_autocommit
trx_latency
trx_state
user
*
ssl_cipher
ssl_sessions_reused
ssl_version
thread_id
*
avg_latency
db
digest
err_count
exec_count
first_seen
full_scan
last_seen
lock_latency
max_latency
query
rows_affected
rows_affected_avg
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
rows_sorted
sort_merge_passes
tmp_disk_tables
tmp_tables
total_latency
warn_count
*
db
digest
error_pct
errors
exec_count
first_seen
last_seen
query
warning_pct
warnings
*
db
digest
exec_count
first_seen
last_seen
no_good_index_used_count
no_index_used_count
no_index_used_pct
query
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
total_latency
*
avg_latency
db
digest
err_count
exec_count
first_seen
full_scan
last_seen
max_latency
query
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
total_latency
warn_count
*
avg_rows_sorted
avg_sort_merges
db
digest
exec_count
first_seen
last_seen
query
rows_sorted
sort_merge_passes
sort_using_range
sorts_using_scans
total_latency
*
avg_tmp_tables_per_query
db
digest
disk_tmp_tables
exec_count
first_seen
last_seen
memory_tmp_tables
query
tmp_tables_to_disk_pct
total_latency
*
set_by
set_time
value
variable
*
current_connections
current_memory
file_io_latency
file_ios
statement_avg_latency
statement_latency
statements
table_scans
total_connections
total_memory_allocated
unique_hosts
user
*
io_latency
ios
user
*
event_name
latency
max_latency
total
user
*
avg_latency
event_name
total
total_latency
user
*
full_scans
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
total
total_latency
user
*
full_scans
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
statement
total
total_latency
user
*
mysql_version
sys_version
*
avg_latency
event_class
max_latency
min_latency
total
total_latency
*
avg_latency
event_class
max_latency
min_latency
total
total_latency
*
avg_latency
event
host
max_latency
total
total_latency
*
avg_latency
event
max_latency
total
total_latency
user
*
avg_latency
events
max_latency
total
total_latency
*
current_connections
current_memory
file_io_latency
file_ios
host
statement_avg_latency
statement_latency
statements
table_scans
total_connections
total_memory_allocated
unique_users
*
host
io_latency
ios
*
event_name
host
max_latency
total
total_latency
*
avg_latency
event_name
host
total
total_latency
*
full_scans
host
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
total
total_latency
*
full_scans
host
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
statement
total
total_latency
*
allocated
data
object_schema
pages
pages_hashed
pages_old
rows_cached
*
allocated
data
object_name
object_schema
pages
pages_hashed
pages_old
rows_cached
*
blocking_lock_id
blocking_lock_mode
blocking_pid
blocking_query
blocking_trx_age
blocking_trx_id
blocking_trx_rows_locked
blocking_trx_rows_modified
blocking_trx_started
locked_index
locked_table
locked_table_name
locked_table_partition
locked_table_schema
locked_table_subpartition
locked_type
sql_kill_blocking_connection
sql_kill_blocking_query
wait_age
wait_age_secs
wait_started
waiting_lock_id
waiting_lock_mode
waiting_pid
waiting_query
waiting_trx_age
waiting_trx_id
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_trx_started
*
avg_latency
max_latency
min_latency
processlist_id
thread_id
total
total_latency
user
*
avg_read
avg_write
count_read
count_write
file
total
total_read
total_written
write_pct
*
count_misc
count_read
count_write
file
misc_latency
read_latency
total
total_latency
write_latency
*
avg_latency
avg_read
avg_written
count_read
count_write
event_name
max_latency
min_latency
total
total_latency
total_read
total_requested
total_written
*
avg_latency
avg_read
avg_written
count_read
count_write
event_name
max_latency
misc_latency
read_latency
total
total_latency
total_read
total_written
write_latency
*
file
latency
operation
requested
thread
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
host
total_allocated
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
thread_id
total_allocated
user
*
current_allocated
current_avg_alloc
current_count_used
current_max_alloc
total_allocated
user
*
current_alloc
current_avg_alloc
current_count
event_name
high_alloc
high_avg_alloc
high_count
*
total_allocated
*
command
conn_id
current_memory
current_statement
db
full_scan
last_statement
last_statement_latency
last_wait
last_wait_latency
lock_latency
pid
program_name
progress
rows_affected
rows_examined
rows_sent
source
state
statement_latency
thd_id
time
tmp_disk_tables
tmp_tables
trx_autocommit
trx_latency
trx_state
user
*
avg_us
percentile
*
avg_us
cnt
*
count_misc
count_read
count_write
sum_number_of_bytes_read
sum_number_of_bytes_write
sum_timer_misc
sum_timer_read
sum_timer_write
table_name
table_schema
*
index_columns
index_name
non_unique
subpart_exists
table_name
table_schema
*
delete_latency
index_name
insert_latency
rows_deleted
rows_inserted
rows_selected
rows_updated
select_latency
table_name
table_schema
update_latency
*
blocking_account
blocking_lock_duration
blocking_lock_type
blocking_pid
blocking_thread_id
object_name
object_schema
sql_kill_blocking_connection
sql_kill_blocking_query
waiting_account
waiting_lock_duration
waiting_lock_type
waiting_pid
waiting_query
waiting_query_rows_affected
waiting_query_rows_examined
waiting_query_secs
waiting_thread_id
*
delete_latency
fetch_latency
insert_latency
io_misc_latency
io_misc_requests
io_read
io_read_latency
io_read_requests
io_write
io_write_latency
io_write_requests
rows_deleted
rows_fetched
rows_inserted
rows_updated
table_name
table_schema
total_latency
update_latency
*
delete_latency
fetch_latency
innodb_buffer_allocated
innodb_buffer_data
innodb_buffer_free
innodb_buffer_pages
innodb_buffer_pages_hashed
innodb_buffer_pages_old
innodb_buffer_rows_cached
insert_latency
io_misc_latency
io_misc_requests
io_read
io_read_latency
io_read_requests
io_write
io_write_latency
io_write_requests
rows_deleted
rows_fetched
rows_inserted
rows_updated
table_name
table_schema
update_latency
*
latency
object_name
object_schema
rows_full_scanned
*
command
conn_id
current_memory
current_statement
db
full_scan
last_statement
last_statement_latency
last_wait
last_wait_latency
lock_latency
pid
program_name
progress
rows_affected
rows_examined
rows_sent
source
state
statement_latency
thd_id
time
tmp_disk_tables
tmp_tables
trx_autocommit
trx_latency
trx_state
user
*
avg_latency
db
digest
err_count
exec_count
first_seen
full_scan
last_seen
lock_latency
max_latency
query
rows_affected
rows_affected_avg
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
rows_sorted
sort_merge_passes
tmp_disk_tables
tmp_tables
total_latency
warn_count
*
db
digest
error_pct
errors
exec_count
first_seen
last_seen
query
warning_pct
warnings
*
db
digest
exec_count
first_seen
last_seen
no_good_index_used_count
no_index_used_count
no_index_used_pct
query
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
total_latency
*
avg_latency
db
digest
err_count
exec_count
first_seen
full_scan
last_seen
max_latency
query
rows_examined
rows_examined_avg
rows_sent
rows_sent_avg
total_latency
warn_count
*
avg_rows_sorted
avg_sort_merges
db
digest
exec_count
first_seen
last_seen
query
rows_sorted
sort_merge_passes
sort_using_range
sorts_using_scans
total_latency
*
avg_tmp_tables_per_query
db
digest
disk_tmp_tables
exec_count
first_seen
last_seen
memory_tmp_tables
query
tmp_tables_to_disk_pct
total_latency
*
current_connections
current_memory
file_io_latency
file_ios
statement_avg_latency
statement_latency
statements
table_scans
total_connections
total_memory_allocated
unique_hosts
user
*
io_latency
ios
user
*
event_name
latency
max_latency
total
user
*
avg_latency
event_name
total
total_latency
user
*
full_scans
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
total
total_latency
user
*
full_scans
lock_latency
max_latency
rows_affected
rows_examined
rows_sent
statement
total
total_latency
user
*
avg_latency
event_class
max_latency
min_latency
total
total_latency
*
avg_latency
event_class
max_latency
min_latency
total
total_latency
*
avg_latency
event
host
max_latency
total
total_latency
*
avg_latency
event
max_latency
total
total_latency
user
*
avg_latency
events
max_latency
total
total_latency
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_tables_with_full_table_scans
schema_unused_indexes
session
session_ssl_status
statement_analysis
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$schema_tables_with_full_table_scans
x$session
x$statement_analysis
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
.
select column
phpMyAdmin Demo Server:
Currently running Git revision
RELEASE_5_2_1-4907-g5b04607256
from the
master
branch.