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 | film_category | 848042618016 | 990000 | 848042618016 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 846332256 | 0 | 0 | 0 | 5 | 22640640 | |
sakila | film | 455383491552 | 924508 | 455383491552 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2613938448 | 0 | 0 | 0 | 5 | 36171696 | |
sakila | film_actor | 169090888032 | 991200 | 169090888032 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 3850093104 | 0 | 0 | 0 | 5 | 38100480 | |
sakila | category | 16053533760 | 30810 | 16053533760 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 706041600 | 0 | 0 | 0 | 5 | 24324432 | |
sakila | address | 5542805664 | 1485 | 5542805664 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4584779760 | 0 | 0 | 0 | 5 | 47766576 | |
sakila | staff | 4058619312 | 5 | 4058619312 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1977720096 | 0 | 0 | 0 | 5 | 58990272 | |
sakila | store | 4011599856 | 3 | 4011599856 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4141270848 | 0 | 0 | 0 | 5 | 39574656 | |
sakila | actor | 2984460336 | 3577 | 2984460336 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 903442320 | 0 | 0 | 0 | 5 | 40045632 | |
teste_teste | test | 2621823600 | 6 | 558021552 | 2 | 2063802048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 6072302544 | 9 | 86688187344 | |
sakila | city | 1875992448 | 165 | 1875992448 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1275746208 | 0 | 0 | 0 | 5 | 52160064 | |
sakila | customer | 1225364448 | 26 | 1225364448 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1298976096 | 0 | 0 | 0 | 5 | 25973376 | |
sakila | country | 1136948736 | 60 | 1136948736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 880308000 | 0 | 0 | 0 | 5 | 45142944 | |
sakila | language | 1129394112 | 50 | 1129394112 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 942994272 | 0 | 0 | 0 | 5 | 59577408 | |
sys | sys_config | 932562048 | 1 | 932562048 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 806779248 | 0 | 0 | 0 | 5 | 54150624 | |
vedettfak | megye | 784695120 | 3 | 784695120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 990893904 | 0 | 0 | 0 | 5 | 48618768 | |
libro | libro | 276593856 | 21 | 276593856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 317924112 | 9 | 90503410272 | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
performance_schema | memory_summary_by_thread_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 | |
mysql | help_relation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | help_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | slow_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 550729872 | 0 | 0 | 0 | 4 | 395831568 | |
mysql | general_log | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 35 | 1248840384 | 0 | 0 | 0 | 4 | 372805488 | |
performance_schema | global_variables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|