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 | rental | 363 | 417873090624 | 0 | 0 | 0 | 0 | 0 | 0 | 53 | 917504 | 423838707600 | 0 | 0 | 0 | 5 | 40453248 | 819200 | 704807 | 114393 | 50 | 0 | 46 | 8802 | |
sakila | store | 29 | 22594202400 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2175064848 | 0 | 0 | 0 | 5 | 47202672 | 32768 | 66 | 32702 | 2 | 0 | 0 | 2 | |
sakila | film | 26 | 7502352000 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 8378378976 | 0 | 0 | 0 | 5 | 68183808 | 212992 | 155213 | 57779 | 13 | 0 | 13 | 1006 | |
sakila | staff | 145 | 5190418992 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3914935728 | 0 | 0 | 0 | 5 | 59611728 | 49152 | 283 | 48869 | 3 | 0 | 0 | 2 | |
sakila | customer | 675 | 4604074992 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2558142048 | 0 | 0 | 0 | 5 | 1290953136 | 98304 | 53205 | 45099 | 6 | 0 | 0 | 601 | |
sakila | payment | 33 | 2727218208 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 868352 | 6290502240 | 0 | 0 | 0 | 5 | 960693888 | 770048 | 650236 | 119812 | 47 | 0 | 43 | 8530 | |
sakila | actor | 31 | 2466316512 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2524893888 | 0 | 0 | 0 | 5 | 58965456 | 32768 | 10353 | 22415 | 2 | 0 | 2 | 200 | |
vedettfak | megye | 3 | 2435735280 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2345924064 | 0 | 0 | 0 | 5 | 334476384 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
sakila | city | 42 | 2212879152 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1991976096 | 0 | 0 | 0 | 5 | 57012384 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
test19 | pilote | 54 | 2077127184 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 2033414592 | 0 | 0 | 0 | 5 | 76986624 | 16384 | 1119 | 15265 | 1 | 0 | 1 | 30 | |
sku | Attore | 2 | 1729687344 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1876602816 | 0 | 0 | 0 | 5 | 52393968 | 16384 | 91 | 16293 | 1 | 0 | 1 | 1 | |
sakila | address | 642 | 1165042032 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2066296848 | 0 | 0 | 0 | 5 | 38901984 | 98304 | 51858 | 46446 | 6 | 0 | 3 | 605 | |
sakila | language | 48 | 1081417920 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 785092704 | 0 | 0 | 0 | 5 | 55476960 | 16384 | 264 | 16120 | 1 | 0 | 0 | 6 | |
test19 | ecurie | 12 | 1019500944 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 982078944 | 0 | 0 | 0 | 5 | 267973728 | 16384 | 171 | 16213 | 1 | 0 | 1 | 4 | |
world | Country | 54 | 409714272 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 13512 | 749295360 | 0 | 0 | 0 | 7 | 57681360 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | inventory | 300 | 159104352 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2327360640 | 0 | 0 | 0 | 5 | 30040032 | 212992 | 136174 | 76818 | 13 | 0 | 11 | 2684 | |
world | City | 6 | 64196880 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 392 | 318266256 | 0 | 0 | 0 | 7 | 63433920 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | country | 12 | 19659552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 862617360 | 0 | 0 | 0 | 5 | 53302128 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1490944 | 1097100 | 393844 | 91 | 50 | 47 | 4080 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1146880 | 891644 | 255236 | 70 | 0 | 67 | 628 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 532064 | 221600 | 46 | 36 | 15 | 409 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 148799 | 146113 | 18 | 0 | 4 | 56 | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 278528 | 147412 | 131116 | 17 | 4 | 11 | 1579 | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1938144384 | 0 | 0 | 0 | 5 | 33891264 | 196608 | 142155 | 54453 | 12 | 0 | 12 | 5473 | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 163840 | 89963 | 73877 | 10 | 0 | 8 | 562 |
|