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:
Opciones
Restore default values
Colapsar Expandir Reconsultar Editar Explicar Perfilando Falló la consulta Base de datos: Fecha y hora la consulta:

performance_schema

accounts

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí

cond_instances

Columna Tipo Nulo Predeterminado Comentarios
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
NAME HASH No No NAME No

data_locks

Columna Tipo Nulo Predeterminado Comentarios
ENGINE (Primaria) varchar(32) No
ENGINE_LOCK_ID (Primaria) varchar(128) No
ENGINE_TRANSACTION_ID bigint(20) Sí NULL
THREAD_ID bigint(20) Sí NULL
EVENT_ID bigint(20) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
PARTITION_NAME varchar(64) Sí NULL
SUBPARTITION_NAME varchar(64) Sí NULL
INDEX_NAME varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
LOCK_TYPE varchar(32) No
LOCK_MODE varchar(32) No
LOCK_STATUS varchar(32) No
LOCK_DATA varchar(8192) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No ENGINE_LOCK_ID No
ENGINE No
ENGINE_TRANSACTION_ID HASH No No ENGINE_TRANSACTION_ID Sí
ENGINE No
THREAD_ID HASH No No THREAD_ID Sí
EVENT_ID Sí
OBJECT_SCHEMA HASH No No OBJECT_SCHEMA Sí
OBJECT_NAME Sí
PARTITION_NAME Sí
SUBPARTITION_NAME Sí

data_lock_waits

Columna Tipo Nulo Predeterminado Comentarios
ENGINE varchar(32) No
REQUESTING_ENGINE_LOCK_ID varchar(128) No
REQUESTING_ENGINE_TRANSACTION_ID bigint(20) Sí NULL
REQUESTING_THREAD_ID bigint(20) Sí NULL
REQUESTING_EVENT_ID bigint(20) Sí NULL
REQUESTING_OBJECT_INSTANCE_BEGIN bigint(20) No
BLOCKING_ENGINE_LOCK_ID varchar(128) No
BLOCKING_ENGINE_TRANSACTION_ID bigint(20) Sí NULL
BLOCKING_THREAD_ID bigint(20) Sí NULL
BLOCKING_EVENT_ID bigint(20) Sí NULL
BLOCKING_OBJECT_INSTANCE_BEGIN bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
REQUESTING_ENGINE_LOCK_ID HASH No No REQUESTING_ENGINE_LOCK_ID No
ENGINE No
BLOCKING_ENGINE_LOCK_ID HASH No No BLOCKING_ENGINE_LOCK_ID No
ENGINE No
REQUESTING_ENGINE_TRANSACTION_ID HASH No No REQUESTING_ENGINE_TRANSACTION_ID Sí
ENGINE No
BLOCKING_ENGINE_TRANSACTION_ID HASH No No BLOCKING_ENGINE_TRANSACTION_ID Sí
ENGINE No
REQUESTING_THREAD_ID HASH No No REQUESTING_THREAD_ID Sí
REQUESTING_EVENT_ID Sí
BLOCKING_THREAD_ID HASH No No BLOCKING_THREAD_ID Sí
BLOCKING_EVENT_ID Sí

events_errors_summary_by_account_by_error

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
ERROR_NUMBER int(11) Sí NULL
ERROR_NAME varchar(64) Sí NULL
SQL_STATE varchar(5) Sí NULL
SUM_ERROR_RAISED bigint(20) No
SUM_ERROR_HANDLED bigint(20) No
FIRST_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
ERROR_NUMBER Sí

events_errors_summary_by_host_by_error

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
ERROR_NUMBER int(11) Sí NULL
ERROR_NAME varchar(64) Sí NULL
SQL_STATE varchar(5) Sí NULL
SUM_ERROR_RAISED bigint(20) No
SUM_ERROR_HANDLED bigint(20) No
FIRST_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
ERROR_NUMBER Sí

events_errors_summary_by_thread_by_error

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID bigint(20) No
ERROR_NUMBER int(11) Sí NULL
ERROR_NAME varchar(64) Sí NULL
SQL_STATE varchar(5) Sí NULL
SUM_ERROR_RAISED bigint(20) No
SUM_ERROR_HANDLED bigint(20) No
FIRST_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
THREAD_ID HASH Sí No THREAD_ID No
ERROR_NUMBER Sí

events_errors_summary_by_user_by_error

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
ERROR_NUMBER int(11) Sí NULL
ERROR_NAME varchar(64) Sí NULL
SQL_STATE varchar(5) Sí NULL
SUM_ERROR_RAISED bigint(20) No
SUM_ERROR_HANDLED bigint(20) No
FIRST_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
ERROR_NUMBER Sí

events_errors_summary_global_by_error

Columna Tipo Nulo Predeterminado Comentarios
ERROR_NUMBER int(11) Sí NULL
ERROR_NAME varchar(64) Sí NULL
SQL_STATE varchar(5) Sí NULL
SUM_ERROR_RAISED bigint(20) No
SUM_ERROR_HANDLED bigint(20) No
FIRST_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ERROR_NUMBER HASH Sí No ERROR_NUMBER Sí

events_stages_current

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
WORK_COMPLETED bigint(20) Sí NULL
WORK_ESTIMATED bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_stages_history

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
WORK_COMPLETED bigint(20) Sí NULL
WORK_ESTIMATED bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_stages_history_long

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
WORK_COMPLETED bigint(20) Sí NULL
WORK_ESTIMATED bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

¡No se ha definido ningún índice!

events_stages_summary_by_account_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
EVENT_NAME No

events_stages_summary_by_host_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
EVENT_NAME No

events_stages_summary_by_thread_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_NAME No

events_stages_summary_by_user_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
EVENT_NAME No

events_stages_summary_global_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

