SELECT * FROM `x$schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table_insertion | pilote | 3941006784 | 4 | 3941006784 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3790749072 | 0 | 0 | 0 | 5 | 42377280 | |
sakila | film | 2500568928 | 1086 | 2500568928 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3252265632 | 0 | 0 | 0 | 5 | 31819920 | |
sakila | country | 2500252128 | 26 | 2500252128 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2365845504 | 0 | 0 | 0 | 5 | 35583504 | |
sakila | film_category | 1622894064 | 1026 | 1622894064 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1239467328 | 0 | 0 | 0 | 5 | 64103424 | |
sakila | language | 1418660496 | 219 | 1418660496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 573098064 | 0 | 0 | 0 | 5 | 49042752 | |
INFS1200_RELEASE | Vehicle | 1249708944 | 0 | 0 | 33 | 1249708944 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 7302509280 | 10 | 76721959248 | |
INFS1200_RELEASE | Policy | 986955552 | 0 | 0 | 48 | 986955552 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 205460640 | 10 | 101111649936 | |
sys | sys_config | 797992800 | 8 | 797992800 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 560895456 | 0 | 0 | 0 | 5 | 42997680 | |
INFS1200_RELEASE | VehicleCodeMapping | 491559552 | 0 | 0 | 19 | 491559552 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 161906448 | 8 | 85930983600 | |
INFS1200_RELEASE | Customer | 309947088 | 0 | 0 | 14 | 309947088 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 300867600 | 10 | 89220602592 | |
INFS1200_RELEASE | VehicleExcessRange | 184050240 | 0 | 0 | 19 | 184050240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 119439408 | 6 | 61803904272 | |
INFS1200_RELEASE | VehicleValue | 146342592 | 0 | 0 | 19 | 146342592 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 120171216 | 6 | 50134026624 | |
INFS1200_RELEASE | Address | 91603248 | 0 | 0 | 14 | 91603248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 180316752 | 7 | 68351565216 | |
performance_schema | status_by_account | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | file_summary_by_instance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_thread_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameters | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | parameter_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_waits_summary_by_user_by_event_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | innodb_table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_digest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|