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 `metrics`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
|
Filtrer les lignes:
Variable_name Variable_value Type Enabled
aborted_clients 0 Global Status YES
aborted_connects 0 Global Status YES
acl_cache_items_count 0 Global Status YES
binlog_cache_disk_use 0 Global Status YES
binlog_cache_use 1216 Global Status YES
binlog_stmt_cache_disk_use 0 Global Status YES
binlog_stmt_cache_use 2 Global Status YES
bytes_received 22049930 Global Status YES
bytes_sent 76510060 Global Status YES
caching_sha2_password_rsa_public_key -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQE...		 Global Status YES
com_stmt_reprepare 0 Global Status YES
connection_errors_accept 0 Global Status YES
connection_errors_internal 0 Global Status YES
connection_errors_max_connections 0 Global Status YES
connection_errors_peer_address 0 Global Status YES
connection_errors_select 0 Global Status YES
connection_errors_tcpwrap 0 Global Status YES
connections 4343 Global Status YES
created_tmp_disk_tables 30 Global Status YES
created_tmp_files 18 Global Status YES
created_tmp_tables 52473 Global Status YES
current_tls_ca ca.pem Global Status YES
current_tls_capath Global Status YES
current_tls_cert server-cert.pem Global Status YES
current_tls_cipher Global Status YES
current_tls_ciphersuites Global Status YES
current_tls_crl Global Status YES
current_tls_crlpath Global Status YES
current_tls_key server-key.pem Global Status YES
current_tls_version TLSv1.2,TLSv1.3 Global Status YES
delayed_errors 0 Global Status YES
delayed_insert_threads 0 Global Status YES
delayed_writes 0 Global Status YES
error_log_buffered_bytes 61528 Global Status YES
error_log_buffered_events 483 Global Status YES
error_log_expired_events 0 Global Status YES
error_log_latest_write 1765702556610117 Global Status YES
flush_commands 3 Global Status YES
global_connection_memory 0 Global Status YES
handler_commit 238897 Global Status YES
handler_delete 8 Global Status YES
handler_discover 0 Global Status YES
handler_external_lock 1243525 Global Status YES
handler_mrr_init 0 Global Status YES
handler_prepare 2432 Global Status YES
handler_read_first 88527 Global Status YES
handler_read_key 4588228 Global Status YES
handler_read_last 16 Global Status YES
handler_read_next 961435 Global Status YES
handler_read_prev 0 Global Status YES
handler_read_rnd 57349 Global Status YES
handler_read_rnd_next 2919326 Global Status YES
handler_rollback 0 Global Status YES
handler_savepoint 0 Global Status YES
handler_savepoint_rollback 0 Global Status YES
handler_update 3480080 Global Status YES
handler_write 955895 Global Status YES
innodb_buffer_pool_bytes_data 16498688 Global Status YES
innodb_buffer_pool_bytes_dirty 950272 Global Status YES
innodb_buffer_pool_dump_status Dumping of buffer pool not started Global Status YES
innodb_buffer_pool_load_status Buffer pool(s) load completed at 251118  6:59:43 Global Status YES
innodb_buffer_pool_pages_data 1007 Global Status YES
innodb_buffer_pool_pages_dirty 58 Global Status YES
innodb_buffer_pool_pages_flushed 12504 Global Status YES
innodb_buffer_pool_pages_free 1024 Global Status YES
innodb_buffer_pool_pages_misc 17 Global Status YES
innodb_buffer_pool_pages_total 2048 Global Status YES
innodb_buffer_pool_read_ahead 506 Global Status YES
innodb_buffer_pool_read_ahead_evicted 0 Global Status YES
innodb_buffer_pool_read_ahead_rnd 0 Global Status YES
innodb_buffer_pool_read_requests 5761676 Global Status YES
innodb_buffer_pool_reads 6822 Global Status YES
innodb_buffer_pool_resize_status Global Status YES
innodb_buffer_pool_resize_status_code 0 Global Status YES
innodb_buffer_pool_resize_status_progress 0 Global Status YES
innodb_buffer_pool_wait_free 0 Global Status YES
innodb_buffer_pool_write_requests 35746 Global Status YES
innodb_data_fsyncs 23199 Global Status YES
innodb_data_pending_fsyncs 1 Global Status YES
innodb_data_pending_reads 0 Global Status YES
innodb_data_pending_writes 1 Global Status YES
innodb_data_read 128519168 Global Status YES
innodb_data_reads 8017 Global Status YES
innodb_data_writes 32765 Global Status YES
innodb_data_written 216475648 Global Status YES
innodb_dblwr_pages_written 12338 Global Status YES
innodb_dblwr_writes 3871 Global Status YES
innodb_log_waits 0 Global Status YES
innodb_log_write_requests 25218 Global Status YES
innodb_log_writes 14964 Global Status YES
innodb_num_open_files 67 Global Status YES
innodb_os_log_fsyncs 16798 Global Status YES
innodb_os_log_pending_fsyncs 1 Global Status YES
innodb_os_log_pending_writes 1 Global Status YES
innodb_os_log_written 8776192 Global Status YES
innodb_page_size 16384 Global Status YES
innodb_pages_created 281 Global Status YES
innodb_pages_read 7327 Global Status YES
innodb_pages_written 12504 Global Status YES
innodb_redo_log_capacity_resized 104857600 Global Status YES
Variable_name Variable_value Type Enabled  
innodb_redo_log_checkpoint_lsn 132257263 Global Status YES
innodb_redo_log_current_lsn 132281014 Global Status YES
innodb_redo_log_enabled ON Global Status YES
innodb_redo_log_flushed_to_disk_lsn 132280984 Global Status YES
innodb_redo_log_logical_size 24576 Global Status YES
innodb_redo_log_physical_size 6553600 Global Status YES
innodb_redo_log_read_only OFF Global Status YES
innodb_redo_log_resize_status OK Global Status YES
innodb_redo_log_uuid 3410763900 Global Status YES
innodb_row_lock_current_waits 0 Global Status YES
innodb_row_lock_time 79380 Global Status YES
innodb_row_lock_time_avg 448 Global Status YES
innodb_row_lock_time_max 2273 Global Status YES
innodb_row_lock_waits 177 Global Status YES
innodb_rows_deleted 0 Global Status YES
innodb_rows_inserted 1104 Global Status YES
innodb_rows_read 19426 Global Status YES
innodb_rows_updated 1222 Global Status YES
innodb_sampled_pages_read 0 Global Status YES
innodb_sampled_pages_skipped 0 Global Status YES
innodb_system_rows_deleted 8 Global Status YES
innodb_system_rows_inserted 8 Global Status YES
innodb_system_rows_read 1606302 Global Status YES
innodb_system_rows_updated 1836 Global Status YES
innodb_truncated_status_writes 0 Global Status YES
innodb_undo_tablespaces_active 2 Global Status YES
innodb_undo_tablespaces_explicit 0 Global Status YES
innodb_undo_tablespaces_implicit 2 Global Status YES
innodb_undo_tablespaces_total 2 Global Status YES
key_blocks_not_flushed 0 Global Status YES
key_blocks_unused 13 Global Status YES
key_blocks_used 0 Global Status YES
key_read_requests 0 Global Status YES
key_reads 0 Global Status YES
key_write_requests 0 Global Status YES
key_writes 0 Global Status YES
locked_connects 0 Global Status YES
max_execution_time_exceeded 0 Global Status YES
max_execution_time_set 0 Global Status YES
max_execution_time_set_failed 0 Global Status YES
max_used_connections 22 Global Status YES
max_used_connections_time 2025-12-14 21:12:00 Global Status YES
mysqlx_aborted_clients 0 Global Status YES
mysqlx_address :: Global Status YES
mysqlx_bytes_received 0 Global Status YES
mysqlx_bytes_received_compressed_payload 0 Global Status YES
mysqlx_bytes_received_uncompressed_frame 0 Global Status YES
mysqlx_bytes_sent 0 Global Status YES
mysqlx_bytes_sent_compressed_payload 0 Global Status YES
mysqlx_bytes_sent_uncompressed_frame 0 Global Status YES
mysqlx_compression_algorithm Global Status YES
mysqlx_compression_level Global Status YES
mysqlx_connection_accept_errors 0 Global Status YES
mysqlx_connection_errors 0 Global Status YES
mysqlx_connections_accepted 0 Global Status YES
mysqlx_connections_closed 0 Global Status YES
mysqlx_connections_rejected 0 Global Status YES
mysqlx_crud_create_view 0 Global Status YES
mysqlx_crud_delete 0 Global Status YES
mysqlx_crud_drop_view 0 Global Status YES
mysqlx_crud_find 0 Global Status YES
mysqlx_crud_insert 0 Global Status YES
mysqlx_crud_modify_view 0 Global Status YES
mysqlx_crud_update 0 Global Status YES
mysqlx_cursor_close 0 Global Status YES
mysqlx_cursor_fetch 0 Global Status YES
mysqlx_cursor_open 0 Global Status YES
mysqlx_errors_sent 0 Global Status YES
mysqlx_errors_unknown_message_type 0 Global Status YES
mysqlx_expect_close 0 Global Status YES
mysqlx_expect_open 0 Global Status YES
mysqlx_init_error 0 Global Status YES
mysqlx_messages_sent 0 Global Status YES
mysqlx_notice_global_sent 0 Global Status YES
mysqlx_notice_other_sent 0 Global Status YES
mysqlx_notice_warning_sent 0 Global Status YES
mysqlx_notified_by_group_replication 0 Global Status YES
mysqlx_port 33060 Global Status YES
mysqlx_prep_deallocate 0 Global Status YES
mysqlx_prep_execute 0 Global Status YES
mysqlx_prep_prepare 0 Global Status YES
mysqlx_rows_sent 0 Global Status YES
mysqlx_sessions 0 Global Status YES
mysqlx_sessions_accepted 0 Global Status YES
mysqlx_sessions_closed 0 Global Status YES
mysqlx_sessions_fatal_error 0 Global Status YES
mysqlx_sessions_killed 0 Global Status YES
mysqlx_sessions_rejected 0 Global Status YES
mysqlx_socket UNDEFINED Global Status YES
mysqlx_ssl_accepts 0 Global Status YES
mysqlx_ssl_active Global Status YES
mysqlx_ssl_cipher Global Status YES
mysqlx_ssl_cipher_list Global Status YES
mysqlx_ssl_ctx_verify_depth 18446744073709551615 Global Status YES
mysqlx_ssl_ctx_verify_mode 5 Global Status YES
mysqlx_ssl_finished_accepts 0 Global Status YES
mysqlx_ssl_server_not_after Mar  8 15:25:22 2034 GMT Global Status YES
mysqlx_ssl_server_not_before Mar 10 15:25:22 2024 GMT Global Status YES
mysqlx_ssl_verify_depth Global Status YES
mysqlx_ssl_verify_mode Global Status YES
Variable_name Variable_value Type Enabled  
mysqlx_ssl_version Global Status YES
mysqlx_stmt_create_collection 0 Global Status YES
mysqlx_stmt_create_collection_index 0 Global Status YES
mysqlx_stmt_disable_notices 0 Global Status YES
mysqlx_stmt_drop_collection 0 Global Status YES
mysqlx_stmt_drop_collection_index 0 Global Status YES
mysqlx_stmt_enable_notices 0 Global Status YES
mysqlx_stmt_ensure_collection 0 Global Status YES
mysqlx_stmt_execute_mysqlx 0 Global Status YES
mysqlx_stmt_execute_sql 0 Global Status YES
mysqlx_stmt_execute_xplugin 0 Global Status YES
mysqlx_stmt_get_collection_options 0 Global Status YES
mysqlx_stmt_kill_client 0 Global Status YES
mysqlx_stmt_list_clients 0 Global Status YES
mysqlx_stmt_list_notices 0 Global Status YES
mysqlx_stmt_list_objects 0 Global Status YES
mysqlx_stmt_modify_collection_options 0 Global Status YES
mysqlx_stmt_ping 0 Global Status YES
mysqlx_worker_threads 2 Global Status YES
mysqlx_worker_threads_active 0 Global Status YES
not_flushed_delayed_rows 0 Global Status YES
ongoing_anonymous_transaction_count 0 Global Status YES
open_files 2 Global Status YES
open_streams 0 Global Status YES
open_table_definitions 348 Global Status YES
open_tables 15 Global Status YES
opened_files 2 Global Status YES
opened_table_definitions 402 Global Status YES
opened_tables 625305 Global Status YES
performance_schema_accounts_lost 0 Global Status YES
performance_schema_cond_classes_lost 0 Global Status YES
performance_schema_cond_instances_lost 0 Global Status YES
performance_schema_digest_lost 0 Global Status YES
performance_schema_file_classes_lost 0 Global Status YES
performance_schema_file_handles_lost 0 Global Status YES
performance_schema_file_instances_lost 0 Global Status YES
performance_schema_hosts_lost 0 Global Status YES
performance_schema_index_stat_lost 0 Global Status YES
performance_schema_locker_lost 0 Global Status YES
performance_schema_memory_classes_lost 0 Global Status YES
performance_schema_metadata_lock_lost 0 Global Status YES
performance_schema_meter_lost 0 Global Status YES
performance_schema_metric_lost 0 Global Status YES
performance_schema_mutex_classes_lost 0 Global Status YES
performance_schema_mutex_instances_lost 0 Global Status YES
performance_schema_nested_statement_lost 0 Global Status YES
performance_schema_prepared_statements_lost 0 Global Status YES
performance_schema_program_lost 0 Global Status YES
performance_schema_rwlock_classes_lost 0 Global Status YES
performance_schema_rwlock_instances_lost 0 Global Status YES
performance_schema_session_connect_attrs_longest_s... 44 Global Status YES
performance_schema_session_connect_attrs_lost 0 Global Status YES
performance_schema_socket_classes_lost 0 Global Status YES
performance_schema_socket_instances_lost 0 Global Status YES
performance_schema_stage_classes_lost 0 Global Status YES
performance_schema_statement_classes_lost 0 Global Status YES
performance_schema_table_handles_lost 0 Global Status YES
performance_schema_table_instances_lost 0 Global Status YES
performance_schema_table_lock_stat_lost 0 Global Status YES
performance_schema_thread_classes_lost 0 Global Status YES
performance_schema_thread_instances_lost 0 Global Status YES
performance_schema_users_lost 0 Global Status YES
prepared_stmt_count 0 Global Status YES
queries 270236 Global Status YES
questions 264780 Global Status YES
replica_open_temp_tables 0 Global Status YES
resource_group_supported ON Global Status YES
rsa_public_key -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQE...		 Global Status YES
secondary_engine_execution_count 0 Global Status YES
select_full_join 12384 Global Status YES
select_full_range_join 0 Global Status YES
select_range 21 Global Status YES
select_range_check 0 Global Status YES
select_scan 105599 Global Status YES
slave_open_temp_tables 0 Global Status YES
slow_launch_threads 0 Global Status YES
slow_queries 2 Global Status YES
sort_merge_passes 7 Global Status YES
sort_range 0 Global Status YES
sort_rows 359794 Global Status YES
sort_scan 33819 Global Status YES
ssl_accept_renegotiates 0 Global Status YES
ssl_accepts 0 Global Status YES
ssl_callback_cache_hits 0 Global Status YES
ssl_cipher Global Status YES
ssl_cipher_list Global Status YES
ssl_client_connects 0 Global Status YES
ssl_connect_renegotiates 0 Global Status YES
ssl_ctx_verify_depth 4294967295 Global Status YES
ssl_ctx_verify_mode 5 Global Status YES
ssl_default_timeout 0 Global Status YES
ssl_finished_accepts 0 Global Status YES
ssl_finished_connects 0 Global Status YES
ssl_server_not_after Mar  8 15:25:22 2034 GMT Global Status YES
ssl_server_not_before Mar 10 15:25:22 2024 GMT Global Status YES
ssl_session_cache_hits 0 Global Status YES
ssl_session_cache_misses 0 Global Status YES
ssl_session_cache_mode SERVER Global Status YES
ssl_session_cache_overflows 0 Global Status YES
ssl_session_cache_size 128 Global Status YES
|
|
|
|
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