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 | 80246 | 176149686768 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 1146880 | 12702598656 | 0 | 0 | 0 | 5 | 38143248 | 1048576 | 843056 | 205520 | 64 | 60 | 2 | 11041 | |
sakila | film_category | 169064 | 139711483296 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 684500784 | 0 | 0 | 0 | 5 | 22825968 | 81920 | 33036 | 48884 | 5 | 0 | 4 | 1002 | |
sakila | film | 158154 | 75610932672 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1640870352 | 0 | 0 | 0 | 5 | 22187088 | 212992 | 155213 | 57779 | 13 | 11 | 10 | 1006 | |
sakila | rental | 103125 | 39171355344 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 5602670304 | 0 | 0 | 0 | 5 | 22682352 | 278528 | 192784 | 85744 | 17 | 16 | 0 | 16060 | |
sakila | film_actor | 165200 | 27708729840 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1553942544 | 0 | 0 | 0 | 5 | 29836752 | 196608 | 142155 | 54453 | 12 | 10 | 12 | 5473 | |
sakila | inventory | 26907 | 13234200144 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4571918208 | 0 | 0 | 0 | 5 | 22079904 | 196608 | 96347 | 100261 | 12 | 0 | 7 | 4586 | |
world | City | 3 | 3114358368 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 459 | 1749448272 | 0 | 0 | 0 | 7 | 106211424 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | address | 108 | 3011990784 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 5195134560 | 0 | 0 | 0 | 5 | 20348064 | 98304 | 51858 | 46446 | 6 | 0 | 3 | 605 | |
sakila | category | 5203 | 2984854752 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 803559504 | 0 | 0 | 0 | 5 | 64043232 | 16384 | 487 | 15897 | 1 | 1 | 0 | 16 | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 24 | 2502705216 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 195 | 16189 | 1 | 0 | 0 | 3 | |
sakila | city | 238 | 2232302688 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1587683856 | 0 | 0 | 0 | 5 | 51586128 | 65536 | 26640 | 38896 | 4 | 0 | 0 | 601 | |
sakila | country | 483 | 2066559264 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1072031664 | 0 | 0 | 0 | 5 | 57709872 | 16384 | 3739 | 12645 | 1 | 1 | 0 | 110 | |
sakila | customer | 78 | 1972763760 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 2555842608 | 0 | 0 | 0 | 5 | 38980128 | 114688 | 58596 | 56092 | 7 | 0 | 4 | 600 | |
sakila | staff | 29 | 1400550096 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1231188816 | 0 | 0 | 0 | 5 | 46912272 | 16384 | 253 | 16131 | 1 | 0 | 0 | 2 | |
vedettfak | megye | 12 | 1300079616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1484844768 | 0 | 0 | 0 | 5 | 36714480 | 16384 | 655 | 15729 | 1 | 0 | 0 | 19 | |
zoo | Tier | 16 | 101552880 | 10 | 1123815792 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 6129600576 | 9 | 88217982864 | 32768 | 494 | 32274 | 2 | 0 | 0 | 10 | |
sakila | actor | 226 | 1219018416 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1408407264 | 0 | 0 | 0 | 5 | 37747776 | 32768 | 10353 | 22415 | 2 | 0 | 1 | 200 | |
sakila | language | 75 | 1148098512 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 763685472 | 0 | 0 | 0 | 5 | 100328448 | 16384 | 264 | 16120 | 1 | 0 | 0 | 6 | |
sakila | store | 6 | 1053546384 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1066125984 | 0 | 0 | 0 | 5 | 40635408 | 32768 | 66 | 32702 | 2 | 0 | 1 | 2 | |
sakila | film_text | 1 | 884442768 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 442 | 293556384 | 0 | 0 | 0 | 4 | 20533392 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
zoo | Art | 59 | 549196032 | 3 | 201414048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 603790704 | 7 | 64348702704 | 16384 | 88 | 16296 | 1 | 0 | 0 | 3 | |
sys | sys_config | 6 | 686474448 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 824447184 | 0 | 0 | 0 | 5 | 56154912 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
zoo | Gehege | 6 | 35561328 | 5 | 282030672 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 516201840 | 8 | 87651080880 | 32768 | 278 | 32490 | 2 | 0 | 0 | 5 | |
TlapaleriaMalfoy | Registro | 2 | 33963072 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4082709312 | 0 | 0 | 0 | 5 | 43895280 | 16384 | 126 | 16258 | 1 | 0 | 0 | 2 | |
Table_insertion | voiture | 1 | 33285648 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 3939163008 | 0 | 0 | 0 | 5 | 54999120 | 32768 | 842 | 31926 | 2 | 0 | 2 | 14 |
|