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 | 64322 | 15983987184 | 0 | 0 | 0 | 0 | 0 | 0 | 59 | 1015808 | 7611618432 | 0 | 0 | 0 | 5 | 55216128 | 917504 | 770980 | 146524 | 56 | 1 | 42 | 16076 | |
sakila | film | 1851 | 10144732752 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 344064 | 6192936288 | 0 | 0 | 0 | 5 | 1107603024 | 245760 | 163368 | 82392 | 15 | 0 | 12 | 790 | |
sakila | address | 193 | 4752370128 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5030662560 | 0 | 0 | 0 | 5 | 57296976 | 98304 | 51858 | 46446 | 6 | 0 | 6 | 605 | |
sakila | inventory | 2 | 4239750240 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5886115488 | 0 | 0 | 0 | 5 | 54172800 | 212992 | 136174 | 76818 | 13 | 0 | 13 | 2684 | |
sakila | store | 3 | 3934650192 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4060670592 | 0 | 0 | 0 | 5 | 37682832 | 32768 | 66 | 32702 | 2 | 0 | 2 | 2 | |
sakila | actor | 26 | 3927643104 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 4046833296 | 0 | 0 | 0 | 5 | 50159472 | 32768 | 10353 | 22415 | 2 | 0 | 2 | 200 | |
sakila | customer | 27 | 3140546112 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3735192384 | 0 | 0 | 0 | 5 | 36203376 | 98304 | 53205 | 45099 | 6 | 0 | 6 | 601 | |
vedettfak | fa | 26 | 2899555824 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 245760 | 3609312960 | 0 | 0 | 0 | 5 | 308724768 | 147456 | 87045 | 60411 | 9 | 0 | 9 | 944 | |
sakila | city | 261 | 2823607776 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 966065232 | 0 | 0 | 0 | 5 | 473815584 | 65536 | 26640 | 38896 | 4 | 2 | 4 | 601 | |
sakila | staff | 60 | 2324492016 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1427927424 | 0 | 0 | 0 | 5 | 50265600 | 32768 | 267 | 32501 | 2 | 0 | 0 | 2 | |
sakila | country | 508 | 1684972608 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 868112256 | 0 | 0 | 0 | 5 | 38246736 | 16384 | 3739 | 12645 | 1 | 0 | 1 | 110 | |
sakila | language | 198 | 1675951200 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 775552800 | 0 | 0 | 0 | 5 | 64721712 | 16384 | 264 | 16120 | 1 | 1 | 0 | 6 | |
dbv2 | accounts | 14 | 738604416 | 0 | 0 | 0 | 0 | 4 | 876162672 | 0 | 0 | 0 | 14 | 327680 | 217197552 | 12 | 134026144032 | 65536 | 1995 | 63541 | 4 | 0 | 0 | 1 | |
sys | sys_config | 1 | 1144398816 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1396284384 | 0 | 0 | 0 | 5 | 63588624 | 16384 | 338 | 16046 | 1 | 0 | 1 | 6 | |
test19 | voiture | 34 | 1085337264 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 807283488 | 0 | 0 | 0 | 5 | 397237632 | 32768 | 842 | 31926 | 2 | 0 | 2 | 14 | |
vedettfak | megye | 25 | 968292336 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1053754944 | 0 | 0 | 0 | 5 | 61066368 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
dbv2 | taxi_bizz | 0 | 0 | 30 | 951029904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 370611120 | 6 | 50494908816 | 16384 | 1320 | 15064 | 1 | 0 | 0 | 30 | |
test19 | ecurie | 28 | 889961952 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 912273648 | 0 | 0 | 0 | 5 | 51318960 | 16384 | 171 | 16213 | 1 | 0 | 1 | 4 | |
dbv2 | admin_log | 0 | 0 | 3 | 513243984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 1975394784 | 6 | 53108737440 | 16384 | 254 | 16130 | 1 | 0 | 1 | 3 | |
sakila | category | 25 | 148755552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 902687808 | 0 | 0 | 0 | 5 | 35784144 | 16384 | 487 | 15897 | 1 | 0 | 1 | 16 | |
dbv2 | others | 0 | 0 | 1 | 116823168 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 164805168 | 6 | 62324881872 | 16384 | 40 | 16344 | 1 | 0 | 1 | 1 | |
sakila | film_category | 26 | 81941376 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 986949744 | 0 | 0 | 0 | 5 | 23512896 | 81920 | 33036 | 48884 | 5 | 0 | 5 | 1002 | |
dbv2 | hotels | 0 | 0 | 72 | 75782256 | 0 | 0 | 0 | 0 | 2 | 342 | 6889872 | 82 | 2693 | 84931440 | 8 | 63602352 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
dbv2 | money_log | 0 | 0 | 14 | 69326400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 132501600 | 6 | 57889399920 | 16384 | 924 | 15460 | 1 | 0 | 1 | 14 | |
dbv2 | actors | 0 | 0 | 5 | 66248160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 154365024 | 6 | 57910307664 | 16384 | 347 | 16037 | 1 | 0 | 1 | 5 |
|