Current server:
(Palvelimet) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Äskettäinen
Äskettäisiä tauluja ei ole.
Suosikit
Suosikkitauluja ei ole.
X
Uusi
information_schema
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
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа
Navigointi paneeli
Navigointipuu
Palvelimet
Tietokannat
Taulut
Navigointi paneeli
Mukauta navigointipalkin näkymää.
Navigointi paneeli
Näytä tietokannan navigointi puun muodossa
Korvaa navigaatiopaneelin tietokantapuun valitsimella
Linkitä pääpaneelin kanssa
Yhdistä pääpaneelin kanssa korostamalla nykyinen tietokanta tai taulu.
Näytä logo
Näytä logo navigaatiopaneelissa.
Logon linkin osoite
URL-osoite, johon logo navigointipaneelissa osoittaa.
Logon linkin kohde
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Käytä korostusta
Korosta hiire kohdistimen alla oleva palvelin.
Kohteiden enimmäismäärä ensimmäisellä tasolla
Nimikkeiden määrä jotka voidaan näyttää navigointipuun ensimmäisen tason eri sivuilla.
Suodatimessa näytettävien kohteiden vähimmäismäärä
Määrittää kohteiden (taulukot, näkymät, rutiinit ja tapahtumat) suodattimen vähimmäismäärän.
Viimeksi käytetty taulut
Taulujen maksimimäärä viimeksi käytettyjen taulujen luettelossa, 0 poistaa käytöstä.
Suosikkitaulut
Suosikkitaulujen maksimimäärä, 0 poistaa käytöstä.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigointipuu
Mukauta navigointipuuta.
Navigointipuu
Kohteiden enimmäismäärä haarassa
Nimikkeiden määrä jotka voidaan näyttää navigointipuun eri sivuilla.
Navigointipuun ryhmittäminen
Ryhmitä kohteet navigointipuussa (puu määritellään alla osoitetulla erottimella yllä olevissa tietokannoissa ja tauluissa).
Kytke navigointipuun laajennus päälle
Mikäli tarjotaan mahdollisuus puun laajennukseen navigointipaneelissa.
Näytä taulut puussa
Mikäli haluat näyttää tietokannan taulut navigointipuussa
Näytä näkymät puussa
Mikäli haluat näyttää tietokannan näkymät navigaatiopuussa
Näytä funktiot puussa
Mikäli haluat näyttää tietokannan funktiot navigaatiopuussa
Näytä prosessit puussa
Mikäli haluat näyttää tietokannan prosessit navigaatiopuussa
Näytä tapahtumat puussa
Mikäli haluat näyttää tietokannan tapahtumat navigaatiopuussa
Expand single database
Whether to expand single database in the navigation tree automatically.
Palvelimet
Palvelinten näyttöasetukset.
Palvelimet
Näytä palvelinten valinta
Näytä palvelimen valinta navigointipaneelin yläreunassa.
Näytä palvelimet luettelona
Näytä palvelimet luettelona eikä pudotusvalikkona.
Tietokannat
Tietokantojen näyttöasetukset.
Tietokannat
Taululuettelossa näkyvien taulujen minimimäärä
Tietokantapuun erotin
Merkkijono, joka jakaa tietokannat eri puutasoille.
Taulut
Taulujen näyttöasetukset.
Taulut
Pikakäyttökuvakkeen kohde
Rakenne
SQL
Etsi
Lisää rivi
Selaa
Toisen pikakäyttökuvakkeen kohde
Rakenne
SQL
Etsi
Lisää rivi
Selaa
Taulupuun erotin
Merkkijono, joka jakaa taulut eri puutasoille.
Taulupuun enimmäissyvyys
Vedä tiedostot tähän
SQL upload (
0
)
x
-
Näytä piilotetut navigointipuun kohteet.
Luo näkymä
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Kyllä
/
Ei
/
Delete settings
JavaScriptin on oltava päällä tämän jälkeen!
Palvelin: phpMyAdmin demo - MySQL
Database: sys
Rakenne
SQL
Etsi
Haku
(current)
Vienti
root@192.168.30.%
phpMyAdminin ohjeet
MySQL documentation
Asetukset
Poistu
Konsoli
Tyhjennä
Historia
Valinnat
Suorita kysely painamalla Ctrl+Enter
Paina Enter suorittaaksesi kyselyn
nouseva
laskeva
Järjestys:
Etsi virheitä SQL-kyselystä
Laske
Suoritusjärjestys
Aikaa kului
Järjestä mukaan:
Ryhmäkyselyt
Pura ryhmäkyselyt
Paina kokoon
Laajenna
Näytä seuranta
Piilota seuranta
Luku:
Aikaa kului:
Valinnat
Restore default values
Laajenna jokainen hakulauseen viesti
Näytä kyselyhistoria käynnistyksessä
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Vaihda tummaan teemaan
Paina kokoon
Laajenna
Suorita hakulause uudelleen
Muokkaa
Selitä
Profilointi
Kysely epäonnistui
Tietokanta:
Hakulauseen suoritusaika:
Loading
ENUM/SET-muokkaus
Luo näkymä
Kyselyikkuna
*
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
Näytä
criteria
Järjestä
Nouseva
Laskeva
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
Teksti
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
Näytä
criteria
Järjestä
Nouseva
Laskeva
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
Teksti
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
Näytä
criteria
Järjestä
Nouseva
Laskeva
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
Teksti
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
Näytä
criteria
Järjestä
Nouseva
Laskeva
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
Teksti
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
phpMyAdminin demo-palvelin:
Tällä hetkellä käynnissä Git-painos
RELEASE_5_2_1-4907-g5b04607256
master
-haarasta.