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 | 1116007091760 | 1320000 | 1116007091760 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 846332256 | 0 | 0 | 0 | 5 | 22640640 | |
sakila | film | 598970367600 | 1232686 | 598970367600 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2613938448 | 0 | 0 | 0 | 5 | 36171696 | |
sakila | film_actor | 220937222352 | 1321600 | 220937222352 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 3850093104 | 0 | 0 | 0 | 5 | 38100480 | |
sakila | category | 20981260608 | 41080 | 20981260608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 706041600 | 0 | 0 | 0 | 5 | 24324432 | |
sakila | address | 5566489104 | 1487 | 5566489104 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4584779760 | 0 | 0 | 0 | 5 | 47766576 | |
sakila | rental | 4679363040 | 2 | 4679363040 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2890456272 | 0 | 0 | 0 | 5 | 1965277776 | |
sakila | staff | 4144167456 | 8 | 4144167456 | 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 | 3717335952 | 4690 | 3717335952 | 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 | language | 1384670496 | 75 | 1384670496 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 942994272 | 0 | 0 | 0 | 5 | 59577408 | |
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 | |
sys | sys_config | 957485760 | 2 | 957485760 | 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 | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|