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 `VIEW_TABLE_USAGE`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
Filtrer les lignes:
VIEW_CATALOG VIEW_SCHEMA VIEW_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME
def sys innodb_buffer_stats_by_schema def information_schema INNODB_BUFFER_PAGE
def sys x$innodb_buffer_stats_by_schema def information_schema INNODB_BUFFER_PAGE
def sys innodb_buffer_stats_by_table def information_schema INNODB_BUFFER_PAGE
def sys x$innodb_buffer_stats_by_table def information_schema INNODB_BUFFER_PAGE
def sys schema_object_overview def information_schema EVENTS
def sys schema_object_overview def information_schema ROUTINES
def sys schema_object_overview def information_schema STATISTICS
def sys schema_object_overview def information_schema TABLES
def sys schema_object_overview def information_schema TRIGGERS
def sys schema_auto_increment_columns def information_schema COLUMNS
def sys schema_auto_increment_columns def information_schema TABLES
def sys x$schema_flattened_keys def information_schema STATISTICS
def sys schema_redundant_indexes def sys x$schema_flattened_keys
def sys ps_check_lost_instrumentation def performance_schema global_status
def sys latest_file_io def information_schema PROCESSLIST
def sys latest_file_io def performance_schema events_waits_history_long
def sys latest_file_io def performance_schema global_variables
def sys latest_file_io def performance_schema threads
def sys x$latest_file_io def information_schema PROCESSLIST
def sys x$latest_file_io def performance_schema events_waits_history_long
def sys x$latest_file_io def performance_schema threads
def sys io_by_thread_by_latency def performance_schema events_waits_summary_by_thread_by_event_name
def sys io_by_thread_by_latency def performance_schema threads
def sys x$io_by_thread_by_latency def performance_schema events_waits_summary_by_thread_by_event_name
def sys x$io_by_thread_by_latency def performance_schema threads
def sys io_global_by_file_by_bytes def performance_schema file_summary_by_instance
def sys io_global_by_file_by_bytes def performance_schema global_variables
def sys x$io_global_by_file_by_bytes def performance_schema file_summary_by_instance
def sys io_global_by_file_by_latency def performance_schema file_summary_by_instance
def sys io_global_by_file_by_latency def performance_schema global_variables
def sys x$io_global_by_file_by_latency def performance_schema file_summary_by_instance
def sys io_global_by_wait_by_bytes def performance_schema file_summary_by_event_name
def sys x$io_global_by_wait_by_bytes def performance_schema file_summary_by_event_name
def sys io_global_by_wait_by_latency def performance_schema file_summary_by_event_name
def sys x$io_global_by_wait_by_latency def performance_schema file_summary_by_event_name
def sys innodb_lock_waits def information_schema INNODB_TRX
def sys innodb_lock_waits def performance_schema data_lock_waits
def sys innodb_lock_waits def performance_schema data_locks
def sys innodb_lock_waits def sys sys_config
def sys x$innodb_lock_waits def information_schema INNODB_TRX
def sys x$innodb_lock_waits def performance_schema data_lock_waits
def sys x$innodb_lock_waits def performance_schema data_locks
def sys memory_by_user_by_current_bytes def performance_schema memory_summary_by_user_by_event_name
def sys x$memory_by_user_by_current_bytes def performance_schema memory_summary_by_user_by_event_name
def sys memory_by_host_by_current_bytes def performance_schema memory_summary_by_host_by_event_name
def sys x$memory_by_host_by_current_bytes def performance_schema memory_summary_by_host_by_event_name
def sys memory_by_thread_by_current_bytes def performance_schema memory_summary_by_thread_by_event_name
def sys memory_by_thread_by_current_bytes def performance_schema threads
def sys x$memory_by_thread_by_current_bytes def performance_schema memory_summary_by_thread_by_event_name
def sys x$memory_by_thread_by_current_bytes def performance_schema threads
def sys memory_global_by_current_bytes def performance_schema memory_summary_global_by_event_name
def sys x$memory_global_by_current_bytes def performance_schema memory_summary_global_by_event_name
def sys memory_global_total def performance_schema memory_summary_global_by_event_name
def sys x$memory_global_total def performance_schema memory_summary_global_by_event_name
def sys schema_index_statistics def performance_schema table_io_waits_summary_by_index_usage
def sys x$schema_index_statistics def performance_schema table_io_waits_summary_by_index_usage
def sys x$ps_schema_table_statistics_io def performance_schema file_summary_by_instance
def sys schema_table_statistics def performance_schema table_io_waits_summary_by_table
def sys schema_table_statistics def sys x$ps_schema_table_statistics_io
def sys x$schema_table_statistics def performance_schema table_io_waits_summary_by_table
def sys x$schema_table_statistics def sys x$ps_schema_table_statistics_io
def sys schema_table_statistics_with_buffer def performance_schema table_io_waits_summary_by_table
def sys schema_table_statistics_with_buffer def sys x$innodb_buffer_stats_by_table
def sys schema_table_statistics_with_buffer def sys x$ps_schema_table_statistics_io
def sys x$schema_table_statistics_with_buffer def performance_schema table_io_waits_summary_by_table
def sys x$schema_table_statistics_with_buffer def sys x$innodb_buffer_stats_by_table
def sys x$schema_table_statistics_with_buffer def sys x$ps_schema_table_statistics_io
def sys schema_tables_with_full_table_scans def performance_schema table_io_waits_summary_by_index_usage
def sys x$schema_tables_with_full_table_scans def performance_schema table_io_waits_summary_by_index_usage
def sys schema_unused_indexes def information_schema STATISTICS
def sys schema_unused_indexes def performance_schema table_io_waits_summary_by_index_usage
def sys schema_table_lock_waits def performance_schema events_statements_current
def sys schema_table_lock_waits def performance_schema metadata_locks
def sys schema_table_lock_waits def performance_schema threads
def sys schema_table_lock_waits def sys sys_config
def sys x$schema_table_lock_waits def performance_schema events_statements_current
def sys x$schema_table_lock_waits def performance_schema metadata_locks
def sys x$schema_table_lock_waits def performance_schema threads
def sys statement_analysis def performance_schema events_statements_summary_by_digest
def sys statement_analysis def sys sys_config
def sys x$statement_analysis def performance_schema events_statements_summary_by_digest
def sys statements_with_errors_or_warnings def performance_schema events_statements_summary_by_digest
def sys statements_with_errors_or_warnings def sys sys_config
def sys x$statements_with_errors_or_warnings def performance_schema events_statements_summary_by_digest
def sys statements_with_full_table_scans def performance_schema events_statements_summary_by_digest
def sys statements_with_full_table_scans def sys sys_config
def sys x$statements_with_full_table_scans def performance_schema events_statements_summary_by_digest
def sys x$ps_digest_avg_latency_distribution def performance_schema events_statements_summary_by_digest
def sys x$ps_digest_95th_percentile_by_avg_us def performance_schema events_statements_summary_by_digest
def sys x$ps_digest_95th_percentile_by_avg_us def sys x$ps_digest_avg_latency_distribution
def sys statements_with_runtimes_in_95th_percentile def performance_schema events_statements_summary_by_digest
def sys statements_with_runtimes_in_95th_percentile def sys sys_config
def sys statements_with_runtimes_in_95th_percentile def sys x$ps_digest_95th_percentile_by_avg_us
def sys x$statements_with_runtimes_in_95th_percentile def performance_schema events_statements_summary_by_digest
def sys x$statements_with_runtimes_in_95th_percentile def sys x$ps_digest_95th_percentile_by_avg_us
def sys statements_with_sorting def performance_schema events_statements_summary_by_digest
def sys statements_with_sorting def sys sys_config
def sys x$statements_with_sorting def performance_schema events_statements_summary_by_digest
def sys statements_with_temp_tables def performance_schema events_statements_summary_by_digest
def sys statements_with_temp_tables def sys sys_config
VIEW_CATALOG VIEW_SCHEMA VIEW_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME  
def sys x$statements_with_temp_tables def performance_schema events_statements_summary_by_digest
def sys user_summary_by_file_io_type def performance_schema events_waits_summary_by_user_by_event_name
def sys x$user_summary_by_file_io_type def performance_schema events_waits_summary_by_user_by_event_name
def sys user_summary_by_file_io def performance_schema events_waits_summary_by_user_by_event_name
def sys x$user_summary_by_file_io def performance_schema events_waits_summary_by_user_by_event_name
def sys user_summary_by_statement_type def performance_schema events_statements_summary_by_user_by_event_name
def sys x$user_summary_by_statement_type def performance_schema events_statements_summary_by_user_by_event_name
def sys user_summary_by_statement_latency def performance_schema events_statements_summary_by_user_by_event_name
def sys x$user_summary_by_statement_latency def performance_schema events_statements_summary_by_user_by_event_name
def sys user_summary_by_stages def performance_schema events_stages_summary_by_user_by_event_name
def sys x$user_summary_by_stages def performance_schema events_stages_summary_by_user_by_event_name
def sys user_summary def performance_schema accounts
def sys user_summary def sys x$memory_by_user_by_current_bytes
def sys user_summary def sys x$user_summary_by_file_io
def sys user_summary def sys x$user_summary_by_statement_latency
def sys x$user_summary def performance_schema accounts
def sys x$user_summary def sys x$memory_by_user_by_current_bytes
def sys x$user_summary def sys x$user_summary_by_file_io
def sys x$user_summary def sys x$user_summary_by_statement_latency
def sys host_summary_by_file_io_type def performance_schema events_waits_summary_by_host_by_event_name
def sys x$host_summary_by_file_io_type def performance_schema events_waits_summary_by_host_by_event_name
def sys host_summary_by_file_io def performance_schema events_waits_summary_by_host_by_event_name
def sys x$host_summary_by_file_io def performance_schema events_waits_summary_by_host_by_event_name
def sys host_summary_by_statement_type def performance_schema events_statements_summary_by_host_by_event_name
def sys x$host_summary_by_statement_type def performance_schema events_statements_summary_by_host_by_event_name
def sys host_summary_by_statement_latency def performance_schema events_statements_summary_by_host_by_event_name
def sys x$host_summary_by_statement_latency def performance_schema events_statements_summary_by_host_by_event_name
def sys host_summary_by_stages def performance_schema events_stages_summary_by_host_by_event_name
def sys x$host_summary_by_stages def performance_schema events_stages_summary_by_host_by_event_name
def sys host_summary def performance_schema accounts
def sys host_summary def sys x$host_summary_by_file_io
def sys host_summary def sys x$host_summary_by_statement_latency
def sys host_summary def sys x$memory_by_host_by_current_bytes
def sys x$host_summary def performance_schema accounts
def sys x$host_summary def sys x$host_summary_by_file_io
def sys x$host_summary def sys x$host_summary_by_statement_latency
def sys x$host_summary def sys x$memory_by_host_by_current_bytes
def sys wait_classes_global_by_avg_latency def performance_schema events_waits_summary_global_by_event_name
def sys x$wait_classes_global_by_avg_latency def performance_schema events_waits_summary_global_by_event_name
def sys wait_classes_global_by_latency def performance_schema events_waits_summary_global_by_event_name
def sys x$wait_classes_global_by_latency def performance_schema events_waits_summary_global_by_event_name
def sys waits_by_user_by_latency def performance_schema events_waits_summary_by_user_by_event_name
def sys x$waits_by_user_by_latency def performance_schema events_waits_summary_by_user_by_event_name
def sys waits_by_host_by_latency def performance_schema events_waits_summary_by_host_by_event_name
def sys x$waits_by_host_by_latency def performance_schema events_waits_summary_by_host_by_event_name
def sys waits_global_by_latency def performance_schema events_waits_summary_global_by_event_name
def sys x$waits_global_by_latency def performance_schema events_waits_summary_global_by_event_name
def sys metrics def information_schema INNODB_METRICS
def sys metrics def performance_schema global_status
def sys metrics def performance_schema memory_summary_global_by_event_name
def sys metrics def performance_schema setup_instruments
def sys processlist def performance_schema events_stages_current
def sys processlist def performance_schema events_statements_current
def sys processlist def performance_schema events_transactions_current
def sys processlist def performance_schema events_waits_current
def sys processlist def performance_schema session_connect_attrs
def sys processlist def performance_schema threads
def sys processlist def sys sys_config
def sys processlist def sys x$memory_by_thread_by_current_bytes
def sys x$processlist def performance_schema events_stages_current
def sys x$processlist def performance_schema events_statements_current
def sys x$processlist def performance_schema events_transactions_current
def sys x$processlist def performance_schema events_waits_current
def sys x$processlist def performance_schema session_connect_attrs
def sys x$processlist def performance_schema threads
def sys x$processlist def sys x$memory_by_thread_by_current_bytes
def sys session def sys processlist
def sys session def sys sys_config
def sys x$session def sys x$processlist
def sys session_ssl_status def performance_schema status_by_thread
|
|
|
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