events_statements_current

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Sí NULL
DIGEST varchar(64) Sí NULL
DIGEST_TEXT longtext Sí NULL
CURRENT_SCHEMA varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
MYSQL_ERRNO int(11) Sí NULL
RETURNED_SQLSTATE varchar(5) Sí NULL
MESSAGE_TEXT varchar(128) Sí NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
NESTING_EVENT_LEVEL int(11) Sí NULL
STATEMENT_ID bigint(20) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_statements_histogram_by_digest

Columna Tipo Nulo Predeterminado Comentarios
SCHEMA_NAME varchar(64) Sí NULL
DIGEST varchar(64) Sí NULL
BUCKET_NUMBER int(10) No
BUCKET_TIMER_LOW bigint(20) No
BUCKET_TIMER_HIGH bigint(20) No
COUNT_BUCKET bigint(20) No
COUNT_BUCKET_AND_LOWER bigint(20) No
BUCKET_QUANTILE double(7,6) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
SCHEMA_NAME HASH Sí No SCHEMA_NAME Sí
DIGEST Sí
BUCKET_NUMBER No

events_statements_histogram_global

Columna Tipo Nulo Predeterminado Comentarios
BUCKET_NUMBER (Primaria) int(10) No
BUCKET_TIMER_LOW bigint(20) No
BUCKET_TIMER_HIGH bigint(20) No
COUNT_BUCKET bigint(20) No
COUNT_BUCKET_AND_LOWER bigint(20) No
BUCKET_QUANTILE double(7,6) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No BUCKET_NUMBER No

events_statements_history

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Sí NULL
DIGEST varchar(64) Sí NULL
DIGEST_TEXT longtext Sí NULL
CURRENT_SCHEMA varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
MYSQL_ERRNO int(11) Sí NULL
RETURNED_SQLSTATE varchar(5) Sí NULL
MESSAGE_TEXT varchar(128) Sí NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
NESTING_EVENT_LEVEL int(11) Sí NULL
STATEMENT_ID bigint(20) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_statements_history_long

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Sí NULL
DIGEST varchar(64) Sí NULL
DIGEST_TEXT longtext Sí NULL
CURRENT_SCHEMA varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
MYSQL_ERRNO int(11) Sí NULL
RETURNED_SQLSTATE varchar(5) Sí NULL
MESSAGE_TEXT varchar(128) Sí NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
NESTING_EVENT_LEVEL int(11) Sí NULL
STATEMENT_ID bigint(20) Sí NULL

¡No se ha definido ningún índice!

events_statements_summary_by_account_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
EVENT_NAME No

events_statements_summary_by_digest

Columna Tipo Nulo Predeterminado Comentarios
SCHEMA_NAME varchar(64) Sí NULL
DIGEST varchar(64) Sí NULL
DIGEST_TEXT longtext Sí NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No
FIRST_SEEN timestamp(6) No 0000-00-00 00:00:00.000000
LAST_SEEN timestamp(6) No 0000-00-00 00:00:00.000000
QUANTILE_95 bigint(20) No
QUANTILE_99 bigint(20) No
QUANTILE_999 bigint(20) No
QUERY_SAMPLE_TEXT longtext Sí NULL
QUERY_SAMPLE_SEEN timestamp(6) No 0000-00-00 00:00:00.000000
QUERY_SAMPLE_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
SCHEMA_NAME HASH Sí No SCHEMA_NAME Sí
DIGEST Sí

events_statements_summary_by_host_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
EVENT_NAME No

events_statements_summary_by_program

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE (Primaria) enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') No
OBJECT_SCHEMA (Primaria) varchar(64) No
OBJECT_NAME (Primaria) varchar(64) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_STATEMENTS bigint(20) No
SUM_STATEMENTS_WAIT bigint(20) No
MIN_STATEMENTS_WAIT bigint(20) No
AVG_STATEMENTS_WAIT bigint(20) No
MAX_STATEMENTS_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_TYPE No
OBJECT_SCHEMA No
OBJECT_NAME No

events_statements_summary_by_thread_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_NAME No

events_statements_summary_by_user_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
EVENT_NAME No

events_statements_summary_global_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

events_transactions_current

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
STATE enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') Sí NULL
TRX_ID bigint(20) Sí NULL
GTID varchar(64) Sí NULL
XID_FORMAT_ID int(11) Sí NULL
XID_GTRID varchar(130) Sí NULL
XID_BQUAL varchar(130) Sí NULL
XA_STATE varchar(64) Sí NULL
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
ACCESS_MODE enum('READ ONLY', 'READ WRITE') Sí NULL
ISOLATION_LEVEL varchar(64) Sí NULL
AUTOCOMMIT enum('YES', 'NO') No
NUMBER_OF_SAVEPOINTS bigint(20) Sí NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT bigint(20) Sí NULL
NUMBER_OF_RELEASE_SAVEPOINT bigint(20) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_transactions_history

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
STATE enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') Sí NULL
TRX_ID bigint(20) Sí NULL
GTID varchar(64) Sí NULL
XID_FORMAT_ID int(11) Sí NULL
XID_GTRID varchar(130) Sí NULL
XID_BQUAL varchar(130) Sí NULL
XA_STATE varchar(64) Sí NULL
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
ACCESS_MODE enum('READ ONLY', 'READ WRITE') Sí NULL
ISOLATION_LEVEL varchar(64) Sí NULL
AUTOCOMMIT enum('YES', 'NO') No
NUMBER_OF_SAVEPOINTS bigint(20) Sí NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT bigint(20) Sí NULL
NUMBER_OF_RELEASE_SAVEPOINT bigint(20) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_transactions_history_long

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
STATE enum('ACTIVE', 'COMMITTED', 'ROLLED BACK') Sí NULL
TRX_ID bigint(20) Sí NULL
GTID varchar(64) Sí NULL
XID_FORMAT_ID int(11) Sí NULL
XID_GTRID varchar(130) Sí NULL
XID_BQUAL varchar(130) Sí NULL
XA_STATE varchar(64) Sí NULL
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
ACCESS_MODE enum('READ ONLY', 'READ WRITE') Sí NULL
ISOLATION_LEVEL varchar(64) Sí NULL
AUTOCOMMIT enum('YES', 'NO') No
NUMBER_OF_SAVEPOINTS bigint(20) Sí NULL
NUMBER_OF_ROLLBACK_TO_SAVEPOINT bigint(20) Sí NULL
NUMBER_OF_RELEASE_SAVEPOINT bigint(20) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) Sí NULL
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL

