Servidor actual:
(Servidores) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Reciente
`portfolio`.`profils`
Favoritas
No existen tablas favoritas.
Nueva
Books
CSV_DB 10
Employees
information_schema
myLogistic
mysql
performance_schema
phpmyadmin
student
sys
wp cms Moulaye
Panel de navegación
Árbol de navegación
Servidores
Bases de datos
Tablas
Panel de navegación
Cambiar la apariencia del panel de navegación.
Panel de navegación
Mostrar las bases de datos navegación como árbol
En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal
Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo
Mostrar el logo en el panel de navegación.
URL para enlace del logo
URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace
Abrir la página enlazada en la ventana principal (
principal
) o en una nueva (
nueva
).
main
new
Permitir destacar
Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel
El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro
Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas
Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas
Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación
Asignar 0 para ocular el panel de navegación.
Árbol de navegación
Personalizar el árbol de navegación.
Árbol de navegación
Cantidad máxima de elementos en una rama
El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol
Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación
Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol
Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol
Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol
Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol
Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol
Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única
Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.
Servidores
Opciones para visualizar los servidores.
Servidores
Mostrar la selección de servidores
Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista
Mostrar los servidores en una lista en lugar de una caja desplegable.
Bases de datos
Opciones para visualizar las bases de datos.
Bases de datos
Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos
Cadena que separa bases de datos en diferentes niveles de árbol.
Tablas
Opciones para visualizar las tablas.
Tablas
Destino para el icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Objetivo para el segundo icono de acceso rápido
Estructura
SQL
Buscar
Insertar
Examinar
Separador de árbol de tablas
Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas
Suelte aquí los archivos
Carga SQL (
0
)
x
-
Mostrar los elementos escondidos del árbol de navegación.
Crear vista
¡Pasado este punto, debe tener Javascript activado!
Servidor: phpMyAdmin demo - MySQL
Base de datos: sys
Estructura
SQL
Buscar
Generar una consulta
(actual)
Exportar
root@192.168.30.%
Documentación de phpMyAdmin
MySQL documentation
Appearance:
Light
Dark
Configuración
Finalizar sesión
Consola
Limpiar
Historial
Opciones
Favoritos
Presione Ctrl+Enter para ejecutar la consulta
Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar
Expandir
Mostrar rastro
Ocultar rastro
Cantidad:
Tiempo necesario:
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Etiqueta:
Base de datos de destino:
Compartir favorito
OK
Opciones
Restore default values
Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro
Colapsar
Expandir
Reconsultar
Editar
Explicar
Perfilando
Agregar a favoritos
Falló la consulta
Base de datos:
Fecha y hora la consulta:
Cargando
Editor de ENUM/SET
Crear vista
Ventana de consulta
*
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
seleccionar tabla
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Column
seleccionar columna
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
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
.
seleccionar columna
seleccionar tabla
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Column
seleccionar columna
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
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
.
seleccionar columna
seleccionar tabla
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Column
seleccionar columna
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
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
.
seleccionar columna
seleccionar tabla
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
.
seleccionar columna
Mostrar
criterio
Ordenar
Ascendente
Descendente
Agregar "as"
AND
OR
Column
seleccionar columna
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Texto
Otra columna
seleccionar tabla
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
.
seleccionar columna
Servidor phpMyAdmin de demostración:
Actualmente ejecutando la revisión
RELEASE_5_2_1-5377-g8e721911f0
de Git de la rama
master
.