Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Paramètres relatifs à la page Cliquer sur la barre pour faire défiler en haut de page
Faire Ctrl+Entrée pour exécuter la requête Faire Entrée pour exécuter la requête
croissant
décroissant
Ordre :
Déboguer SQL
Nombre
Ordre d'exécution
Temps nécessaire
Trier par :
Regrouper les requêtes
Dissocier les groupes
Réduire Développer Afficher le suivi Masquer le suivi Nombre : Temps nécessaire :
Signets
Actualiser
Ajouter
Aucun signet
Ajouter un signet
Options
Définir par défaut





Réduire Développer Exécuter la requête à nouveau Éditer Expliquer Profilage Signet La requête a échoué Base de données : Daté du :
Personnaliser le mode affichage.
Mode de navigation
Documentation Afficher seulement des icônes, seulement du texte ou les deux. Restaurer la valeur par défaut
Documentation Afficher seulement des icônes, seulement du texte ou les deux. Restaurer la valeur par défaut
Documentation Si un bouton « Tout afficher » devrait être affiché. Restaurer la valeur par défaut
Documentation Nombre de colonnes affichées lors du parcours d'un ensemble de résultats. Si le nombre de colonnes est supérieur, des liens « Suivant » et « Précédent » seront affichés. Restaurer la valeur par défaut
Documentation SMART signifie un ordre décroissant pour les colonnes TIME, DATE, DATETIME et TIMESTAMP, et croissant pour les autres. Restaurer la valeur par défaut
Documentation Mettre en surbrillance la ligne sur laquelle pointe la souris. Restaurer la valeur par défaut
Documentation Mettre en surbrillance les lignes sélectionnées. Restaurer la valeur par défaut
Documentation Restaurer la valeur par défaut
Documentation Restaurer la valeur par défaut
Documentation Répète les entêtes toutes les X cellules, 0 désactive ceci. Restaurer la valeur par défaut
Documentation Nombre maximum de caractères affichés dans toute colonne non numérique en vue parcourir. Restaurer la valeur par défaut
Documentation Il s'agit des liens Éditer, Copier et Supprimer. Restaurer la valeur par défaut
Documentation Pour afficher les liens de la ligne même en l'absence d'une clé unique. Restaurer la valeur par défaut
Documentation Ordre de tri par défaut pour les tables comportant une clé primaire. Restaurer la valeur par défaut
Documentation En affichant les tables, l'ordre de tri de chaque table est mémorisé. Restaurer la valeur par défaut
Documentation Pour les options d'affichage Restaurer la valeur par défaut 
SELECT * FROM `STATISTICS`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
|
Filtrer les lignes:
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION
def mysql innodb_table_stats 0 mysql PRIMARY 1 database_name A 4 NULL NULL BTREE YES NULL
def mysql innodb_table_stats 0 mysql PRIMARY 2 table_name A 53 NULL NULL BTREE YES NULL
def mysql innodb_index_stats 0 mysql PRIMARY 1 database_name A 4 NULL NULL BTREE YES NULL
def mysql innodb_index_stats 0 mysql PRIMARY 2 table_name A 58 NULL NULL BTREE YES NULL
def mysql innodb_index_stats 0 mysql PRIMARY 3 index_name A 131 NULL NULL BTREE YES NULL
def mysql innodb_index_stats 0 mysql PRIMARY 4 stat_name A 557 NULL NULL BTREE YES NULL
def performance_schema cond_instances 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema cond_instances 1 performance_schema NAME 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema error_log 0 performance_schema PRIMARY 1 LOGGED NULL NULL NULL NULL HASH YES NULL
def performance_schema error_log 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema error_log 1 performance_schema PRIO 1 PRIO NULL NULL NULL NULL HASH YES NULL
def performance_schema error_log 1 performance_schema ERROR_CODE 1 ERROR_CODE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema error_log 1 performance_schema SUBSYSTEM 1 SUBSYSTEM NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_waits_current 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_current 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_history 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_history 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_host_by_event_name 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_waits_summary_by_host_by_event_name 0 performance_schema HOST 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_instance 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_instance 1 performance_schema EVENT_NAME 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_thread_by_event_name 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_thread_by_event_name 0 performance_schema PRIMARY 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_user_by_event_name 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_waits_summary_by_user_by_event_name 0 performance_schema USER 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_by_account_by_event_name 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_waits_summary_by_account_by_event_name 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_waits_summary_by_account_by_event_name 0 performance_schema ACCOUNT 3 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_waits_summary_global_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema file_instances 0 performance_schema PRIMARY 1 FILE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema file_instances 1 performance_schema EVENT_NAME 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema file_summary_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema file_summary_by_instance 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema file_summary_by_instance 1 performance_schema FILE_NAME 1 FILE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema file_summary_by_instance 1 performance_schema EVENT_NAME 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema host_cache 0 performance_schema PRIMARY 1 IP NULL NULL NULL NULL HASH YES NULL
def performance_schema host_cache 1 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema mutex_instances 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema mutex_instances 1 performance_schema NAME 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema mutex_instances 1 performance_schema LOCKED_BY_THREAD_ID 1 LOCKED_BY_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema objects_summary_global_by_type 0 performance_schema OBJECT 1 OBJECT_TYPE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema objects_summary_global_by_type 0 performance_schema OBJECT 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema objects_summary_global_by_type 0 performance_schema OBJECT 3 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema processlist 0 performance_schema PRIMARY 1 ID NULL NULL NULL NULL HASH YES NULL
def performance_schema rwlock_instances 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema rwlock_instances 1 performance_schema NAME 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema rwlock_instances 1 performance_schema WRITE_LOCKED_BY_THREAD_ID 1 WRITE_LOCKED_BY_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema setup_actors 0 performance_schema PRIMARY 1 HOST NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_actors 0 performance_schema PRIMARY 2 USER NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_actors 0 performance_schema PRIMARY 3 ROLE NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_consumers 0 performance_schema PRIMARY 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_instruments 0 performance_schema PRIMARY 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_meters 0 performance_schema PRIMARY 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_metrics 0 performance_schema PRIMARY 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_objects 0 performance_schema OBJECT 1 OBJECT_TYPE NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_objects 0 performance_schema OBJECT 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema setup_objects 0 performance_schema OBJECT 3 OBJECT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema setup_threads 0 performance_schema PRIMARY 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema table_io_waits_summary_by_index_usage 0 performance_schema OBJECT 1 OBJECT_TYPE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_index_usage 0 performance_schema OBJECT 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_index_usage 0 performance_schema OBJECT 3 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_index_usage 0 performance_schema OBJECT 4 INDEX_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_table 0 performance_schema OBJECT 1 OBJECT_TYPE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_table 0 performance_schema OBJECT 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_io_waits_summary_by_table 0 performance_schema OBJECT 3 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_lock_waits_summary_by_table 0 performance_schema OBJECT 1 OBJECT_TYPE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_lock_waits_summary_by_table 0 performance_schema OBJECT 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_lock_waits_summary_by_table 0 performance_schema OBJECT 3 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema threads 1 performance_schema PROCESSLIST_ID 1 PROCESSLIST_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 1 performance_schema THREAD_OS_ID 1 THREAD_OS_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 1 performance_schema NAME 1 NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema threads 1 performance_schema PROCESSLIST_ACCOUNT 1 PROCESSLIST_USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 1 performance_schema PROCESSLIST_ACCOUNT 2 PROCESSLIST_HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 1 performance_schema PROCESSLIST_HOST 1 PROCESSLIST_HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema threads 1 performance_schema RESOURCE_GROUP 1 RESOURCE_GROUP NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_stages_current 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_current 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_history 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_history 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_by_thread_by_event_name 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_by_thread_by_event_name 0 performance_schema PRIMARY 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_by_account_by_event_name 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_stages_summary_by_account_by_event_name 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_stages_summary_by_account_by_event_name 0 performance_schema ACCOUNT 3 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_by_user_by_event_name 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_stages_summary_by_user_by_event_name 0 performance_schema USER 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_by_host_by_event_name 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_stages_summary_by_host_by_event_name 0 performance_schema HOST 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_stages_summary_global_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_current 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_current 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_history 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_history 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_thread_by_event_name 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_thread_by_event_name 0 performance_schema PRIMARY 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_account_by_event_name 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_summary_by_account_by_event_name 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_summary_by_account_by_event_name 0 performance_schema ACCOUNT 3 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_user_by_event_name 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION  
def performance_schema events_statements_summary_by_user_by_event_name 0 performance_schema USER 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_host_by_event_name 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_summary_by_host_by_event_name 0 performance_schema HOST 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_global_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_digest 0 performance_schema SCHEMA_NAME 1 SCHEMA_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_summary_by_digest 0 performance_schema SCHEMA_NAME 2 DIGEST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_summary_by_program 0 performance_schema PRIMARY 1 OBJECT_TYPE NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_program 0 performance_schema PRIMARY 2 OBJECT_SCHEMA NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_summary_by_program 0 performance_schema PRIMARY 3 OBJECT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_histogram_global 0 performance_schema PRIMARY 1 BUCKET_NUMBER NULL NULL NULL NULL HASH YES NULL
def performance_schema events_statements_histogram_by_digest 0 performance_schema SCHEMA_NAME 1 SCHEMA_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_histogram_by_digest 0 performance_schema SCHEMA_NAME 2 DIGEST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_statements_histogram_by_digest 0 performance_schema SCHEMA_NAME 3 BUCKET_NUMBER NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_current 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_current 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_history 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_history 0 performance_schema PRIMARY 2 EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_by_thread_by_event_name 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_by_thread_by_event_name 0 performance_schema PRIMARY 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_by_account_by_event_name 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_transactions_summary_by_account_by_event_name 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_transactions_summary_by_account_by_event_name 0 performance_schema ACCOUNT 3 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_by_user_by_event_name 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_transactions_summary_by_user_by_event_name 0 performance_schema USER 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_by_host_by_event_name 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_transactions_summary_by_host_by_event_name 0 performance_schema HOST 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_transactions_summary_global_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema events_errors_summary_by_user_by_error 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_user_by_error 0 performance_schema USER 2 ERROR_NUMBER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_host_by_error 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_host_by_error 0 performance_schema HOST 2 ERROR_NUMBER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_account_by_error 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_account_by_error 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_account_by_error 0 performance_schema ACCOUNT 3 ERROR_NUMBER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_by_thread_by_error 0 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema events_errors_summary_by_thread_by_error 0 performance_schema THREAD_ID 2 ERROR_NUMBER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema events_errors_summary_global_by_error 0 performance_schema ERROR_NUMBER 1 ERROR_NUMBER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema users 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema accounts 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema accounts 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema hosts 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema socket_instances 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_instances 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema socket_instances 1 performance_schema SOCKET_ID 1 SOCKET_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_instances 1 performance_schema IP 1 IP NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_instances 1 performance_schema IP 2 PORT NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_summary_by_instance 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_summary_by_instance 1 performance_schema EVENT_NAME 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema socket_summary_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema session_connect_attrs 0 performance_schema PRIMARY 1 PROCESSLIST_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema session_connect_attrs 0 performance_schema PRIMARY 2 ATTR_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema session_account_connect_attrs 0 performance_schema PRIMARY 1 PROCESSLIST_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema session_account_connect_attrs 0 performance_schema PRIMARY 2 ATTR_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_global_by_event_name 0 performance_schema PRIMARY 1 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_by_account_by_event_name 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema memory_summary_by_account_by_event_name 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema memory_summary_by_account_by_event_name 0 performance_schema ACCOUNT 3 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_by_host_by_event_name 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema memory_summary_by_host_by_event_name 0 performance_schema HOST 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_by_thread_by_event_name 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_by_thread_by_event_name 0 performance_schema PRIMARY 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema memory_summary_by_user_by_event_name 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema memory_summary_by_user_by_event_name 0 performance_schema USER 2 EVENT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema table_handles 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema table_handles 1 performance_schema OBJECT_TYPE 1 OBJECT_TYPE NULL NULL NULL NULL HASH YES NULL
def performance_schema table_handles 1 performance_schema OBJECT_TYPE 2 OBJECT_SCHEMA NULL NULL NULL NULL HASH YES NULL
def performance_schema table_handles 1 performance_schema OBJECT_TYPE 3 OBJECT_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema table_handles 1 performance_schema OWNER_THREAD_ID 1 OWNER_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema table_handles 1 performance_schema OWNER_THREAD_ID 2 OWNER_EVENT_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema metadata_locks 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OBJECT_TYPE 1 OBJECT_TYPE NULL NULL NULL NULL HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OBJECT_TYPE 2 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OBJECT_TYPE 3 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OBJECT_TYPE 4 COLUMN_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OWNER_THREAD_ID 1 OWNER_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema metadata_locks 1 performance_schema OWNER_THREAD_ID 2 OWNER_EVENT_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 0 performance_schema PRIMARY 1 ENGINE_LOCK_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema data_locks 0 performance_schema PRIMARY 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_locks 1 performance_schema ENGINE_TRANSACTION_ID 1 ENGINE_TRANSACTION_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema ENGINE_TRANSACTION_ID 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_locks 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema THREAD_ID 2 EVENT_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema OBJECT_SCHEMA 1 OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema OBJECT_SCHEMA 2 OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema OBJECT_SCHEMA 3 PARTITION_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_locks 1 performance_schema OBJECT_SCHEMA 4 SUBPARTITION_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_ENGINE_LOCK_ID 1 REQUESTING_ENGINE_LOCK_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_ENGINE_LOCK_ID 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_ENGINE_LOCK_ID 1 BLOCKING_ENGINE_LOCK_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_ENGINE_LOCK_ID 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_ENGINE_TRANSACTION_ID 1 REQUESTING_ENGINE_TRANSACTION_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_ENGINE_TRANSACTION_ID 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_ENGINE_TRANSACTION_ID 1 BLOCKING_ENGINE_TRANSACTION_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_ENGINE_TRANSACTION_ID 2 ENGINE NULL NULL NULL NULL HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_THREAD_ID 1 REQUESTING_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema REQUESTING_THREAD_ID 2 REQUESTING_EVENT_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_THREAD_ID 1 BLOCKING_THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema data_lock_waits 1 performance_schema BLOCKING_THREAD_ID 2 BLOCKING_EVENT_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema replication_connection_configuration 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_connection_status 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION  
def performance_schema replication_connection_status 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema replication_applier_configuration 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_applier_status 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_applier_status_by_coordinator 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_applier_status_by_coordinator 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema replication_applier_status_by_worker 0 performance_schema PRIMARY 1 CHANNEL_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_applier_status_by_worker 0 performance_schema PRIMARY 2 WORKER_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema replication_applier_status_by_worker 1 performance_schema THREAD_ID 1 THREAD_ID NULL NULL NULL NULL YES HASH YES NULL
def performance_schema prepared_statements_instances 0 performance_schema PRIMARY 1 OBJECT_INSTANCE_BEGIN NULL NULL NULL NULL HASH YES NULL
def performance_schema prepared_statements_instances 0 performance_schema OWNER_THREAD_ID 1 OWNER_THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema prepared_statements_instances 0 performance_schema OWNER_THREAD_ID 2 OWNER_EVENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema prepared_statements_instances 1 performance_schema STATEMENT_ID 1 STATEMENT_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema prepared_statements_instances 1 performance_schema STATEMENT_NAME 1 STATEMENT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema prepared_statements_instances 1 performance_schema OWNER_OBJECT_TYPE 1 OWNER_OBJECT_TYPE NULL NULL NULL NULL YES HASH YES NULL
def performance_schema prepared_statements_instances 1 performance_schema OWNER_OBJECT_TYPE 2 OWNER_OBJECT_SCHEMA NULL NULL NULL NULL YES HASH YES NULL
def performance_schema prepared_statements_instances 1 performance_schema OWNER_OBJECT_TYPE 3 OWNER_OBJECT_NAME NULL NULL NULL NULL YES HASH YES NULL
def performance_schema user_variables_by_thread 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema user_variables_by_thread 0 performance_schema PRIMARY 2 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema status_by_account 0 performance_schema ACCOUNT 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema status_by_account 0 performance_schema ACCOUNT 2 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema status_by_account 0 performance_schema ACCOUNT 3 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema status_by_host 0 performance_schema HOST 1 HOST NULL NULL NULL NULL YES HASH YES NULL
def performance_schema status_by_host 0 performance_schema HOST 2 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema status_by_thread 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema status_by_thread 0 performance_schema PRIMARY 2 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema status_by_user 0 performance_schema USER 1 USER NULL NULL NULL NULL YES HASH YES NULL
def performance_schema status_by_user 0 performance_schema USER 2 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema global_status 0 performance_schema PRIMARY 1 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema session_status 0 performance_schema PRIMARY 1 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema variables_by_thread 0 performance_schema PRIMARY 1 THREAD_ID NULL NULL NULL NULL HASH YES NULL
def performance_schema variables_by_thread 0 performance_schema PRIMARY 2 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema global_variables 0 performance_schema PRIMARY 1 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema session_variables 0 performance_schema PRIMARY 1 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema persisted_variables 0 performance_schema PRIMARY 1 VARIABLE_NAME NULL NULL NULL NULL HASH YES NULL
def performance_schema user_defined_functions 0 performance_schema PRIMARY 1 UDF_NAME NULL NULL NULL NULL HASH YES NULL
def mysql db 0 mysql PRIMARY 1 Host A 1 NULL NULL BTREE YES NULL
def mysql db 0 mysql PRIMARY 2 User A 2 NULL NULL BTREE YES NULL
def mysql db 0 mysql PRIMARY 3 Db A 2 NULL NULL BTREE YES NULL
def mysql db 1 mysql User 1 User A 2 NULL NULL BTREE YES NULL
def mysql user 0 mysql PRIMARY 1 Host A 1 NULL NULL BTREE YES NULL
def mysql user 0 mysql PRIMARY 2 User A 5 NULL NULL BTREE YES NULL
def mysql default_roles 0 mysql PRIMARY 1 HOST A 0 NULL NULL BTREE YES NULL
def mysql default_roles 0 mysql PRIMARY 2 USER A 0 NULL NULL BTREE YES NULL
def mysql default_roles 0 mysql PRIMARY 3 DEFAULT_ROLE_HOST A 0 NULL NULL BTREE YES NULL
def mysql default_roles 0 mysql PRIMARY 4 DEFAULT_ROLE_USER A 0 NULL NULL BTREE YES NULL
def mysql role_edges 0 mysql PRIMARY 1 FROM_HOST A 0 NULL NULL BTREE YES NULL
def mysql role_edges 0 mysql PRIMARY 2 FROM_USER A 0 NULL NULL BTREE YES NULL
def mysql role_edges 0 mysql PRIMARY 3 TO_HOST A 0 NULL NULL BTREE YES NULL
def mysql role_edges 0 mysql PRIMARY 4 TO_USER A 0 NULL NULL BTREE YES NULL
def mysql global_grants 0 mysql PRIMARY 1 USER A 7 NULL NULL BTREE YES NULL
def mysql global_grants 0 mysql PRIMARY 2 HOST A 7 NULL NULL BTREE YES NULL
def mysql global_grants 0 mysql PRIMARY 3 PRIV A 59 NULL NULL BTREE YES NULL
def mysql password_history 0 mysql PRIMARY 1 Host A 0 NULL NULL BTREE YES NULL
def mysql password_history 0 mysql PRIMARY 2 User A 0 NULL NULL BTREE YES NULL
def mysql password_history 0 mysql PRIMARY 3 Password_timestamp D 0 NULL NULL BTREE YES NULL
def mysql func 0 mysql PRIMARY 1 name A 0 NULL NULL BTREE YES NULL
def mysql plugin 0 mysql PRIMARY 1 name A 0 NULL NULL BTREE YES NULL
def mysql help_topic 0 mysql PRIMARY 1 help_topic_id A 506 NULL NULL BTREE YES NULL
def mysql help_topic 0 mysql name 1 name A 506 NULL NULL BTREE YES NULL
def mysql help_category 0 mysql PRIMARY 1 help_category_id A 53 NULL NULL BTREE YES NULL
def mysql help_category 0 mysql name 1 name A 53 NULL NULL BTREE YES NULL
def mysql help_relation 0 mysql PRIMARY 1 help_keyword_id A 886 NULL NULL BTREE YES NULL
def mysql help_relation 0 mysql PRIMARY 2 help_topic_id A 2181 NULL NULL BTREE YES NULL
def mysql servers 0 mysql PRIMARY 1 Server_name A 0 NULL NULL BTREE YES NULL
def mysql tables_priv 0 mysql PRIMARY 1 Host A 1 NULL NULL BTREE YES NULL
def mysql tables_priv 0 mysql PRIMARY 2 User A 2 NULL NULL BTREE YES NULL
def mysql tables_priv 0 mysql PRIMARY 3 Db A 2 NULL NULL BTREE YES NULL
def mysql tables_priv 0 mysql PRIMARY 4 Table_name A 2 NULL NULL BTREE YES NULL
def mysql tables_priv 1 mysql Grantor 1 Grantor A 2 NULL NULL BTREE YES NULL
def mysql columns_priv 0 mysql PRIMARY 1 Host A 0 NULL NULL BTREE YES NULL
def mysql columns_priv 0 mysql PRIMARY 2 User A 0 NULL NULL BTREE YES NULL
def mysql columns_priv 0 mysql PRIMARY 3 Db A 0 NULL NULL BTREE YES NULL
def mysql columns_priv 0 mysql PRIMARY 4 Table_name A 0 NULL NULL BTREE YES NULL
def mysql columns_priv 0 mysql PRIMARY 5 Column_name A 0 NULL NULL BTREE YES NULL
def mysql help_keyword 0 mysql PRIMARY 1 help_keyword_id A 934 NULL NULL BTREE YES NULL
def mysql help_keyword 0 mysql name 1 name A 889 NULL NULL BTREE YES NULL
def mysql time_zone_name 0 mysql PRIMARY 1 Name A 0 NULL NULL BTREE YES NULL
def mysql time_zone 0 mysql PRIMARY 1 Time_zone_id A 0 NULL NULL BTREE YES NULL
def mysql time_zone_transition 0 mysql PRIMARY 1 Time_zone_id A 0 NULL NULL BTREE YES NULL
def mysql time_zone_transition 0 mysql PRIMARY 2 Transition_time A 0 NULL NULL BTREE YES NULL
def mysql time_zone_transition_type 0 mysql PRIMARY 1 Time_zone_id A 0 NULL NULL BTREE YES NULL
def mysql time_zone_transition_type 0 mysql PRIMARY 2 Transition_type_id A 0 NULL NULL BTREE YES NULL
def mysql time_zone_leap_second 0 mysql PRIMARY 1 Transition_time A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 0 mysql PRIMARY 1 Host A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 0 mysql PRIMARY 2 User A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 0 mysql PRIMARY 3 Db A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 0 mysql PRIMARY 4 Routine_name A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 0 mysql PRIMARY 5 Routine_type A 0 NULL NULL BTREE YES NULL
def mysql procs_priv 1 mysql Grantor 1 Grantor A 0 NULL NULL BTREE YES NULL
def mysql component 0 mysql PRIMARY 1 component_id A 0 NULL NULL BTREE YES NULL
def mysql slave_relay_log_info 0 mysql PRIMARY 1 Channel_name A 0 NULL NULL BTREE YES NULL
def mysql slave_master_info 0 mysql PRIMARY 1 Channel_name A 0 NULL NULL BTREE YES NULL
def mysql slave_worker_info 0 mysql PRIMARY 1 Channel_name A 0 NULL NULL BTREE YES NULL
def mysql slave_worker_info 0 mysql PRIMARY 2 Id A 0 NULL NULL BTREE YES NULL
def mysql gtid_executed 0 mysql PRIMARY 1 source_uuid A 0 NULL NULL BTREE YES NULL
def mysql gtid_executed 0 mysql PRIMARY 2 interval_start A 0 NULL NULL BTREE YES NULL
def mysql replication_asynchronous_connection_failover 0 mysql PRIMARY 1 Channel_name A 0 NULL NULL BTREE YES NULL
def mysql replication_asynchronous_connection_failover 0 mysql PRIMARY 2 Host A 0 NULL NULL BTREE YES NULL
def mysql replication_asynchronous_connection_failover 0 mysql PRIMARY 3 Port A 0 NULL NULL BTREE YES NULL
def mysql replication_asynchronous_connection_failover 0 mysql PRIMARY 4 Network_namespace A 0 NULL NULL BTREE YES NULL
|
|
|
|
Filtrer les lignes:
Opérations sur les résultats de la requête Copier dans le presse-papiers Copier dans le presse-papiers Exporter Exporter Afficher le graphique Afficher le graphique Créer une vue Créer une vue
Conserver cette requête SQL dans les signets Conserver cette requête SQL dans les signets