¡No se ha definido ningún índice!

events_transactions_summary_by_account_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ_WRITE bigint(20) No
SUM_TIMER_READ_WRITE bigint(20) No
MIN_TIMER_READ_WRITE bigint(20) No
AVG_TIMER_READ_WRITE bigint(20) No
MAX_TIMER_READ_WRITE bigint(20) No
COUNT_READ_ONLY bigint(20) No
SUM_TIMER_READ_ONLY bigint(20) No
MIN_TIMER_READ_ONLY bigint(20) No
AVG_TIMER_READ_ONLY bigint(20) No
MAX_TIMER_READ_ONLY bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
EVENT_NAME No

events_transactions_summary_by_host_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ_WRITE bigint(20) No
SUM_TIMER_READ_WRITE bigint(20) No
MIN_TIMER_READ_WRITE bigint(20) No
AVG_TIMER_READ_WRITE bigint(20) No
MAX_TIMER_READ_WRITE bigint(20) No
COUNT_READ_ONLY bigint(20) No
SUM_TIMER_READ_ONLY bigint(20) No
MIN_TIMER_READ_ONLY bigint(20) No
AVG_TIMER_READ_ONLY bigint(20) No
MAX_TIMER_READ_ONLY bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
EVENT_NAME No

events_transactions_summary_by_thread_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ_WRITE bigint(20) No
SUM_TIMER_READ_WRITE bigint(20) No
MIN_TIMER_READ_WRITE bigint(20) No
AVG_TIMER_READ_WRITE bigint(20) No
MAX_TIMER_READ_WRITE bigint(20) No
COUNT_READ_ONLY bigint(20) No
SUM_TIMER_READ_ONLY bigint(20) No
MIN_TIMER_READ_ONLY bigint(20) No
AVG_TIMER_READ_ONLY bigint(20) No
MAX_TIMER_READ_ONLY bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_NAME No

events_transactions_summary_by_user_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ_WRITE bigint(20) No
SUM_TIMER_READ_WRITE bigint(20) No
MIN_TIMER_READ_WRITE bigint(20) No
AVG_TIMER_READ_WRITE bigint(20) No
MAX_TIMER_READ_WRITE bigint(20) No
COUNT_READ_ONLY bigint(20) No
SUM_TIMER_READ_ONLY bigint(20) No
MIN_TIMER_READ_ONLY bigint(20) No
AVG_TIMER_READ_ONLY bigint(20) No
MAX_TIMER_READ_ONLY bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
EVENT_NAME No

events_transactions_summary_global_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ_WRITE bigint(20) No
SUM_TIMER_READ_WRITE bigint(20) No
MIN_TIMER_READ_WRITE bigint(20) No
AVG_TIMER_READ_WRITE bigint(20) No
MAX_TIMER_READ_WRITE bigint(20) No
COUNT_READ_ONLY bigint(20) No
SUM_TIMER_READ_ONLY bigint(20) No
MIN_TIMER_READ_ONLY bigint(20) No
AVG_TIMER_READ_ONLY bigint(20) No
MAX_TIMER_READ_ONLY bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

events_waits_current

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
SPINS int(10) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(512) Sí NULL
INDEX_NAME varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Sí NULL
FLAGS int(10) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_waits_history

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_ID (Primaria) bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
SPINS int(10) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(512) Sí NULL
INDEX_NAME varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Sí NULL
FLAGS int(10) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_ID No

events_waits_history_long

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Sí NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Sí NULL
TIMER_START bigint(20) Sí NULL
TIMER_END bigint(20) Sí NULL
TIMER_WAIT bigint(20) Sí NULL
SPINS int(10) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(512) Sí NULL
INDEX_NAME varchar(64) Sí NULL
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Sí NULL
NESTING_EVENT_TYPE enum('TRANSACTION', 'STATEMENT', 'STAGE', 'WAIT') Sí NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Sí NULL
FLAGS int(10) Sí NULL

¡No se ha definido ningún índice!

events_waits_summary_by_account_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
EVENT_NAME No

events_waits_summary_by_host_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
EVENT_NAME No

events_waits_summary_by_instance

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
EVENT_NAME HASH No No EVENT_NAME No

events_waits_summary_by_thread_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_NAME No

events_waits_summary_by_user_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
EVENT_NAME No

events_waits_summary_global_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

file_instances

Columna Tipo Nulo Predeterminado Comentarios
FILE_NAME (Primaria) varchar(512) No
EVENT_NAME varchar(128) No
OPEN_COUNT int(10) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No FILE_NAME No
EVENT_NAME HASH No No EVENT_NAME No

file_summary_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

file_summary_by_instance

Columna Tipo Nulo Predeterminado Comentarios
FILE_NAME varchar(512) No
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
FILE_NAME HASH No No FILE_NAME No
EVENT_NAME HASH No No EVENT_NAME No

global_status

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No VARIABLE_NAME No

global_variables

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No VARIABLE_NAME No

hosts

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí

host_cache

