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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | language | 40544218704 | 75 | 40544218704 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 5813985408 | 0 | 0 | 0 | 5 | 223237344 | |
sakila | address | 12519211056 | 128 | 12519211056 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3423657072 | 0 | 0 | 0 | 5 | 59549952 | |
sakila | customer | 7565587392 | 129 | 7565587392 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 7642518048 | 0 | 0 | 0 | 5 | 34529616 | |
sakila | rental | 4819991616 | 26 | 4819991616 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 10999421664 | 0 | 0 | 0 | 5 | 43579008 | |
vedettfak | fa | 4605911904 | 26 | 4605911904 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 5256284880 | 0 | 0 | 0 | 5 | 35464704 | |
sku | Attore | 4305762912 | 2 | 4305762912 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4322685312 | 0 | 0 | 0 | 5 | 42334512 | |
sakila | country | 4148140656 | 77 | 4148140656 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3997060320 | 0 | 0 | 0 | 5 | 44832480 | |
sakila | film | 2767754880 | 106 | 2767754880 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 3098025216 | 0 | 0 | 0 | 5 | 104232480 | |
sakila | staff | 1944916512 | 28 | 1944916512 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1551987888 | 0 | 0 | 0 | 5 | 42088464 | |
world | City | 1639253616 | 26 | 1639253616 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 2067 | 1903801152 | 0 | 0 | 0 | 5 | 29410656 | |
vedettfak | megye | 1452984720 | 25 | 1452984720 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1357527072 | 0 | 0 | 0 | 5 | 64692672 | |
sakila | city | 1269348432 | 51 | 1269348432 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1113657600 | 0 | 0 | 0 | 5 | 35668512 | |
Artist | PAINTING | 159582192 | 14 | 36623136 | 8 | 122959056 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 770774928 | 7 | 64438359216 | |
Artist | PAINTER | 92656080 | 12 | 40037184 | 3 | 52618896 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 503409984 | 6 | 71444529024 | |
performance_schema | events_statements_current | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | events_statements_summary_by_user_by_event_name | 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 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_lock_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | table_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | catalogs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slave_relay_log_info | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | table_io_waits_summary_by_table | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | session_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|