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 | 16044 | 70429470672 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 1114112 | 18530740800 | 0 | 0 | 0 | 5 | 20331696 | 1015808 | 835288 | 180520 | 62 | 60 | 62 | 16079 | |
world | City | 29423 | 28933721520 | 0 | 0 | 0 | 0 | 0 | 0 | 29383 | 1968919 | 24002454960 | 0 | 0 | 0 | 12 | 123913152 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | rental | 20625 | 16667390256 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 376832 | 8401935168 | 0 | 0 | 0 | 5 | 54611568 | 278528 | 192784 | 85744 | 17 | 16 | 17 | 16060 | |
world | CountryLanguage | 268 | 6485007408 | 0 | 0 | 0 | 0 | 0 | 0 | 260 | 10469 | 7162219152 | 0 | 0 | 0 | 9 | 61846752 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | film | 1078 | 5038716144 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 3575596992 | 0 | 0 | 0 | 5 | 20681760 | 212992 | 155213 | 57779 | 13 | 11 | 11 | 1006 | |
sakila | inventory | 5633 | 4669423440 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 4738768848 | 0 | 0 | 0 | 5 | 20943648 | 262144 | 174254 | 87890 | 16 | 0 | 14 | 4588 | |
sakila | customer | 26 | 4588360128 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 4719913440 | 0 | 0 | 0 | 5 | 35295744 | 49152 | 12964 | 36188 | 3 | 0 | 3 | 348 | |
sakila | city | 52 | 4135763808 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 4293102528 | 0 | 0 | 0 | 5 | 36651120 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
sakila | language | 25 | 3861643104 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3854710464 | 0 | 0 | 0 | 5 | 39511296 | 16384 | 264 | 16120 | 1 | 0 | 1 | 6 | |
dhruv | CUSTOMER | 98 | 1089823152 | 2 | 710090304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 429928224 | 7 | 56516968464 | 16384 | 129 | 16255 | 1 | 0 | 1 | 2 | |
sakila | film_category | 1016 | 1732501056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1716689040 | 0 | 0 | 0 | 5 | 18176400 | 16384 | 8000 | 8384 | 1 | 0 | 1 | 1000 | |
dhruv | SUPPLIER | 95 | 1360074672 | 2 | 360147216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 575501520 | 7 | 66030219024 | 16384 | 114 | 16270 | 1 | 0 | 1 | 2 | |
dhruv | CONTRACTS | 66 | 896054544 | 3 | 419762640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 327680 | 528903408 | 10 | 201178768032 | 65536 | 318 | 65218 | 4 | 0 | 4 | 3 | |
dhruv | PRODUCT | 89 | 1073395488 | 2 | 189223056 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 449596224 | 7 | 61740670464 | 16384 | 64 | 16320 | 1 | 0 | 1 | 2 | |
sakila | country | 77 | 1203247056 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1088492592 | 0 | 0 | 0 | 5 | 45731136 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | category | 17 | 1126731936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1334922864 | 0 | 0 | 0 | 5 | 37121040 | 16384 | 487 | 15897 | 1 | 0 | 1 | 16 | |
sakila | address | 26 | 848176032 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1092203904 | 0 | 0 | 0 | 5 | 23988096 | 32768 | 7505 | 25263 | 2 | 0 | 2 | 102 | |
vedettfak | megye | 3 | 799991808 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 956366400 | 0 | 0 | 0 | 5 | 48736512 | 16384 | 655 | 15729 | 1 | 0 | 1 | 19 | |
world | Country | 356 | 799086816 | 0 | 0 | 0 | 0 | 0 | 0 | 352 | 91812 | 1742466528 | 0 | 0 | 0 | 8 | 67008480 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
registration66141118 | student118 | 86 | 443739648 | 5 | 295803024 | 0 | 0 | 0 | 0 | 84 | 2632 | 89410464 | 15 | 777 | 130094448 | 61 | 400461072 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sys | sys_config | 5 | 718645488 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 934432752 | 0 | 0 | 0 | 5 | 42548352 | 16384 | 338 | 16046 | 1 | 0 | 0 | 6 | |
sakila | store | 2 | 717420000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 770450208 | 0 | 0 | 0 | 5 | 43762224 | 16384 | 14 | 16370 | 1 | 0 | 1 | 2 | |
Продуктовый магазин | Товары | 68 | 504186144 | 1 | 36273600 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
students | record 2019 | 20 | 378709584 | 3 | 105459552 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 16384 | 108 | 16276 | 1 | 0 | 0 | 3 | |
registration66141118 | major999 | 63 | 338767440 | 3 | 57201936 | 0 | 0 | 0 | 0 | 38 | 1415 | 47300352 | 12 | 666 | 46138752 | 35 | 152803200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|