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 | 16180 | 32695871472 | 0 | 0 | 0 | 0 | 0 | 0 | 59 | 1015808 | 13960599312 | 0 | 0 | 0 | 5 | 30126096 | 917504 | 770980 | 146524 | 56 | 44 | 9 | 16076 | |
sakila | rental | 32099 | 23537660784 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 16069847376 | 0 | 0 | 0 | 5 | 37256736 | 1097728 | 881531 | 216197 | 67 | 47 | 17 | 11221 | |
sakila | staff | 153 | 7129599312 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 6953190288 | 0 | 0 | 0 | 5 | 37756224 | 32768 | 267 | 32501 | 2 | 1 | 0 | 2 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 5 | 3851087328 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 949 | 15435 | 1 | 0 | 0 | 24 | |
sakila | actor | 1261 | 2571702144 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2626004304 | 0 | 0 | 0 | 5 | 34943040 | 32768 | 10353 | 22415 | 2 | 0 | 0 | 200 | |
sakila | customer | 968 | 2195213856 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 1754242512 | 0 | 0 | 0 | 5 | 35180640 | 114688 | 58596 | 56092 | 7 | 1 | 1 | 600 | |
sakila | film | 208 | 1923735792 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4704856992 | 0 | 0 | 0 | 5 | 33225984 | 212992 | 155213 | 57779 | 13 | 0 | 10 | 1006 | |
Table_insertion | voiture | 2 | 1591010784 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1561009824 | 0 | 0 | 0 | 5 | 135392400 | 32768 | 842 | 31926 | 2 | 0 | 2 | 14 | |
sakila | language | 200 | 1471849104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 900318672 | 0 | 0 | 0 | 5 | 49473600 | 16384 | 264 | 16120 | 1 | 1 | 0 | 6 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 1 | 1263649728 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 195 | 16189 | 1 | 0 | 1 | 3 | |
test19 | voiture | 2 | 1031803872 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 842760864 | 0 | 0 | 0 | 5 | 424863120 | 16384 | 196 | 16188 | 1 | 0 | 1 | 14 | |
sys | sys_config | 3 | 699662304 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 827040720 | 0 | 0 | 0 | 5 | 75229440 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sakila | inventory | 200 | 688089600 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2854415520 | 0 | 0 | 0 | 5 | 31880640 | 212992 | 136174 | 76818 | 13 | 0 | 13 | 2684 | |
sakila | city | 140 | 667455888 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1089619872 | 0 | 0 | 0 | 5 | 28317696 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
sakila | country | 110 | 634743120 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 811305264 | 0 | 0 | 0 | 5 | 32857968 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | address | 60 | 526789824 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1570783632 | 0 | 0 | 0 | 5 | 35748768 | 98304 | 51858 | 46446 | 6 | 0 | 1 | 605 | |
art_gallery | artist | 3 | 36231888 | 6 | 383767824 | 0 | 0 | 0 | 0 | 4 | 603 | 21058224 | 27 | 1090 | 54307440 | 15 | 95248032 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
TGCR | gender | 2 | 11026752 | 3 | 313540656 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 120546624 | 6 | 87531857952 | 16384 | 84 | 16300 | 1 | 0 | 0 | 3 | |
art_gallery | contacts | 0 | 0 | 7 | 151889232 | 0 | 0 | 0 | 0 | 2 | 371 | 11307120 | 16 | 658 | 156525600 | 9 | 116580816 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
TGCR | status | 0 | 0 | 2 | 109318704 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 228162528 | 6 | 82772643360 | 16384 | 60 | 16324 | 1 | 0 | 0 | 2 | |
TGCR | user | 3 | 18339024 | 2 | 60436992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 270387744 | 8 | 87468379152 | 49152 | 264 | 48888 | 3 | 0 | 0 | 2 | |
art_gallery | customer | 0 | 0 | 7 | 58854576 | 0 | 0 | 0 | 0 | 2 | 490 | 10242144 | 25 | 965 | 58433760 | 9 | 84117264 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
art_gallery | artwork | 0 | 0 | 6 | 46273392 | 0 | 0 | 0 | 0 | 2 | 539 | 9407904 | 27 | 1050 | 46128192 | 9 | 77463936 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
art_gallery | gallery | 0 | 0 | 7 | 38369232 | 0 | 0 | 0 | 0 | 4 | 756 | 41149680 | 18 | 735 | 46649328 | 14 | 148770864 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
art_gallery | exhibition | 0 | 0 | 5 | 35319504 | 0 | 0 | 0 | 0 | 2 | 427 | 11183040 | 18 | 674 | 36553440 | 9 | 53270976 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|