SELECT * FROM `x$schema_table_statistics_with_buffer`
|
table_schema | table_name | 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 | innodb_buffer_allocated | innodb_buffer_data | innodb_buffer_free | innodb_buffer_pages | innodb_buffer_pages_hashed | innodb_buffer_pages_old | innodb_buffer_rows_cached | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | 1486002 | 1263492750960 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1748533776 | 0 | 0 | 0 | 5 | 28868400 | 81920 | 33036 | 48884 | 5 | 0 | 3 | 1002 | |
sakila | film | 1388265 | 685542719136 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1664521056 | 0 | 0 | 0 | 5 | 34893408 | 212992 | 155213 | 57779 | 13 | 11 | 5 | 1006 | |
sakila | film_actor | 1492344 | 261219456960 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 2474023728 | 0 | 0 | 0 | 5 | 33137280 | 229376 | 154150 | 75226 | 14 | 10 | 7 | 3402 | |
sakila | category | 46310 | 25193212176 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 923300928 | 0 | 0 | 0 | 5 | 34307856 | 16384 | 487 | 15897 | 1 | 1 | 0 | 16 | |
sakila | payment | 16053 | 24622812720 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 9406986864 | 0 | 0 | 0 | 5 | 32644128 | 770048 | 650236 | 119812 | 47 | 0 | 18 | 8530 | |
sakila | rental | 16068 | 22218828192 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 10850439600 | 0 | 0 | 0 | 5 | 31554336 | 819200 | 701495 | 117705 | 50 | 0 | 20 | 8537 | |
sakila | inventory | 4787 | 16181445984 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 4420431312 | 0 | 0 | 0 | 5 | 33032208 | 245760 | 140070 | 105690 | 15 | 0 | 5 | 1907 | |
sakila | city | 993 | 5212408608 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4610639616 | 0 | 0 | 0 | 5 | 77799744 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 601 | |
world | City | 4079 | 4822983264 | 0 | 0 | 0 | 0 | 0 | 0 | 4081 | 273685 | 3180317712 | 0 | 0 | 0 | 4 | 23306976 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film_text | 1115 | 3638268480 | 0 | 0 | 0 | 0 | 0 | 0 | 2204 | 131305 | 1770482208 | 0 | 0 | 0 | 1112 | 177769152 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | actor | 2715 | 3289032912 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1309014432 | 0 | 0 | 0 | 5 | 310175712 | 32768 | 10353 | 22415 | 2 | 1 | 0 | 200 | |
sakila | address | 1246 | 2979019296 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2105324496 | 0 | 0 | 0 | 5 | 35690160 | 98304 | 51858 | 46446 | 6 | 0 | 2 | 605 | |
sakila | store | 35 | 2900835168 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2958865536 | 0 | 0 | 0 | 5 | 44200992 | 32768 | 66 | 32702 | 2 | 0 | 1 | 2 | |
vedettfak | fa | 1258 | 2665966512 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1504124160 | 0 | 0 | 0 | 5 | 48730704 | 114688 | 78301 | 36387 | 7 | 0 | 7 | 1264 | |
sakila | staff | 38 | 2595953184 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2246533344 | 0 | 0 | 0 | 5 | 31309872 | 49152 | 283 | 48869 | 3 | 0 | 3 | 2 | |
sakila | customer | 600 | 2308347888 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1752028608 | 0 | 0 | 0 | 5 | 38829120 | 98304 | 53205 | 45099 | 6 | 0 | 2 | 601 | |
Stefano | vulcano | 35 | 2244708576 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 7230942576 | 0 | 0 | 0 | 5 | 331381248 | 16384 | 344 | 16040 | 1 | 0 | 1 | 4 | |
sku | Attore | 1 | 1932875472 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1894328832 | 0 | 0 | 0 | 5 | 115042752 | 16384 | 91 | 16293 | 1 | 0 | 0 | 1 | |
sakila | language | 77 | 1390779456 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 973923984 | 0 | 0 | 0 | 5 | 57165504 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
sakila | country | 205 | 1349236416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 958511664 | 0 | 0 | 0 | 5 | 42337680 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
world | CountryLanguage | 984 | 1077708192 | 0 | 0 | 0 | 0 | 0 | 0 | 986 | 38783 | 1076318496 | 0 | 0 | 0 | 4 | 20758848 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
Table_insertion | ecurie | 4 | 971544288 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1158957888 | 0 | 0 | 0 | 5 | 56585232 | 16384 | 171 | 16213 | 1 | 0 | 0 | 4 | |
world | Country | 239 | 950390496 | 0 | 0 | 0 | 0 | 0 | 0 | 241 | 62841 | 982225200 | 0 | 0 | 0 | 4 | 24101616 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | megye | 20 | 940571280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 809739216 | 0 | 0 | 0 | 5 | 323648160 | 16384 | 655 | 15729 | 1 | 0 | 0 | 19 | |
TlapaleriaMalfoy | Registro | 2 | 900543600 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 834329760 | 0 | 0 | 0 | 5 | 314057040 | 16384 | 126 | 16258 | 1 | 0 | 1 | 2 |
|