Текущ сървър:
(Сървъри) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Скорошни
Няма наскоро отваряни таблици.
Любими
Няма любими таблици.
X
New
information_schema
mybb
mysql
performance_schema
Portfolio_Marcus
PRUEBA
pw
sakila
serveruwebcoBressolia
shoe_db
sklepSerohenko
sku
StdMdDB
Stefano
students
students 2020
superpos
sys
table
Table_insertion
tb
test19
teste_teste
TlapaleriaMalfoy
Trickysolo
vedettfak
victory 2020
wisedb
world
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа
Панел за навигация
Дърво за навигация
Сървъри
БД
Таблици
Панел за навигация
Персонализиране изгледа на навигационния панел.
Панел за навигация
Представяне на навигацията в БД като дърво
В навигационния панел замества дървото на базата данни със селектор
Свързване с главния панел
Свързване с главния панел чрез оцветяване наа текущата база данни или таблица.
Показване лого
Лого в панела за навигация.
Връзка на логото
URL адрес, към който ще сочи логото в навигационния панел.
Цел за връзката на логото
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Включване синтактичното оцветяване
Оцветяване на сървъра под курсора на мишката.
Максимален брой елементи на първо ниво
Броят на елементите, които могат да бъдат показани на всяка страница на първото ниво на навигационното дърво.
Минимален брой елементи за показване на филтър
Определя минималния брой елементи (таблици, изгледи, подпрограми или събития) за показване на филтър.
Последно отваряни таблици
Максимален брой скоро отваряни таблици; 0 за изключване.
Любими таблици
Maximum number of favorite tables; set 0 to disable.
Ширина на навигационния панел
Задайте на 0, за да свиете навигационния панел.
Дърво за навигация
Персонализиране дървото за навигация.
Дърво за навигация
Максимален брой елементи в клон
Броят на елементите, които могат да бъдат показани на всяка страница на дървото за навигация.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Разрешаване разширяването дървото за навигация
Whether to offer the possibility of tree expansion in the navigation panel.
Показване на таблиците в дървото
Да се показват ли таблици под базата данни в навигационното дърво
Show views in 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
Да се показват ли събития под базата данни в навигационното дърво
Expand single database
Whether to expand single database in the navigation tree automatically.
Сървъри
Настройки за показване на списъка със сървъри.
Сървъри
Показване избора на сървъра
Избор на сървъра в горната част на навигационния панел.
Показване на сървърите в списък
Показване сървърите като списък вместо падащо меню.
БД
Опции за показване на БД.
БД
Minimum number of databases to display the database filter box
Разделител на дървото на БД
Ред, който разделя БД на различните нива на дървото.
Таблици
Настройки за показването на таблиците.
Таблици
Цел на пиктограмата за бърз достъп
Структура
SQL
Търсене
Вмъкване
Прелистване
Цел на втората икона за бърз достъп
Структура
SQL
Търсене
Вмъкване
Прелистване
Разделител на дървото на таблици
Ред, разделящ таблици в отделни нива на дървото.
Максимална дълбочина на дървото на таблиците
Пуснете файловете тук
SQL upload (
0
)
x
-
Показване на скритото навигационно дърво.
Създаване на изглед
Браузърът ви има настройки на phpMyAdmin за този домейн. Искате ли да бъдат използвани за текущата сесия?
Да
/
Не
/
Delete settings
Оттук нататък е необходим javascript!
Сървър: phpMyAdmin demo - MySQL
База данни: sys
Структура
SQL
Търсене
Заявка по пример
(current)
Експорт
root@192.168.30.%
phpMyAdmin документация
MySQL documentation
Настройки
Изход от системата
Конзола
Изчистване
SQL изтория
Настройки
Натисни Ctrl+Enter за изпълнение на заявката
Натиснете Enter, за да изпълни заявката
възходящо
низходящо
Поръчка:
Трасиране SQL
Броене
Изпълнение на поръчката
Time taken
Подредени по:
Група заявки
Разгрупиране на заявки
Колапс
Разширяване
Покажи следа
Скрий следа
Бройка:
Използвано време:
Настройки
Restore default values
Винаги разширите заявки съобщения
Покажи историята на заявката в началото
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Превключи на тъмна палитра
Колапс
Разширяване
Подзаявка
Редакция
Обяснение
Профилиране
Заявката е не успешна
DB:
Време за изпълнение на заявката:
Зареждане
ENUM/SET редактор
Създаване на изглед
Прозорец за заявки
*
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
Показване
критерии
Сортиране
Възходящо
Низходящо
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
Текст
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
Показване
критерии
Сортиране
Възходящо
Низходящо
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
Текст
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
Показване
критерии
Сортиране
Възходящо
Низходящо
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
Текст
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
Показване
критерии
Сортиране
Възходящо
Низходящо
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
Текст
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 Демонстрационен сървър:
В момента се работи с Git ревизия
RELEASE_5_2_1-4907-g5b04607256
от
master
бранш.