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 | 165000 | 154056591420 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1695063490 | 0 | 0 | 0 | 5 | 26151260 | 65536 | 25036 | 40500 | 4 | 0 | 1 | 1003 | |
sakila | film | 161449 | 93227144690 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2634415880 | 0 | 0 | 0 | 5 | 100317870 | 212992 | 155213 | 57779 | 13 | 11 | 0 | 1006 | |
sakila | film_actor | 165200 | 30331843820 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1654621840 | 0 | 0 | 0 | 5 | 32403670 | 196608 | 142155 | 54453 | 12 | 10 | 1 | 5473 | |
sakila | staff | 11 | 6793055050 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 6246644660 | 0 | 0 | 0 | 5 | 59895300 | 49152 | 283 | 48869 | 3 | 0 | 1 | 2 | |
sakila | city | 29 | 4441530910 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4875433430 | 0 | 0 | 0 | 5 | 53546960 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
sys | sys_config | 20 | 3641556860 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 977877030 | 0 | 0 | 0 | 5 | 2463633980 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sku | Attore | 8 | 3281899390 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 753944610 | 0 | 0 | 0 | 5 | 281328770 | 16384 | 91 | 16293 | 1 | 0 | 0 | 1 | |
sakila | language | 206 | 3111010430 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1774706590 | 0 | 0 | 0 | 5 | 63999620 | 16384 | 264 | 16120 | 1 | 1 | 0 | 6 | |
sakila | category | 5135 | 2827914110 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 798098380 | 0 | 0 | 0 | 5 | 47594530 | 16384 | 487 | 15897 | 1 | 1 | 0 | 16 | |
vedettfak | fa | 7 | 1764491370 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 2477035030 | 0 | 0 | 0 | 5 | 757355160 | 147456 | 87045 | 60411 | 9 | 0 | 7 | 944 | |
sakila | country | 78 | 1353646500 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1311629690 | 0 | 0 | 0 | 5 | 113783580 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | inventory | 59 | 1271714330 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2096659330 | 0 | 0 | 0 | 5 | 50581080 | 212992 | 136174 | 76818 | 13 | 0 | 9 | 2684 | |
sakila | address | 7 | 1116199610 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1550089940 | 0 | 0 | 0 | 5 | 22117960 | 81920 | 46431 | 35489 | 5 | 0 | 3 | 607 | |
sakila | film_text | 59 | 1097305110 | 0 | 0 | 0 | 0 | 0 | 0 | 104 | 6511 | 1366453950 | 0 | 0 | 0 | 60 | 58797140 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | actor | 431 | 973352950 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1183339480 | 0 | 0 | 0 | 5 | 50123160 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
sakila | store | 21 | 846907140 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 796422520 | 0 | 0 | 0 | 5 | 39836390 | 32768 | 66 | 32702 | 2 | 0 | 0 | 2 | |
test19 | pilote | 7 | 837352300 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 933985610 | 0 | 0 | 0 | 5 | 51928870 | 16384 | 1119 | 15265 | 1 | 0 | 0 | 30 | |
test19 | ecurie | 7 | 722256440 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 871396850 | 0 | 0 | 0 | 5 | 47365040 | 16384 | 171 | 16213 | 1 | 0 | 0 | 4 | |
test19 | voiture | 4 | 689162180 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 894439130 | 0 | 0 | 0 | 5 | 46762960 | 16384 | 196 | 16188 | 1 | 0 | 0 | 14 | |
sakila | rental | 7 | 459018690 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 5780416380 | 0 | 0 | 0 | 5 | 44167020 | 819200 | 704807 | 114393 | 50 | 0 | 48 | 8802 | |
world | Country | 6 | 117485630 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 184000630 | 0 | 0 | 0 | 9 | 59011790 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
world | City | 10 | 102445820 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 2148149890 | 0 | 0 | 0 | 7 | 46363870 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | payment | 4 | 99514390 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 5122860750 | 0 | 0 | 0 | 5 | 43383150 | 770048 | 650236 | 119812 | 47 | 0 | 45 | 8530 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1474560 | 1077280 | 397280 | 90 | 51 | 28 | 3969 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1130496 | 890978 | 239518 | 69 | 0 | 52 | 624 |
|