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 | 144430891968 | 165001 | 144430891968 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2526944640 | 0 | 0 | 0 | 5 | 44949168 | |
sakila | film | 73891490640 | 154155 | 73891490640 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1525746288 | 0 | 0 | 0 | 5 | 32334192 | |
sakila | film_actor | 27288330960 | 165202 | 27288330960 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2252124864 | 0 | 0 | 0 | 5 | 52663776 | |
world | City | 11307224544 | 12265 | 11307224544 | 0 | 0 | 0 | 0 | 0 | 0 | 12264 | 821946 | 6113675568 | 0 | 0 | 0 | 9 | 82526400 | |
sakila | staff | 4185707856 | 2 | 4185707856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4258456224 | 0 | 0 | 0 | 5 | 49454064 | |
world | CountryLanguage | 2908567200 | 2981 | 2908567200 | 0 | 0 | 0 | 0 | 0 | 0 | 2979 | 116510 | 2523422880 | 0 | 0 | 0 | 9 | 77818224 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 2521210560 | 24 | 2521210560 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | category | 2519600160 | 5139 | 2519600160 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1074703344 | 0 | 0 | 0 | 5 | 39239376 | |
world | Country | 2435028288 | 745 | 2435028288 | 0 | 0 | 0 | 0 | 0 | 0 | 744 | 194124 | 1915944096 | 0 | 0 | 0 | 8 | 57358224 | |
sakila | actor | 1972565760 | 885 | 1972565760 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1294251552 | 0 | 0 | 0 | 5 | 44745888 | |
sakila | address | 1311166560 | 5 | 1311166560 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 1357241952 | 0 | 0 | 0 | 5 | 46161456 | |
matuno_test | employees | 1175878176 | 88 | 915842400 | 6 | 260035776 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 609200592 | 8 | 119695882416 | |
sakila | city | 796365504 | 2 | 796365504 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 901262736 | 0 | 0 | 0 | 5 | 38328576 | |
sakila | film_text | 700772688 | 2 | 700772688 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 1104799872 | 0 | 0 | 0 | 4 | 20749872 | |
sys | sys_config | 545751888 | 1 | 545751888 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 783364032 | 0 | 0 | 0 | 5 | 47859504 | |
sakila | language | 522489792 | 76 | 522489792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 829572480 | 0 | 0 | 0 | 5 | 45082752 | |
sakila | country | 445610880 | 2 | 445610880 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 625607664 | 0 | 0 | 0 | 5 | 19576128 | |
sakila | inventory | 82263456 | 2 | 82263456 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3017410176 | 0 | 0 | 0 | 5 | 33039072 | |
TlapaleriaMalfoy | Registro | 58562592 | 3 | 58562592 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 992255088 | 0 | 0 | 0 | 5 | 57756336 | |
sakila | customer | 42936960 | 1 | 42936960 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1920448464 | 0 | 0 | 0 | 5 | 37284192 | |
Stefano | vulcano | 18161616 | 1 | 18161616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 927931488 | 0 | 0 | 0 | 5 | 37830672 | |
vedettfak | megye | 16981008 | 1 | 16981008 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1048487088 | 0 | 0 | 0 | 5 | 38089920 | |
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 |
|