Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
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
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Cambiar las opciones de la modalidad de visualización.
Modalidad de navegación
Documentación Use solamente íconos, solamente texto o ambos. Restaurar valor predeterminado
Documentación Use solamente íconos, solamente texto o ambos. Restaurar valor predeterminado
Documentación Si el usuario puede ver un botón "mostrar todos (los registros)" o no. Restaurar valor predeterminado
Documentación Número de filas mostradas cuando se visualiza un juego de resultados. Si el juego de resultados contiene más filas, aparecerán enlaces "Anterior" y "Siguiente". Restaurar valor predeterminado
Documentación SMART - es decir: orden descendente para columnas de tipo TIME, DATE, DATETIME y TIMESTAMP, ascendente en los demás casos. Restaurar valor predeterminado
Documentación Resaltar las filas señaladas por el cursor del ratón. Restaurar valor predeterminado
Documentación Resaltar las filas seleccionadas. Restaurar valor predeterminado
Documentación Restaurar valor predeterminado
Documentación Restaurar valor predeterminado
Documentación Repetir cabecera cada X celdas, 0 desactiva esta funcionalidad. Restaurar valor predeterminado
Documentación Cantidad máxima de caracteres a mostrar en un campo no-numérico en vista de navegación. Restaurar valor predeterminado
Documentación Estos son los enlaces para Editar, Copiar y Borrar. Restaurar valor predeterminado
Documentación Si se muestran enlaces de fila, incluso en ausencia de una clave única. Restaurar valor predeterminado
Documentación Ordenación predeterminada para tablas con una clave primaria. Restaurar valor predeterminado
Documentación Al explorar tablas, se recordará el ordenamiento de cada tabla. Restaurar valor predeterminado
Documentación Opciones de visualización Restaurar valor predeterminado 
SELECT * FROM `table_lock_waits_summary_by_table` ORDER BY `COUNT_WRITE_LOW_PRIORITY` ASC
[ Editar en línea ] [ Editar ] [ Explicar SQL ] [ Crear código PHP ] [ Actualizar ]
|
|
|
|
Filtrar filas:
OBJECT_TYPE
Since this table records waits by table, always se… 		OBJECT_SCHEMA
Schema name. 		OBJECT_NAME
Table name. 		COUNT_STAR
Number of summarized events and the sum of the x_R… 		SUM_TIMER_WAIT
Total wait time of the summarized events that are … 		MIN_TIMER_WAIT
Minimum wait time of the summarized events that ar… 		AVG_TIMER_WAIT
Average wait time of the summarized events that ar… 		MAX_TIMER_WAIT
Maximum wait time of the summarized events that ar… 		COUNT_READ
Number of all read operations, and the sum of the … 		SUM_TIMER_READ
Total wait time of all read operations that are ti… 		MIN_TIMER_READ
Minimum wait time of all read operations that are … 		AVG_TIMER_READ
Average wait time of all read operations that are … 		MAX_TIMER_READ
Maximum wait time of all read operations that are … 		COUNT_WRITE
Number of all write operations, and the sum of the… 		SUM_TIMER_WRITE
Total wait time of all write operations that are t… 		MIN_TIMER_WRITE
Minimum wait time of all write operations that are… 		AVG_TIMER_WRITE
Average wait time of all write operations that are… 		MAX_TIMER_WRITE
Maximum wait time of all write operations that are… 		COUNT_READ_NORMAL
Number of all internal read normal locks. 		SUM_TIMER_READ_NORMAL
Total wait time of all internal read normal locks … 		MIN_TIMER_READ_NORMAL
Minimum wait time of all internal read normal lock… 		AVG_TIMER_READ_NORMAL
Average wait time of all internal read normal lock… 		MAX_TIMER_READ_NORMAL
Maximum wait time of all internal read normal lock… 		COUNT_READ_WITH_SHARED_LOCKS
Number of all internal read with shared locks. 		SUM_TIMER_READ_WITH_SHARED_LOCKS
Total wait time of all internal read with shared l… 		MIN_TIMER_READ_WITH_SHARED_LOCKS
Minimum wait time of all internal read with shared… 		AVG_TIMER_READ_WITH_SHARED_LOCKS
Average wait time of all internal read with shared… 		MAX_TIMER_READ_WITH_SHARED_LOCKS
Maximum wait time of all internal read with shared… 		COUNT_READ_HIGH_PRIORITY
Number of all internal read high priority locks. 		SUM_TIMER_READ_HIGH_PRIORITY
Total wait time of all internal read high priority… 		MIN_TIMER_READ_HIGH_PRIORITY
Minimum wait time of all internal read high priori… 		AVG_TIMER_READ_HIGH_PRIORITY
Average wait time of all internal read high priori… 		MAX_TIMER_READ_HIGH_PRIORITY
Maximum wait time of all internal read high priori… 		COUNT_READ_NO_INSERT
Number of all internal read no insert locks. 		SUM_TIMER_READ_NO_INSERT
Total wait time of all internal read no insert loc… 		MIN_TIMER_READ_NO_INSERT
Minimum wait time of all internal read no insert l… 		AVG_TIMER_READ_NO_INSERT
Average wait time of all internal read no insert l… 		MAX_TIMER_READ_NO_INSERT
Maximum wait time of all internal read no insert l… 		COUNT_READ_EXTERNAL
Number of all external read locks. 		SUM_TIMER_READ_EXTERNAL
Total wait time of all external read locks that ar… 		MIN_TIMER_READ_EXTERNAL
Minimum wait time of all external read locks that … 		AVG_TIMER_READ_EXTERNAL
Average wait time of all external read locks that … 		MAX_TIMER_READ_EXTERNAL
Maximum wait time of all external read locks that … 		COUNT_WRITE_ALLOW_WRITE
Number of all internal read normal locks. 		SUM_TIMER_WRITE_ALLOW_WRITE
Total wait time of all internal write allow write … 		MIN_TIMER_WRITE_ALLOW_WRITE
Minimum wait time of all internal write allow writ… 		AVG_TIMER_WRITE_ALLOW_WRITE
Average wait time of all internal write allow writ… 		MAX_TIMER_WRITE_ALLOW_WRITE
Maximum wait time of all internal write allow writ… 		COUNT_WRITE_CONCURRENT_INSERT
Number of all internal concurrent insert write loc… 		SUM_TIMER_WRITE_CONCURRENT_INSERT
Total wait time of all internal concurrent insert … 		MIN_TIMER_WRITE_CONCURRENT_INSERT
Minimum wait time of all internal concurrent inser… 		AVG_TIMER_WRITE_CONCURRENT_INSERT
Average wait time of all internal concurrent inser… 		MAX_TIMER_WRITE_CONCURRENT_INSERT
Maximum wait time of all internal concurrent inser… 		COUNT_WRITE_DELAYED
Number of all internal write delayed locks. 		SUM_TIMER_WRITE_DELAYED
Total wait time of all internal write delayed lock… 		MIN_TIMER_WRITE_DELAYED
Minimum wait time of all internal write delayed lo… 		AVG_TIMER_WRITE_DELAYED
Average wait time of all internal write delayed lo… 		MAX_TIMER_WRITE_DELAYED
Maximum wait time of all internal write delayed lo… 		COUNT_WRITE_LOW_PRIORITY Ascendente Descendente 1
Number of all internal write low priority locks. 		SUM_TIMER_WRITE_LOW_PRIORITY
Total wait time of all internal write low priority… 		MIN_TIMER_WRITE_LOW_PRIORITY
Minimum wait time of all internal write low priori… 		AVG_TIMER_WRITE_LOW_PRIORITY
Average wait time of all internal write low priori… 		MAX_TIMER_WRITE_LOW_PRIORITY
Maximum wait time of all internal write low priori… 		COUNT_WRITE_NORMAL
Number of all internal write normal locks. 		SUM_TIMER_WRITE_NORMAL
Total wait time of all internal write normal locks… 		MIN_TIMER_WRITE_NORMAL
Minimum wait time of all internal write normal loc… 		AVG_TIMER_WRITE_NORMAL
Average wait time of all internal write normal loc… 		MAX_TIMER_WRITE_NORMAL
Maximum wait time of all internal write normal loc… 		COUNT_WRITE_EXTERNAL
Number of all external write locks. 		SUM_TIMER_WRITE_EXTERNAL
Total wait time of all external write locks that a… 		MIN_TIMER_WRITE_EXTERNAL
Minimum wait time of all external write locks that… 		AVG_TIMER_WRITE_EXTERNAL
Average wait time of all external write locks that… 		MAX_TIMER_WRITE_EXTERNAL
Maximum wait time of all external write locks that…
TABLE mysql plugin 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202310 17 11582484 190876 681299 1725102 17 11582484 190876 681299 1725102 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 11582484 190876 681299 1725102 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql servers 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202311 10 5498111 259848 549771 1107963 10 5498111 259848 549771 1107963 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 5498111 259848 549771 1107963 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql db 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202312 21 10951310 273883 521300 988866 21 10951310 273883 521300 988866 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 10951310 273883 521300 988866 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql proxies_priv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202401 10 7246070 62556 724607 1750365 10 7246070 62556 724607 1750365 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 7246070 62556 724607 1750365 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql roles_mapping 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202402 22 13273902 40902 603104 1379841 22 13273902 40902 603104 1379841 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 13273902 40902 603104 1379841 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql global_priv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202403 18 11402836 66967 633179 1397084 18 11402836 66967 633179 1397084 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 11402836 66967 633179 1397084 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql time_zone_leap_second 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202404 22 13820064 95438 627966 1483299 22 13820064 95438 627966 1483299 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 13820064 95438 627966 1483299 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql time_zone_name 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202405 19 11699175 40501 615535 1311270 19 11699175 40501 615535 1311270 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 11699175 40501 615535 1311270 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql time_zone 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202406 19 11587296 189272 609520 1309265 19 11587296 189272 609520 1309265 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 11587296 189272 609520 1309265 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql time_zone_transition_type 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202407 18 11525542 237793 639996 1272774 18 11525542 237793 639996 1272774 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 11525542 237793 639996 1272774 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql time_zone_transition 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202408 19 13081823 216941 688517 1163301 19 13081823 216941 688517 1163301 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 13081823 216941 688517 1163301 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql tables_priv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mymadrid_cocogasdta 50hims202409 18 12714106 230174 706161 1474477 18 12714106 230174 706161 1474477 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 12714106 230174 706161 1474477 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
TABLE mysql columns_priv 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
|
|
|
|
Filtrar filas:
Operaciones sobre los resultados de la consulta Copiar al portapapeles Copiar al portapapeles Exportar Exportar Mostrar gráfico Mostrar gráfico Crear vista Crear vista
Guardar esta consulta en favoritos Guardar esta consulta en favoritos