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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys | sys_config | 1 | 8618341776 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1402710144 | 0 | 0 | 0 | 5 | 1304950944 | 16384 | 338 | 16046 | 1 | 0 | 1 | 6 | |
sakila | film | 103 | 5320835520 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5586408960 | 0 | 0 | 0 | 5 | 38062992 | 212992 | 155213 | 57779 | 13 | 0 | 10 | 1006 | |
sakila | country | 77 | 4361424144 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 4068439056 | 0 | 0 | 0 | 5 | 80262336 | 16384 | 3739 | 12645 | 1 | 0 | 0 | 110 | |
sakila | address | 27 | 2585428560 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 4105920720 | 0 | 0 | 0 | 5 | 54818544 | 98304 | 51858 | 46446 | 6 | 0 | 5 | 605 | |
sakila | inventory | 26 | 2279068176 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 4431795984 | 0 | 0 | 0 | 5 | 27731088 | 212992 | 136174 | 76818 | 13 | 0 | 12 | 2684 | |
sakila | actor | 2 | 1952218752 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2125816704 | 0 | 0 | 0 | 5 | 35076624 | 32768 | 10353 | 22415 | 2 | 0 | 2 | 200 | |
sales | user | 108 | 1174646352 | 3 | 436605840 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 191618592 | 6 | 57074289888 | 16384 | 166 | 16218 | 1 | 0 | 0 | 3 | |
sakila | language | 75 | 1360930032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 996503904 | 0 | 0 | 0 | 5 | 53876592 | 16384 | 264 | 16120 | 1 | 0 | 0 | 6 | |
sakila | city | 52 | 1066160832 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1152937104 | 0 | 0 | 0 | 5 | 37028112 | 65536 | 26640 | 38896 | 4 | 0 | 1 | 601 | |
sakila | customer | 26 | 471450144 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1983804768 | 0 | 0 | 0 | 5 | 28050528 | 98304 | 53205 | 45099 | 6 | 0 | 5 | 601 | |
productos | tblProductoVenta | 0 | 0 | 3 | 375545280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 472885776 | 10 | 123020031024 | 49152 | 180 | 48972 | 3 | 0 | 0 | 3 | |
SAILORS | BOATS | 2 | 83628864 | 1 | 29244864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 346203792 | 7 | 61018807344 | 16384 | 37 | 16347 | 1 | 0 | 0 | 1 | |
SAILORS | Sailors | 2 | 30719568 | 1 | 66962544 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 442368 | 852010368 | 13 | 132522152400 | 32768 | 39 | 32729 | 2 | 0 | 0 | 1 | |
productos | tblVentas | 0 | 0 | 9 | 95895888 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 196169952 | 7 | 91346840112 | 16384 | 225 | 16159 | 1 | 0 | 0 | 9 | |
productos | tblProductos | 0 | 0 | 7 | 59810784 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 275564256 | 7 | 71773018416 | 16384 | 248 | 16136 | 1 | 0 | 0 | 7 | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1523712 | 1138409 | 385303 | 93 | 55 | 20 | 4268 | |
mysql | help_topic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1146880 | 895566 | 251314 | 70 | 0 | 70 | 655 | |
sakila | rental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 884736 | 12997529952 | 0 | 0 | 0 | 5 | 31541664 | 786432 | 689635 | 96797 | 48 | 0 | 48 | 16091 | |
mysql | tables | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 753664 | 539402 | 214262 | 46 | 37 | 0 | 428 | |
sakila | payment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 835584 | 8063080608 | 0 | 0 | 0 | 5 | 38640624 | 737280 | 642468 | 94812 | 45 | 0 | 45 | 16093 | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 160134 | 134778 | 18 | 3 | 0 | 1716 | |
mysql | routines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 294912 | 148799 | 146113 | 18 | 0 | 4 | 56 | |
sakila | film_actor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 1788453744 | 0 | 0 | 0 | 5 | 25384128 | 196608 | 142155 | 54453 | 12 | 0 | 12 | 5473 | |
mysql | help_keyword | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 163840 | 91559 | 72281 | 10 | 0 | 8 | 558 | |
mysql | innodb_index_stats | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 163840 | 80893 | 82947 | 10 | 0 | 0 | 801 |
|