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 | payment | 160440 | 255966782016 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 10101222912 | 0 | 0 | 0 | 5 | 54142176 | 1015808 | 835288 | 180520 | 62 | 60 | 0 | 16079 | |
sakila | rental | 206252 | 74430665760 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 19104340464 | 0 | 0 | 0 | 5 | 43645536 | 1097728 | 897591 | 200137 | 67 | 16 | 50 | 11221 | |
sakila | staff | 24 | 22756140528 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1468790928 | 0 | 0 | 0 | 5 | 44362032 | 32768 | 267 | 32501 | 2 | 0 | 1 | 2 | |
sakila | inventory | 45830 | 10748743632 | 0 | 0 | 0 | 0 | 0 | 0 | 21 | 393216 | 6303632544 | 0 | 0 | 0 | 5 | 42895248 | 294912 | 178869 | 116043 | 18 | 0 | 11 | 4589 | |
sakila | city | 98 | 4245122640 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 3220028592 | 0 | 0 | 0 | 5 | 637193040 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 601 | |
Stefano | vulcano | 1 | 4028961552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4230554592 | 0 | 0 | 0 | 5 | 35669040 | 16384 | 344 | 16040 | 1 | 0 | 1 | 4 | |
world | CountryLanguage | 38 | 2654533728 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 1382 | 2220570000 | 0 | 0 | 0 | 11 | 118123632 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
vedettfak | megye | 30 | 2341901232 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1422312672 | 0 | 0 | 0 | 5 | 1102571712 | 16384 | 655 | 15729 | 1 | 0 | 0 | 19 | |
sakila | film | 52 | 2185005504 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2791250880 | 0 | 0 | 0 | 5 | 768728400 | 212992 | 155213 | 57779 | 13 | 0 | 10 | 1006 | |
sakila | store | 33 | 1880280864 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 785473920 | 0 | 0 | 0 | 5 | 1008026448 | 32768 | 66 | 32702 | 2 | 0 | 1 | 2 | |
sakila | language | 54 | 1309624272 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 982972848 | 0 | 0 | 0 | 5 | 71854992 | 16384 | 264 | 16120 | 1 | 0 | 0 | 6 | |
vedettfak | fa | 2 | 1308625296 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1466409120 | 0 | 0 | 0 | 5 | 52547616 | 32768 | 8744 | 24024 | 2 | 0 | 2 | 624 | |
sakila | address | 47 | 1277951664 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1775842464 | 0 | 0 | 0 | 5 | 36392400 | 81920 | 46431 | 35489 | 5 | 0 | 3 | 607 | |
sakila | country | 123 | 1081935360 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 630065040 | 0 | 0 | 0 | 5 | 45776544 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sys | sys_config | 3 | 1042058688 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 759940368 | 0 | 0 | 0 | 5 | 548301072 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sakila | customer | 26 | 984991392 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1488707088 | 0 | 0 | 0 | 5 | 36430944 | 98304 | 53205 | 45099 | 6 | 0 | 6 | 601 | |
Table_insertion | voiture | 25 | 418541904 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 932662896 | 0 | 0 | 0 | 5 | 34239216 | 32768 | 842 | 31926 | 2 | 0 | 0 | 14 | |
sakila | actor | 105 | 227997264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 5403780624 | 0 | 0 | 0 | 5 | 45695760 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
Table_insertion | ecurie | 56 | 149787792 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1628083776 | 0 | 0 | 0 | 5 | 43154496 | 16384 | 171 | 16213 | 1 | 0 | 0 | 4 | |
Table_insertion | pilote | 8 | 100259808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1183593840 | 0 | 0 | 0 | 5 | 22508112 | 16384 | 1119 | 15265 | 1 | 0 | 0 | 30 | |
sakila | category | 4 | 84957312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 789874800 | 0 | 0 | 0 | 5 | 75511392 | 16384 | 487 | 15897 | 1 | 0 | 0 | 16 | |
world | Country | 2 | 26650800 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 462 | 339713088 | 0 | 0 | 0 | 5 | 30594960 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1605632 | 1174175 | 431457 | 98 | 71 | 14 | 4244 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1130496 | 900080 | 230416 | 69 | 0 | 65 | 685 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 533224 | 220440 | 46 | 37 | 0 | 412 |
|