Server saat ini:
(Server) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Terbaru
Tidak ada tabel terbaru.
Favorit
Tidak ada tabel favorit terbaru.
X
Baru
Hospital
information_schema
mysql
performance_schema
petites_annonces
Portfolio_Marcus
PRUEBA
pw
sakila
sb_nac
serveruwebcoBressolia
shoe_db
sklepSerohenko
sku
StdMdDB
Stefano
stud
students
students 2020
superpos
sys
table
Table_insertion
tb
test19
teste_teste
TlapaleriaMalfoy
Trickysolo
vedettfak
victory 2020
wisedb
world
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа
Panel navigasi
Panel navigasi
Server
Basis data
Tabel
Panel navigasi
Atur tampilan panel navigasi.
Panel navigasi
Tampilkan cabang navigasi databases
di panel navigasi, timpa cabang database serta selectornya
Link ke panel utama
Menghubungkan dengan panel utama untuk menyoroti database atau tabel yang saat ini.
Tampilkan logo
Tampilkan logo di panel navigasi.
URL tautan logo
Arahkan URL untuk logo pada panel navigasi.
Sasaran tautan logo
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Aktifkan penyorotan
Sorot server yang dikenai kursor.
Item maksimum di tingkat pertama
Jumlah item yang dapat ditampilkan pada setiap halaman dari cabang navigasi.
Jumlah minimum item yang ditampilkan di kotak tabel filter
Tentukan jumlah minimum item (tabel, view, routines dan event) untuk menampilkan kotak filter.
Tabel yang terakhir digunakan
Jumlah maksimum tabel yang terakhir digunakan; atur 0 untuk menonaktifkannya.
Tabel favorit
Jumlah maksimum tabel favorit; atur 0 untuk menonaktifkannya.
Lebar panel navigasi
Setel ke 0 untuk menutup panel navigasi.
Panel navigasi
Atur panel navigasi.
Panel navigasi
Item maksimal di cabang
Jumlah item yang dapat ditampilkan pada setiap halaman dari pohon navigasi.
Item Group di pohon
Mengelompokkan barang di cabang navigasi (ditentukan oleh pemisah yang didefinisikan di tab Database dan Tabel di atas).
Bolehkan perluasan pohon navigasi
Apakah akan menonaktifkan kemungkinan ekspansi database atau tidak.
Tampilkan tabel pada cabang
Apakah akan menampilkan tabel di bawah database di pohon navigasi
Tampilkan Views dalam bentuk bercabang
Apakah menampilkan views di bawah database di navigation tree
Tampilkan Fungsi dalam bentuk bercabang
Apakah akan menampilkan fungsi di bawah database di navigation tree
Tampilkan prosedur di percabangan
Apakah akan menampilkan prosedur di bawah database di pohon navigasi
Tunjukkan events dalam pohon
Entah untuk menampilkan events di bawah database di navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Server
Opsi tampilan server.
Server
Tampilkan pilihan server
Tampilkan pilihan server di bagian atas panel navigasi.
Tampilkan server dalam bentuk daftar
Tampilkan daftar server dalam bentuk daftar dan bukan tarik-turun.
Basis data
Opsi tampilan basis data.
Basis data
Jumlah minimum database yang ditampilkan di kotak tabel filter
Pemisah hierarki basis data
String yang memisahkan basis data ke dalam tingkat hierarki yang berbeda.
Tabel
Opsi tampilan tabel.
Tabel
Target ikon akses cepat
Struktur
SQL
Cari
Tambahkan
Jelajahi
Target buat ikon akses cepat kedua
Struktur
SQL
Cari
Tambahkan
Jelajahi
Pemisah hierarki tabel
String yang memisahkan tabel ke dalam tingkat hierarki yang berbeda.
Kedalaman hierarki tabel maksimum
Letakkan berkas disini
SQL upload (
0
)
x
-
Tampilkan navigasi pohon item tersembunyi.
Buat tampilan
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Ya
/
Tidak
/
Delete settings
Javascript harus diaktifkan lewat point ini!
Server: phpMyAdmin demo - MySQL
Database: sys
Struktur
SQL
Cari
Kueri
(sekarang)
Ekspor
root@192.168.30.%
Dokumentasi phpMyAdmin
MySQL documentation
Pengaturan
Keluar
Konsol
Bersihkan
Riwayat
Opsi
Tekan Ctrl+Enter untuk menjalankan kueri
Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan
Buka
Show trace
Hide trace
Count:
Waktu yang dipakai:
Opsi
Restore default values
Selalu tampilkan pesan kueri
Tampilkan riwayat kueri di awal
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Beralih ke tema gelap
Tampilkan
Buka
Kueri ulang
Ubah
Jelaskan
Profil
Kueri gagal
Basis data:
Waktu eksekusi kueri:
Memproses
Editor ENUM/SET
Buat tampilan
Jendela Pencarian
*
host
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_users
current_memory
total_memory_allocated
*
host
ios
io_latency
*
host
event_name
total
total_latency
max_latency
*
host
event_name
total
total_latency
avg_latency
*
host
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
host
statement
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
object_schema
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
object_schema
object_name
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
wait_started
wait_age
wait_age_secs
locked_table
locked_table_schema
locked_table_name
locked_table_partition
locked_table_subpartition
locked_index
locked_type
waiting_trx_id
waiting_trx_started
waiting_trx_age
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_pid
waiting_query
waiting_lock_id
waiting_lock_mode
blocking_trx_id
blocking_pid
blocking_query
blocking_lock_id
blocking_lock_mode
blocking_trx_started
blocking_trx_age
blocking_trx_rows_locked
blocking_trx_rows_modified
sql_kill_blocking_query
sql_kill_blocking_connection
*
user
total
total_latency
min_latency
avg_latency
max_latency
thread_id
processlist_id
*
file
count_read
total_read
avg_read
count_write
total_written
avg_write
total
write_pct
*
file
total
total_latency
count_read
read_latency
count_write
write_latency
count_misc
misc_latency
*
event_name
total
total_latency
min_latency
avg_latency
max_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
total_requested
*
event_name
total
total_latency
avg_latency
max_latency
read_latency
write_latency
misc_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
*
thread
file
latency
operation
requested
*
host
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
thread_id
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
event_name
current_count
current_alloc
current_avg_alloc
high_count
high_alloc
high_avg_alloc
*
total_allocated
*
Variable_name
Variable_value
Type
Enabled
*
thd_id
conn_id
user
db
command
state
time
current_statement
statement_latency
progress
lock_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
variable_name
variable_value
*
table_schema
table_name
column_name
data_type
column_type
is_signed
is_unsigned
max_value
auto_increment
auto_increment_ratio
*
table_schema
table_name
index_name
rows_selected
select_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
*
db
object_type
count
*
table_schema
table_name
redundant_index_name
redundant_index_columns
redundant_index_non_unique
dominant_index_name
dominant_index_columns
dominant_index_non_unique
subpart_exists
sql_drop_index
*
object_schema
object_name
waiting_thread_id
waiting_pid
waiting_account
waiting_lock_type
waiting_lock_duration
waiting_query
waiting_query_secs
waiting_query_rows_affected
waiting_query_rows_examined
blocking_thread_id
blocking_pid
blocking_account
blocking_lock_type
blocking_lock_duration
sql_kill_blocking_query
sql_kill_blocking_connection
*
table_schema
table_name
total_latency
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
*
table_schema
table_name
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_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
*
object_schema
object_name
rows_full_scanned
latency
*
object_schema
object_name
index_name
*
thd_id
conn_id
user
db
command
state
time
current_statement
statement_latency
progress
lock_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
thread_id
ssl_version
ssl_cipher
ssl_sessions_reused
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
lock_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
rows_affected
rows_affected_avg
tmp_tables
tmp_disk_tables
rows_sorted
sort_merge_passes
digest
first_seen
last_seen
*
query
db
exec_count
errors
error_pct
warnings
warning_pct
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
no_index_used_count
no_good_index_used_count
no_index_used_pct
rows_sent
rows_examined
rows_sent_avg
rows_examined_avg
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
sort_merge_passes
avg_sort_merges
sorts_using_scans
sort_using_range
rows_sorted
avg_rows_sorted
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
memory_tmp_tables
disk_tmp_tables
avg_tmp_tables_per_query
tmp_tables_to_disk_pct
first_seen
last_seen
digest
*
variable
value
set_time
set_by
*
user
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_hosts
current_memory
total_memory_allocated
*
user
ios
io_latency
*
user
event_name
total
latency
max_latency
*
user
event_name
total
total_latency
avg_latency
*
user
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
user
statement
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
sys_version
mysql_version
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
host
event
total
total_latency
avg_latency
max_latency
*
user
event
total
total_latency
avg_latency
max_latency
*
events
total
total_latency
avg_latency
max_latency
*
host
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_users
current_memory
total_memory_allocated
*
host
ios
io_latency
*
host
event_name
total
total_latency
max_latency
*
host
event_name
total
total_latency
avg_latency
*
host
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
host
statement
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
object_schema
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
object_schema
object_name
allocated
data
pages
pages_hashed
pages_old
rows_cached
*
wait_started
wait_age
wait_age_secs
locked_table
locked_table_schema
locked_table_name
locked_table_partition
locked_table_subpartition
locked_index
locked_type
waiting_trx_id
waiting_trx_started
waiting_trx_age
waiting_trx_rows_locked
waiting_trx_rows_modified
waiting_pid
waiting_query
waiting_lock_id
waiting_lock_mode
blocking_trx_id
blocking_pid
blocking_query
blocking_lock_id
blocking_lock_mode
blocking_trx_started
blocking_trx_age
blocking_trx_rows_locked
blocking_trx_rows_modified
sql_kill_blocking_query
sql_kill_blocking_connection
*
user
total
total_latency
min_latency
avg_latency
max_latency
thread_id
processlist_id
*
file
count_read
total_read
avg_read
count_write
total_written
avg_write
total
write_pct
*
file
total
total_latency
count_read
read_latency
count_write
write_latency
count_misc
misc_latency
*
event_name
total
total_latency
min_latency
avg_latency
max_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
total_requested
*
event_name
total
total_latency
avg_latency
max_latency
read_latency
write_latency
misc_latency
count_read
total_read
avg_read
count_write
total_written
avg_written
*
thread
file
latency
operation
requested
*
host
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
thread_id
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
user
current_count_used
current_allocated
current_avg_alloc
current_max_alloc
total_allocated
*
event_name
current_count
current_alloc
current_avg_alloc
high_count
high_alloc
high_avg_alloc
*
total_allocated
*
thd_id
conn_id
user
db
command
state
time
current_statement
statement_latency
progress
lock_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
avg_us
percentile
*
cnt
avg_us
*
table_schema
table_name
count_read
sum_number_of_bytes_read
sum_timer_read
count_write
sum_number_of_bytes_write
sum_timer_write
count_misc
sum_timer_misc
*
table_schema
table_name
index_name
non_unique
subpart_exists
index_columns
*
table_schema
table_name
index_name
rows_selected
select_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
*
object_schema
object_name
waiting_thread_id
waiting_pid
waiting_account
waiting_lock_type
waiting_lock_duration
waiting_query
waiting_query_secs
waiting_query_rows_affected
waiting_query_rows_examined
blocking_thread_id
blocking_pid
blocking_account
blocking_lock_type
blocking_lock_duration
sql_kill_blocking_query
sql_kill_blocking_connection
*
table_schema
table_name
total_latency
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_latency
*
table_schema
table_name
rows_fetched
fetch_latency
rows_inserted
insert_latency
rows_updated
update_latency
rows_deleted
delete_latency
io_read_requests
io_read
io_read_latency
io_write_requests
io_write
io_write_latency
io_misc_requests
io_misc_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
*
object_schema
object_name
rows_full_scanned
latency
*
thd_id
conn_id
user
db
command
state
time
current_statement
statement_latency
progress
lock_latency
rows_examined
rows_sent
rows_affected
tmp_tables
tmp_disk_tables
full_scan
last_statement
last_statement_latency
current_memory
last_wait
last_wait_latency
source
trx_latency
trx_state
trx_autocommit
pid
program_name
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
lock_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
rows_affected
rows_affected_avg
tmp_tables
tmp_disk_tables
rows_sorted
sort_merge_passes
digest
first_seen
last_seen
*
query
db
exec_count
errors
error_pct
warnings
warning_pct
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
no_index_used_count
no_good_index_used_count
no_index_used_pct
rows_sent
rows_examined
rows_sent_avg
rows_examined_avg
first_seen
last_seen
digest
*
query
db
full_scan
exec_count
err_count
warn_count
total_latency
max_latency
avg_latency
rows_sent
rows_sent_avg
rows_examined
rows_examined_avg
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
sort_merge_passes
avg_sort_merges
sorts_using_scans
sort_using_range
rows_sorted
avg_rows_sorted
first_seen
last_seen
digest
*
query
db
exec_count
total_latency
memory_tmp_tables
disk_tmp_tables
avg_tmp_tables_per_query
tmp_tables_to_disk_pct
first_seen
last_seen
digest
*
user
statements
statement_latency
statement_avg_latency
table_scans
file_ios
file_io_latency
current_connections
total_connections
unique_hosts
current_memory
total_memory_allocated
*
user
ios
io_latency
*
user
event_name
total
latency
max_latency
*
user
event_name
total
total_latency
avg_latency
*
user
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
user
statement
total
total_latency
max_latency
lock_latency
rows_sent
rows_examined
rows_affected
full_scans
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
event_class
total
total_latency
min_latency
avg_latency
max_latency
*
host
event
total
total_latency
avg_latency
max_latency
*
user
event
total
total_latency
avg_latency
max_latency
*
events
total
total_latency
avg_latency
max_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
Tampilkan
criteria
Urutan
Menaik
Menurun
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
Teks
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
Tampilkan
criteria
Urutan
Menaik
Menurun
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
Teks
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
Tampilkan
criteria
Urutan
Menaik
Menurun
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
Teks
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
Tampilkan
criteria
Urutan
Menaik
Menurun
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
Teks
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
Server Demo phpMyAdmin:
Saat ini menjalankan revisi Git
RELEASE_5_2_1-5377-g8e721911f0
dari
master
cabang.