Columna Tipo Nulo Predeterminado Comentarios
IP (Primaria) varchar(64) No
HOST varchar(255) Sí NULL
HOST_VALIDATED enum('YES', 'NO') No
SUM_CONNECT_ERRORS bigint(20) No
COUNT_HOST_BLOCKED_ERRORS bigint(20) No
COUNT_NAMEINFO_TRANSIENT_ERRORS bigint(20) No
COUNT_NAMEINFO_PERMANENT_ERRORS bigint(20) No
COUNT_FORMAT_ERRORS bigint(20) No
COUNT_ADDRINFO_TRANSIENT_ERRORS bigint(20) No
COUNT_ADDRINFO_PERMANENT_ERRORS bigint(20) No
COUNT_FCRDNS_ERRORS bigint(20) No
COUNT_HOST_ACL_ERRORS bigint(20) No
COUNT_NO_AUTH_PLUGIN_ERRORS bigint(20) No
COUNT_AUTH_PLUGIN_ERRORS bigint(20) No
COUNT_HANDSHAKE_ERRORS bigint(20) No
COUNT_PROXY_USER_ERRORS bigint(20) No
COUNT_PROXY_USER_ACL_ERRORS bigint(20) No
COUNT_AUTHENTICATION_ERRORS bigint(20) No
COUNT_SSL_ERRORS bigint(20) No
COUNT_MAX_USER_CONNECTIONS_ERRORS bigint(20) No
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS bigint(20) No
COUNT_DEFAULT_DATABASE_ERRORS bigint(20) No
COUNT_INIT_CONNECT_ERRORS bigint(20) No
COUNT_LOCAL_ERRORS bigint(20) No
COUNT_UNKNOWN_ERRORS bigint(20) No
FIRST_SEEN timestamp No 0000-00-00 00:00:00
LAST_SEEN timestamp No 0000-00-00 00:00:00
FIRST_ERROR_SEEN timestamp Sí 0000-00-00 00:00:00
LAST_ERROR_SEEN timestamp Sí 0000-00-00 00:00:00

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No IP No
HOST HASH No No HOST Sí

keyring_keys

Columna Tipo Nulo Predeterminado Comentarios
KEY_ID varchar(255) No
KEY_OWNER varchar(255) Sí NULL
BACKEND_KEY_ID varchar(255) Sí NULL

¡No se ha definido ningún índice!

log_status

Columna Tipo Nulo Predeterminado Comentarios
SERVER_UUID char(36) No
LOCAL json No
REPLICATION json No
STORAGE_ENGINES json No

¡No se ha definido ningún índice!

memory_summary_by_account_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_ALLOC bigint(20) No
COUNT_FREE bigint(20) No
SUM_NUMBER_OF_BYTES_ALLOC bigint(20) No
SUM_NUMBER_OF_BYTES_FREE bigint(20) No
LOW_COUNT_USED bigint(20) No
CURRENT_COUNT_USED bigint(20) No
HIGH_COUNT_USED bigint(20) No
LOW_NUMBER_OF_BYTES_USED bigint(20) No
CURRENT_NUMBER_OF_BYTES_USED bigint(20) No
HIGH_NUMBER_OF_BYTES_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
EVENT_NAME No

memory_summary_by_host_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
EVENT_NAME varchar(128) No
COUNT_ALLOC bigint(20) No
COUNT_FREE bigint(20) No
SUM_NUMBER_OF_BYTES_ALLOC bigint(20) No
SUM_NUMBER_OF_BYTES_FREE bigint(20) No
LOW_COUNT_USED bigint(20) No
CURRENT_COUNT_USED bigint(20) No
HIGH_COUNT_USED bigint(20) No
LOW_NUMBER_OF_BYTES_USED bigint(20) No
CURRENT_NUMBER_OF_BYTES_USED bigint(20) No
HIGH_NUMBER_OF_BYTES_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
EVENT_NAME No

memory_summary_by_thread_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
EVENT_NAME (Primaria) varchar(128) No
COUNT_ALLOC bigint(20) No
COUNT_FREE bigint(20) No
SUM_NUMBER_OF_BYTES_ALLOC bigint(20) No
SUM_NUMBER_OF_BYTES_FREE bigint(20) No
LOW_COUNT_USED bigint(20) No
CURRENT_COUNT_USED bigint(20) No
HIGH_COUNT_USED bigint(20) No
LOW_NUMBER_OF_BYTES_USED bigint(20) No
CURRENT_NUMBER_OF_BYTES_USED bigint(20) No
HIGH_NUMBER_OF_BYTES_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
EVENT_NAME No

memory_summary_by_user_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
EVENT_NAME varchar(128) No
COUNT_ALLOC bigint(20) No
COUNT_FREE bigint(20) No
SUM_NUMBER_OF_BYTES_ALLOC bigint(20) No
SUM_NUMBER_OF_BYTES_FREE bigint(20) No
LOW_COUNT_USED bigint(20) No
CURRENT_COUNT_USED bigint(20) No
HIGH_COUNT_USED bigint(20) No
LOW_NUMBER_OF_BYTES_USED bigint(20) No
CURRENT_NUMBER_OF_BYTES_USED bigint(20) No
HIGH_NUMBER_OF_BYTES_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
EVENT_NAME No

memory_summary_global_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_ALLOC bigint(20) No
COUNT_FREE bigint(20) No
SUM_NUMBER_OF_BYTES_ALLOC bigint(20) No
SUM_NUMBER_OF_BYTES_FREE bigint(20) No
LOW_COUNT_USED bigint(20) No
CURRENT_COUNT_USED bigint(20) No
HIGH_COUNT_USED bigint(20) No
LOW_NUMBER_OF_BYTES_USED bigint(20) No
CURRENT_NUMBER_OF_BYTES_USED bigint(20) No
HIGH_NUMBER_OF_BYTES_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

metadata_locks

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) No
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
COLUMN_NAME varchar(64) Sí NULL
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
LOCK_TYPE varchar(32) No
LOCK_DURATION varchar(32) No
LOCK_STATUS varchar(32) No
SOURCE varchar(64) Sí NULL
OWNER_THREAD_ID bigint(20) Sí NULL
OWNER_EVENT_ID bigint(20) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
OBJECT_TYPE HASH No No OBJECT_TYPE No
OBJECT_SCHEMA Sí
OBJECT_NAME Sí
COLUMN_NAME Sí
OWNER_THREAD_ID HASH No No OWNER_THREAD_ID Sí
OWNER_EVENT_ID Sí

mutex_instances

Columna Tipo Nulo Predeterminado Comentarios
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
LOCKED_BY_THREAD_ID bigint(20) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
NAME HASH No No NAME No
LOCKED_BY_THREAD_ID HASH No No LOCKED_BY_THREAD_ID Sí

objects_summary_global_by_type

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
OBJECT HASH Sí No OBJECT_TYPE Sí
OBJECT_SCHEMA Sí
OBJECT_NAME Sí

performance_timers

Columna Tipo Nulo Predeterminado Comentarios
TIMER_NAME enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND') No
TIMER_FREQUENCY bigint(20) Sí NULL
TIMER_RESOLUTION bigint(20) Sí NULL
TIMER_OVERHEAD bigint(20) Sí NULL

¡No se ha definido ningún índice!

persisted_variables

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No VARIABLE_NAME No

prepared_statements_instances

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
STATEMENT_ID bigint(20) No
STATEMENT_NAME varchar(64) Sí NULL
SQL_TEXT longtext No
OWNER_THREAD_ID bigint(20) No
OWNER_EVENT_ID bigint(20) No
OWNER_OBJECT_TYPE enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') Sí NULL
OWNER_OBJECT_SCHEMA varchar(64) Sí NULL
OWNER_OBJECT_NAME varchar(64) Sí NULL
TIMER_PREPARE bigint(20) No
COUNT_REPREPARE bigint(20) No
COUNT_EXECUTE bigint(20) No
SUM_TIMER_EXECUTE bigint(20) No
MIN_TIMER_EXECUTE bigint(20) No
AVG_TIMER_EXECUTE bigint(20) No
MAX_TIMER_EXECUTE bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
OWNER_THREAD_ID HASH Sí No OWNER_THREAD_ID No
OWNER_EVENT_ID No
STATEMENT_ID HASH No No STATEMENT_ID No
STATEMENT_NAME HASH No No STATEMENT_NAME Sí
OWNER_OBJECT_TYPE HASH No No OWNER_OBJECT_TYPE Sí
OWNER_OBJECT_SCHEMA Sí
OWNER_OBJECT_NAME Sí

replication_applier_configuration

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
DESIRED_DELAY int(11) No
PRIVILEGE_CHECKS_USER text Sí NULL User name for the security context of the applier.

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No

replication_applier_filters

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME char(64) No
FILTER_NAME char(64) No
FILTER_RULE longtext No
CONFIGURED_BY enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER', 'STARTUP_OPTIONS_FOR_CHANNEL', 'CHANGE_REPLICATION_FILTER_FOR_CHANNEL') No
ACTIVE_SINCE timestamp(6) No 0000-00-00 00:00:00.000000
COUNTER bigint(20) No 0

¡No se ha definido ningún índice!

replication_applier_global_filters

Columna Tipo Nulo Predeterminado Comentarios
FILTER_NAME char(64) No
FILTER_RULE longtext No
CONFIGURED_BY enum('STARTUP_OPTIONS', 'CHANGE_REPLICATION_FILTER') No
ACTIVE_SINCE timestamp(6) No 0000-00-00 00:00:00.000000

¡No se ha definido ningún índice!

replication_applier_status

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
SERVICE_STATE enum('ON', 'OFF') No
REMAINING_DELAY int(10) Sí NULL
COUNT_TRANSACTIONS_RETRIES bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No

replication_applier_status_by_coordinator

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
THREAD_ID bigint(20) Sí NULL
SERVICE_STATE enum('ON', 'OFF') No
LAST_ERROR_NUMBER int(11) No
LAST_ERROR_MESSAGE varchar(1024) No
LAST_ERROR_TIMESTAMP timestamp(6) No
LAST_PROCESSED_TRANSACTION char(57) Sí NULL
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP timestamp(6) No
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP timestamp(6) No
PROCESSING_TRANSACTION char(57) Sí NULL
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP timestamp(6) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No
THREAD_ID HASH No No THREAD_ID Sí

replication_applier_status_by_worker

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
WORKER_ID (Primaria) bigint(20) No
THREAD_ID bigint(20) Sí NULL
SERVICE_STATE enum('ON', 'OFF') No
LAST_ERROR_NUMBER int(11) No
LAST_ERROR_MESSAGE varchar(1024) No
LAST_ERROR_TIMESTAMP timestamp(6) No
LAST_APPLIED_TRANSACTION char(57) Sí NULL
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP timestamp(6) No
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP timestamp(6) No
APPLYING_TRANSACTION char(57) Sí NULL
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP timestamp(6) No
LAST_APPLIED_TRANSACTION_RETRIES_COUNT bigint(20) No
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER int(11) No
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE varchar(1024) Sí NULL
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP timestamp(6) No
APPLYING_TRANSACTION_RETRIES_COUNT bigint(20) No
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER int(11) No
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE varchar(1024) Sí NULL
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP timestamp(6) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No
WORKER_ID No
THREAD_ID HASH No No THREAD_ID Sí

replication_connection_configuration

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
HOST char(255) No
PORT int(11) No
USER char(32) No
NETWORK_INTERFACE char(60) No
AUTO_POSITION enum('1', '0') No
SSL_ALLOWED enum('YES', 'NO', 'IGNORED') No
SSL_CA_FILE varchar(512) No
SSL_CA_PATH varchar(512) No
SSL_CERTIFICATE varchar(512) No
SSL_CIPHER varchar(512) No
SSL_KEY varchar(512) No
SSL_VERIFY_SERVER_CERTIFICATE enum('YES', 'NO') No
SSL_CRL_FILE varchar(255) No
SSL_CRL_PATH varchar(255) No
CONNECTION_RETRY_INTERVAL int(11) No
CONNECTION_RETRY_COUNT bigint(20) No
HEARTBEAT_INTERVAL double(10,3) No Number of seconds after which a heartbeat will be sent .
TLS_VERSION varchar(255) No
PUBLIC_KEY_PATH varchar(512) No
GET_PUBLIC_KEY enum('YES', 'NO') No
NETWORK_NAMESPACE varchar(64) No
COMPRESSION_ALGORITHM char(64) No Compression algorithm used for data transfer between master and slave.
ZSTD_COMPRESSION_LEVEL int(11) No Compression level associated with zstd compression algorithm.

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No

replication_connection_status

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME (Primaria) char(64) No
GROUP_NAME char(36) No
SOURCE_UUID char(36) No
THREAD_ID bigint(20) Sí NULL
SERVICE_STATE enum('ON', 'OFF', 'CONNECTING') No
COUNT_RECEIVED_HEARTBEATS bigint(20) No 0
LAST_HEARTBEAT_TIMESTAMP timestamp(6) No Shows when the most recent heartbeat signal was received.
RECEIVED_TRANSACTION_SET longtext No
LAST_ERROR_NUMBER int(11) No
LAST_ERROR_MESSAGE varchar(1024) No
LAST_ERROR_TIMESTAMP timestamp(6) No
LAST_QUEUED_TRANSACTION char(57) Sí NULL
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP timestamp(6) No
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP timestamp(6) No
QUEUEING_TRANSACTION char(57) Sí NULL
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP timestamp(6) No
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP timestamp(6) No
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP timestamp(6) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No CHANNEL_NAME No
THREAD_ID HASH No No THREAD_ID Sí

replication_group_members

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME char(64) No
MEMBER_ID char(36) No
MEMBER_HOST char(255) No
MEMBER_PORT int(11) Sí NULL
MEMBER_STATE char(64) No
MEMBER_ROLE char(64) No
MEMBER_VERSION char(64) No

¡No se ha definido ningún índice!

replication_group_member_stats

Columna Tipo Nulo Predeterminado Comentarios
CHANNEL_NAME char(64) No
VIEW_ID char(60) No
MEMBER_ID char(36) No
COUNT_TRANSACTIONS_IN_QUEUE bigint(20) No
COUNT_TRANSACTIONS_CHECKED bigint(20) No
COUNT_CONFLICTS_DETECTED bigint(20) No
COUNT_TRANSACTIONS_ROWS_VALIDATING bigint(20) No
TRANSACTIONS_COMMITTED_ALL_MEMBERS longtext No
LAST_CONFLICT_FREE_TRANSACTION text No
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE bigint(20) No
COUNT_TRANSACTIONS_REMOTE_APPLIED bigint(20) No
COUNT_TRANSACTIONS_LOCAL_PROPOSED bigint(20) No
COUNT_TRANSACTIONS_LOCAL_ROLLBACK bigint(20) No

¡No se ha definido ningún índice!

rwlock_instances

Columna Tipo Nulo Predeterminado Comentarios
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
WRITE_LOCKED_BY_THREAD_ID bigint(20) Sí NULL
READ_LOCKED_BY_COUNT int(10) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
NAME HASH No No NAME No
WRITE_LOCKED_BY_THREAD_ID HASH No No WRITE_LOCKED_BY_THREAD_ID Sí

session_account_connect_attrs

Columna Tipo Nulo Predeterminado Comentarios
PROCESSLIST_ID (Primaria) bigint(20) No
ATTR_NAME (Primaria) varchar(32) No
ATTR_VALUE varchar(1024) Sí NULL
ORDINAL_POSITION int(11) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No PROCESSLIST_ID No
ATTR_NAME No

session_connect_attrs

Columna Tipo Nulo Predeterminado Comentarios
PROCESSLIST_ID (Primaria) bigint(20) No
ATTR_NAME (Primaria) varchar(32) No
ATTR_VALUE varchar(1024) Sí NULL
ORDINAL_POSITION int(11) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No PROCESSLIST_ID No
ATTR_NAME No

session_status

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No VARIABLE_NAME No

session_variables

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No VARIABLE_NAME No

setup_actors

Columna Tipo Nulo Predeterminado Comentarios
HOST (Primaria) char(255) No %
USER (Primaria) char(32) No %
ROLE (Primaria) char(32) No %
ENABLED enum('YES', 'NO') No YES
HISTORY enum('YES', 'NO') No YES

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No HOST No
USER No
ROLE No

setup_consumers

Columna Tipo Nulo Predeterminado Comentarios
NAME (Primaria) varchar(64) No
ENABLED enum('YES', 'NO') No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No NAME No

setup_instruments

Columna Tipo Nulo Predeterminado Comentarios
NAME (Primaria) varchar(128) No
ENABLED enum('YES', 'NO') No
TIMED enum('YES', 'NO') Sí NULL
PROPERTIES set('singleton', 'progress', 'user', 'global_statistics', 'mutable') No
VOLATILITY int(11) No
DOCUMENTATION longtext Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No NAME No

setup_objects

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'TRIGGER') No TABLE
OBJECT_SCHEMA varchar(64) Sí %
OBJECT_NAME varchar(64) No %
ENABLED enum('YES', 'NO') No YES
TIMED enum('YES', 'NO') No YES

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
OBJECT HASH Sí No OBJECT_TYPE No
OBJECT_SCHEMA Sí
OBJECT_NAME No

setup_threads

Columna Tipo Nulo Predeterminado Comentarios
NAME (Primaria) varchar(128) No
ENABLED enum('YES', 'NO') No
HISTORY enum('YES', 'NO') No
PROPERTIES set('singleton', 'user') No
VOLATILITY int(11) No
DOCUMENTATION longtext Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No NAME No

socket_instances

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
THREAD_ID bigint(20) Sí NULL
SOCKET_ID int(11) No
IP varchar(64) No
PORT int(11) No
STATE enum('IDLE', 'ACTIVE') No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
THREAD_ID HASH No No THREAD_ID Sí
SOCKET_ID HASH No No SOCKET_ID No
IP HASH No No IP No
PORT No

socket_summary_by_event_name

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME (Primaria) varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No EVENT_NAME No

socket_summary_by_instance

Columna Tipo Nulo Predeterminado Comentarios
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
EVENT_NAME HASH No No EVENT_NAME No

status_by_account

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
HOST char(255) Sí NULL
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
ACCOUNT HASH Sí No USER Sí
HOST Sí
VARIABLE_NAME No

status_by_host

Columna Tipo Nulo Predeterminado Comentarios
HOST char(255) Sí NULL
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
HOST HASH Sí No HOST Sí
VARIABLE_NAME No

status_by_thread

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
VARIABLE_NAME No

status_by_user

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí
VARIABLE_NAME No

table_handles

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) No
OBJECT_SCHEMA varchar(64) No
OBJECT_NAME varchar(64) No
OBJECT_INSTANCE_BEGIN (Primaria) bigint(20) No
OWNER_THREAD_ID bigint(20) Sí NULL
OWNER_EVENT_ID bigint(20) Sí NULL
INTERNAL_LOCK varchar(64) Sí NULL
EXTERNAL_LOCK varchar(64) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No OBJECT_INSTANCE_BEGIN No
OBJECT_TYPE HASH No No OBJECT_TYPE No
OBJECT_SCHEMA No
OBJECT_NAME No
OWNER_THREAD_ID HASH No No OWNER_THREAD_ID Sí
OWNER_EVENT_ID Sí

table_io_waits_summary_by_index_usage

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
INDEX_NAME varchar(64) Sí NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_FETCH bigint(20) No
SUM_TIMER_FETCH bigint(20) No
MIN_TIMER_FETCH bigint(20) No
AVG_TIMER_FETCH bigint(20) No
MAX_TIMER_FETCH bigint(20) No
COUNT_INSERT bigint(20) No
SUM_TIMER_INSERT bigint(20) No
MIN_TIMER_INSERT bigint(20) No
AVG_TIMER_INSERT bigint(20) No
MAX_TIMER_INSERT bigint(20) No
COUNT_UPDATE bigint(20) No
SUM_TIMER_UPDATE bigint(20) No
MIN_TIMER_UPDATE bigint(20) No
AVG_TIMER_UPDATE bigint(20) No
MAX_TIMER_UPDATE bigint(20) No
COUNT_DELETE bigint(20) No
SUM_TIMER_DELETE bigint(20) No
MIN_TIMER_DELETE bigint(20) No
AVG_TIMER_DELETE bigint(20) No
MAX_TIMER_DELETE bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
OBJECT HASH Sí No OBJECT_TYPE Sí
OBJECT_SCHEMA Sí
OBJECT_NAME Sí
INDEX_NAME Sí

table_io_waits_summary_by_table

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_FETCH bigint(20) No
SUM_TIMER_FETCH bigint(20) No
MIN_TIMER_FETCH bigint(20) No
AVG_TIMER_FETCH bigint(20) No
MAX_TIMER_FETCH bigint(20) No
COUNT_INSERT bigint(20) No
SUM_TIMER_INSERT bigint(20) No
MIN_TIMER_INSERT bigint(20) No
AVG_TIMER_INSERT bigint(20) No
MAX_TIMER_INSERT bigint(20) No
COUNT_UPDATE bigint(20) No
SUM_TIMER_UPDATE bigint(20) No
MIN_TIMER_UPDATE bigint(20) No
AVG_TIMER_UPDATE bigint(20) No
MAX_TIMER_UPDATE bigint(20) No
COUNT_DELETE bigint(20) No
SUM_TIMER_DELETE bigint(20) No
MIN_TIMER_DELETE bigint(20) No
AVG_TIMER_DELETE bigint(20) No
MAX_TIMER_DELETE bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
OBJECT HASH Sí No OBJECT_TYPE Sí
OBJECT_SCHEMA Sí
OBJECT_NAME Sí

table_lock_waits_summary_by_table

Columna Tipo Nulo Predeterminado Comentarios
OBJECT_TYPE varchar(64) Sí NULL
OBJECT_SCHEMA varchar(64) Sí NULL
OBJECT_NAME varchar(64) Sí NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_READ_NORMAL bigint(20) No
SUM_TIMER_READ_NORMAL bigint(20) No
MIN_TIMER_READ_NORMAL bigint(20) No
AVG_TIMER_READ_NORMAL bigint(20) No
MAX_TIMER_READ_NORMAL bigint(20) No
COUNT_READ_WITH_SHARED_LOCKS bigint(20) No
SUM_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
MIN_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
AVG_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
MAX_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
COUNT_READ_HIGH_PRIORITY bigint(20) No
SUM_TIMER_READ_HIGH_PRIORITY bigint(20) No
MIN_TIMER_READ_HIGH_PRIORITY bigint(20) No
AVG_TIMER_READ_HIGH_PRIORITY bigint(20) No
MAX_TIMER_READ_HIGH_PRIORITY bigint(20) No
COUNT_READ_NO_INSERT bigint(20) No
SUM_TIMER_READ_NO_INSERT bigint(20) No
MIN_TIMER_READ_NO_INSERT bigint(20) No
AVG_TIMER_READ_NO_INSERT bigint(20) No
MAX_TIMER_READ_NO_INSERT bigint(20) No
COUNT_READ_EXTERNAL bigint(20) No
SUM_TIMER_READ_EXTERNAL bigint(20) No
MIN_TIMER_READ_EXTERNAL bigint(20) No
AVG_TIMER_READ_EXTERNAL bigint(20) No
MAX_TIMER_READ_EXTERNAL bigint(20) No
COUNT_WRITE_ALLOW_WRITE bigint(20) No
SUM_TIMER_WRITE_ALLOW_WRITE bigint(20) No
MIN_TIMER_WRITE_ALLOW_WRITE bigint(20) No
AVG_TIMER_WRITE_ALLOW_WRITE bigint(20) No
MAX_TIMER_WRITE_ALLOW_WRITE bigint(20) No
COUNT_WRITE_CONCURRENT_INSERT bigint(20) No
SUM_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
MIN_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
AVG_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
MAX_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
COUNT_WRITE_LOW_PRIORITY bigint(20) No
SUM_TIMER_WRITE_LOW_PRIORITY bigint(20) No
MIN_TIMER_WRITE_LOW_PRIORITY bigint(20) No
AVG_TIMER_WRITE_LOW_PRIORITY bigint(20) No
MAX_TIMER_WRITE_LOW_PRIORITY bigint(20) No
COUNT_WRITE_NORMAL bigint(20) No
SUM_TIMER_WRITE_NORMAL bigint(20) No
MIN_TIMER_WRITE_NORMAL bigint(20) No
AVG_TIMER_WRITE_NORMAL bigint(20) No
MAX_TIMER_WRITE_NORMAL bigint(20) No
COUNT_WRITE_EXTERNAL bigint(20) No
SUM_TIMER_WRITE_EXTERNAL bigint(20) No
MIN_TIMER_WRITE_EXTERNAL bigint(20) No
AVG_TIMER_WRITE_EXTERNAL bigint(20) No
MAX_TIMER_WRITE_EXTERNAL bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
OBJECT HASH Sí No OBJECT_TYPE Sí
OBJECT_SCHEMA Sí
OBJECT_NAME Sí

threads

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
NAME varchar(128) No
TYPE varchar(10) No
PROCESSLIST_ID bigint(20) Sí NULL
PROCESSLIST_USER varchar(32) Sí NULL
PROCESSLIST_HOST varchar(255) Sí NULL
PROCESSLIST_DB varchar(64) Sí NULL
PROCESSLIST_COMMAND varchar(16) Sí NULL
PROCESSLIST_TIME bigint(20) Sí NULL
PROCESSLIST_STATE varchar(64) Sí NULL
PROCESSLIST_INFO longtext Sí NULL
PARENT_THREAD_ID bigint(20) Sí NULL
ROLE varchar(64) Sí NULL
INSTRUMENTED enum('YES', 'NO') No
HISTORY enum('YES', 'NO') No
CONNECTION_TYPE varchar(16) Sí NULL
THREAD_OS_ID bigint(20) Sí NULL
RESOURCE_GROUP varchar(64) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
PROCESSLIST_ID HASH No No PROCESSLIST_ID Sí
THREAD_OS_ID HASH No No THREAD_OS_ID Sí
NAME HASH No No NAME No
PROCESSLIST_ACCOUNT HASH No No PROCESSLIST_USER Sí
PROCESSLIST_HOST Sí
PROCESSLIST_HOST HASH No No PROCESSLIST_HOST Sí
RESOURCE_GROUP HASH No No RESOURCE_GROUP Sí

users

Columna Tipo Nulo Predeterminado Comentarios
USER char(32) Sí NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
USER HASH Sí No USER Sí

user_defined_functions

Columna Tipo Nulo Predeterminado Comentarios
UDF_NAME (Primaria) varchar(64) No
UDF_RETURN_TYPE varchar(20) No
UDF_TYPE varchar(20) No
UDF_LIBRARY varchar(1024) Sí NULL
UDF_USAGE_COUNT bigint(20) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No UDF_NAME No

user_variables_by_thread

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE longblob Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
VARIABLE_NAME No

variables_by_thread

Columna Tipo Nulo Predeterminado Comentarios
THREAD_ID (Primaria) bigint(20) No
VARIABLE_NAME (Primaria) varchar(64) No
VARIABLE_VALUE varchar(1024) Sí NULL

Índices

Nombre de la clave Tipo Único Empaquetado Columna Cardinalidad Cotejamiento Nulo Comentario
PRIMARY HASH Sí No THREAD_ID No
VARIABLE_NAME No

variables_info

Columna Tipo Nulo Predeterminado Comentarios
VARIABLE_NAME varchar(64) No
VARIABLE_SOURCE enum('COMPILED', 'GLOBAL', 'SERVER', 'EXPLICIT', 'EXTRA', 'USER', 'LOGIN', 'COMMAND_LINE', 'PERSISTED', 'DYNAMIC') Sí COMPILED
VARIABLE_PATH varchar(1024) Sí NULL
MIN_VALUE varchar(64) Sí NULL
MAX_VALUE varchar(64) Sí NULL
SET_TIME timestamp(6) Sí NULL
SET_USER char(32) Sí NULL
SET_HOST char(255) Sí NULL

¡No se ha definido ningún índice!